而設置LD_LIBRARY_PATH后，問題解決：[orat3@hpserver2?~]$?export?LD_LIBRARY_PATH=$ORACLE_HOME/lib

[orat3@hpserver2?~]$?sqlplus?/?AS?sysdba

SQL*Plus:?Release?10.2.0.4.0?-?Production?ON?Sun?Mar?18?16:10:57?2012

Copyright?(c)?1982,?2007,?Oracle.?ALL?Rights?Reserved.

Connected?TO:

Oracle?DATABASE?10g?Enterprise?Edition?Release?10.2.0.4.0?-?64bit?Production

WITH?the?Partitioning,?OLAP,?DATA?Mining?AND?REAL?Application?Testing?options

SQL>

還有一種類似的錯誤：[orat0@hpserver2?~]$?sqlplus?/?AS?sysdba

SQL*Plus:?Release?10.2.0.5.0?-?Production?ON?Sun?Mar?18?16:12:03?2012

Copyright?(c)?1982,?2010,?Oracle.?ALL?Rights?Reserved.

oracleorcl10g:?error?while?loading?shared?libraries:?libskgxp10.so:?cannot?OPEN?shared?object?file:?No?such?file?OR?directory

ERROR:

ORA-12547:?TNS:lost?contact

Enter?user-name:

oracleorcl10g:?error?while?loading?shared?libraries:?libskgxp10.so:?cannot?OPEN?shared?object?file:?No?such?file?OR?directory

ERROR:

ORA-12547:?TNS:lost?contact

Enter?user-name:

oracleorcl10g:?error?while?loading?shared?libraries:?libskgxp10.so:?cannot?OPEN?shared?object?file:?No?such?file?OR?directory

ERROR:

ORA-12547:?TNS:lost?contact

SP2-0157:?unable?TO?CONNECT?TO?ORACLE?after?3?attempts,?exiting?SQL*Plus

[orat0@hpserver2?~]$?export?LD_LIBRARY_PATH=$ORACLE_HOME/lib

[orat0@hpserver2?~]$?sqlplus?/?AS?sysdba

SQL*Plus:?Release?10.2.0.5.0?-?Production?ON?Sun?Mar?18?16:12:18?2012

Copyright?(c)?1982,?2010,?Oracle.?ALL?Rights?Reserved.

Connected?TO:

Oracle?DATABASE?10g?Enterprise?Edition?Release?10.2.0.5.0?-?64bit?Production

WITH?the?Partitioning,?OLAP,?DATA?Mining?AND?REAL?Application?Testing?options

SQL>

錯誤的表相雖然不同，但是解決方法是相同的。

總結

以上是生活随笔為你收集整理的oracle_home path,ORACLE_HOME迁移后需要设置LD_LIBRARY_PATH环境变量的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。