ORA-00600 unable to load XDB library

来源：互联网发布：python pyqt安装编辑：程序博客网时间：2024/06/04 19:11

数据库环境： AIX6.1 10.2.0.5

问题描述：

alert.log 中报错：

    Wed Nov 02 10:00:57 GMT+08:00 2011Errors in file /oracle/admin/db/udump/db_ora_9044064.trc:
    ORA-00600: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], []
    Wed Nov 02 10:00:58 GMT+08:00 2011Errors in file /oracle/admin/dbudump/db_ora_9044064.trc:
    ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
    Wed Nov 02 10:00:58 GMT+08:00 2011Errors in file /oracle/admin/db/udump/db_ora_9044064.trc:
    ORA-00600: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], []

trace ：

initializing SGA: sga_pass1Dynamic link error: 0509-022 Cannot load module /oracle/product/10.2.0/db_1
/lib32/libxdb.so.
        0509-103   The module has an invalid magic number.
*** 2011-11-02 10:00:54.125
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], []
Current SQL statement for this session:
select count(*) from user$ u, xdb.xdb$schema s where u.user# = :1 and   u.name = s.xmldata.schema_
owner and (xdb.xdb$Extname2Intname(s.xmldata.schema_url, s.xmldata.schema_owner) = :2)
----- PL/SQL Call Stack -----
object      line object
handle    number name
70000020c8df158         1 function XDB.XDB$EXTNAME2INTNAME
70000020e4a6840         1 anonymous block
7000001e6ee89b8        17 package body SYS.XML_SCHEMA_NAME_PRESENT

问题原因：

ID 759401.1

On AIX5L, LIBPATH needs to be configured and the 64-bit library path ($ORACLE_HOME/lib) should be placed before the 32-bit library path ($ORACLE_HOME/lib32).

而我们的是：export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib

问题解决：

-- To implement the solution, please execute the following steps::
1. Shutdown the Oracle database.
2. Configure LIBPATH correctly.

$ unset LD_LIBRARY_PATH
$ unset LIBPATH

$ export LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32

3.startup database