Segmentation Fault When Running Sqlplus and Tnsping From R12 10gR2 ORACLE_HOME

My co-worker has encountered a “Segmentation Fault” error while he tried to run sqlplus on a newly installed server which will host E-Business Suite R12 database. After a short search on My Oracle Support, he found MOS Document ID 1480089.1. Although this document explains the reason of the error, it seems there’s a missing step about the solution.

The MOS document says, compat-oracle-el5-1.0-5 RPM is installed but it shouldn’t be. This RPM causes, 10.1 executables (it seems it would affect any Oracle DB software version) are not being relinked correctly (they are not relinked with the -m32 parameter). So MOS asks to uninstall compat-oracle-el5-1.0-5, and my co-worker uninstalled the RPM but he still got the error.

It’s obvious that uninstall is not enough to fix the problem because the Oracle binaries are not linked correctly. So we need to relink the all Oracle binaries:

Another option would be re-install Oracle database software but relinking is a much faster.

Please share

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.

Leave Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.