執行sqlplus遭遇Segmentation Fault

        因為要升級硬體,   需要重新安裝一臺Oracle 9.2.0.8 的資料庫,    一直都是使用10g, 11g,   好久都沒有在Linux 4.5 下安裝Oracle 9i 的軟體,    雖然按照文件來做,    還是碰到了不少的問題,    最後碰到的就是下面的這個問題 ,   在oracle_home 下bin 目錄下檢視居然沒有 sqlplus 執行檔案,    當然執行 sqlplus 命令也是報錯  Segmentation Fault ,    網路上搜尋了一下,     解決方法倒是蠻簡單 .   

 

Segmentation Fault When Execute Sqlplus, Oracle, Lsnrctl After New/Patchset Install [ID 316746.1]
		修改時間 24-JUL-2010     型別 PROBLEM     狀態 MODERATED

In this Document
  
  
  
  

---

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Standard Edition - Version: 9.2.0.1 to 10.1.0.2 - Release: 9.2 to 10.1
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.1.0.2   [Release: 9.2 to 10.1]
Linux x86
Linux x86-64
Checked for relevance on 24-Jul-2010

Symptoms

After fresh install and latest patchset 9.2.0.6.0 on Linux x86_64 every attempt to use sqlplus, lsnrctl fails with an segmentation fault.

Changes

New install or patchset apply.

Cause

The gcc/g++ compilers in /usr/bin are a script. (with additional parameters)
which caused an incorrect compilation.

make.log shows this incorrect compilation:
/tpp/oracle/920/bin/genclntsh
/usr/bin/ld: skipping incompatible /usr/lib/gcc-lib/i386-redhat-linux/2.96/libgcc.a when
searching for -lgcc
/usr/bin/ld: skipping incompatible /usr/lib/gcc-lib/i386-redhat-linux/2.96/libgcc.a when
searching for -lgcc
/usr/bin/ld: warning: i386 architecture of input file
`/usr/lib/gcc-lib/i386-redhat-linux/2.96/crtbeginS.o' is incompatible with i386:x86-64 output
/usr/bin/ld: warning: i386 architecture of input file
`/usr/lib/gcc-lib/i386-redhat-linux/2.96/crtendS.o' is incompatible with i386:x86-64 output.

Solution

To implement the solution, please execute the following steps:

1. cd /usr/bin (as root)
2. mv gcc gcc.script
3. mv g++ g++.script
4. ln -s gcc32 gcc
5. ln -s g++32 g++
6. login as oracle software owner (make sure environment is correct)
7. cd $ORACLE_HOME/bin
8. relink all