sqlplus直连数据库出现ORA-27504错误

客户数据库使用sqlplus直连方式连接数据库报错,而如果使用tnsnames方式则可以正常连接。
详细错误信息为:

Thu Apr 26 10:17:56 2012
Errors IN file /oracle/admin/trs/udump/trs2_ora_2619.trc:
ORA-00603: ORACLE server SESSION TERMINATED BY fatal error
ORA-27504: IPC error creating OSD context
ORA-27300: OS system dependent operation:IPC init failed WITH STATUS: 65
ORA-27301: OS failure message: Package NOT installed
ORA-27302: failure occurred at: skgxpcini
ORA-27303: additional information: libskgxpd.so called
libskgxp10.so should reference REAL implementation.

根据MOS文档,这个问题的原因是由于环境变量中指定了CRS的目录,导致部分LIB没有找到:sqlplus Local connection to Instance is not possible , remote Using tns is fine . [ID 859778.1]。
解决问题的方法是在环境变量SHLIB_PATH和LIBPATH中,去掉CRS的HOME信息,使得Oracle正确找到ORACLE_HOME下的LIB目录。

This entry was posted in BUG and tagged , , , , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *