eygle Eygle.
Case 2011-04-25

环境变量与ORA-00600 unable to load XDB library

在AIX环境中,如果环境变量设置顺序存在问题,可能会导致数据库运行出错,正常情况下LIBPATH的lib路径应当在lib32之前:
export LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32

如果位置颠倒,则会出现类似如下错误:
ERROR
ORA-00600: internal error code, arguments: [unable to load XDB library]

----- Call Stack Trace -----
ksedst <- ksedmp <- ksfdmp <- kgerinv <- kgeasnmierr
<- sqmtbGetSharedData <- 0088 <- qmtLoadSharedData <- 074 <- qmtbInit
<- qmtInit <- qmtLookup <- qmtAddRef <- qmxtgrGetSchemaProp <-
qmxtgrCheckMkXML
<- qmxtrCheckRewrite <- 184 <- qmxtrxopn <- qmxtrxopt <- qmxtrxq
<- qmxtrxop <- koksspend <- kkmdrvend <- kkmdrv <- opiSem
<- opiprs <- kksParseChildCursor <- rpiswu2 <- kksLoadChild <-
kxsGetRuntimeLock
<- c74 <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0
<- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- main <- start

或者:
Dynamic link error:     
0509-022 Cannot load module /app/oracle/product/10.2.0.3/db/lib32/libxdb.so.            
0509-103   The module has an invalid magic number.    

ksedmp: internal or fatal error    
ORA-600: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], []    
Current SQL statement for this session:    
SELECT DBMS_XDB.CheckPrivileges( '/xdbconfig.xml', XMLType( '<privilege<read-properties/><read-contents/></privilege>') )    
FROM DUAL    
----- PL/SQL Call Stack -----      
object      line  object      handle    number  name    
7000001255fab08       301  SYS.XMLTYPE    
70000010b5f8a20         1  anonymous block

修改环境变量,重新启动可以消除这个错误。

参考MOS: 759401.1

By eygle 2011-04-25 08:02 评论 (1)
eygle
eygle

前Oracle ACE Director,云和恩墨创始人。技术为骨,历史为脉,人文为魂。

返回首页

1 Comment

在RAC环境里面怎么设置呢?
我现在遇到不会了,我的是aix6.1,10204的系统;遇到这个错误;
ORA-00600: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], []
我的profile的设置是这样的。有oracle_home 和ora_crs_home的LIBPATH;
export umask=022
export ORACLE_HOSTNAME=srdb1
export ORACLE_BASE=/oracle/app
export ORACLE_HOME=$ORACLE_BASE/10.2/db_1
export ORA_CRS_HOME=/oracle/app/crs
export ORACLE_SID=srsdb1
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_TERM=vt100
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
#export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/lib32
#export LIBPATH=$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH
export PS1=`whoami`@`hostname`:['$PWD']" "
export PATH=/oracle/app/crs/bin:$PATH
export PATH=/oracle/app/10.2/db_1/OPatch:/usr/ccs/bin:$PATH
export LD_LIBRARY_PATH=$ORA_CRS_HOME/lib32:/lib:/usr/lib:$ORA_CRS_HOME/rdbms/lib:$ORA_CRS_HOME/lib
export LIBPATH=$LD_LIBRARY_PATH
~
请问我要怎么改呢?

-----ricky