« 2011年4月 ACOUG Exadata技术交流会 | Blog首页 | [Jobs]招聘开发工程师 系统架构师 测试工程师 »
环境变量与ORA-00600 unable to load XDB library
作者:eygle | 【转载请注出处】|【云和恩墨 领先的zData数据库一体机 | zCloud PaaS云管平台 | SQM SQL审核平台 | ZDBM 数据库备份一体机】
链接:https://www.eygle.com/archives/2011/04/ora-00600_libxdb.html
在AIX环境中,如果环境变量设置顺序存在问题,可能会导致数据库运行出错,正常情况下LIBPATH的lib路径应当在lib32之前:链接:https://www.eygle.com/archives/2011/04/ora-00600_libxdb.html
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
历史上的今天...
>> 2017-04-25文章:
>> 2013-04-25文章:
>> 2010-04-25文章:
>> 2008-04-25文章:
>> 2007-04-25文章:
>> 2006-04-25文章:
>> 2005-04-25文章:
By eygle on 2011-04-25 08:02 | Comments (1) | Case | 2790 |
在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