ORA-00600 unable to load XDB library

数据库环境： 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