ORA-00600: internal error code, arguments: [unable to load XDB library], [], [],

最近在EXP一用户的数据时出现如下错误：

ORA-00600: internal error code, arguments: [unable to load XDB library], [], [],

在GOOGLE上查找了一下，原来是LD_LIBRARY_PATH这个环境变量设错了，将其设置为：

LD_LIBRARY_PATH=/opt/app/ oracle /10g/lib

问题解决！

相关文档：Metalink Doc ID(351650.1)

Applies to:
———————-
Enterprise Manager for RDBMS - Version: 9.2.0 to 10.2.0
oracle Server - Enterprise Edition - Version: 9.2.0 to 10.2.0
oracle Server - Personal Edition - Version: 9.2.0 to 10.2.0
oracle Server - Standard Edition - Version: 9.2.0 to 10.2.0
Solaris Operating System (SPARC 64-bit)
This problem can occur on any Unix platform.
Symptoms
A full database export or a user level export with the original export utility aborts with:

. exporting cluster definitionsEXP-00056: oracle error 600 encounteredORA-00600: internal error code, arguments: [qmtInit1], [], [], [], [], [], [], []EXP-00000: Export terminated unsuccessfull
or:

…. exporting cluster definitionsEXP-00056: oracle error 600 encounteredORA-00600: internal error code, arguments:
[unable to load XDB library], [], [], [], [], [], [], []ORA-06512: at “SYS.DBMS_METADATA”, line 1511ORA-06512:
at “SYS.DBMS_METADATA”, line 1548ORA-06512: at “SYS.DBMS_METADATA”, line 1864ORA-06512: at “SYS.DBMS_METADATA”,
line 3707ORA-06512: at “SYS.DBMS_METADATA”, line 3689ORA-06512: at line 1EXP-00000: Export terminated unsuccessfully

Or when exporting in Oracle10g with the export DataPump utility (expdp), the job aborts with:

…ORA-39014: One or more workers have prematurely exited.ORA-39029: worker 1 with process name “DW01″
prematurely terminatedORA-31671: Worker process DW01 had an unhandled exception.ORA-00600: internal error code, arguments:
[qmtInit1], [], [], [], [], [], [], []ORA-06512: at “SYS.KUPW$WORKER”, line 1345ORA-06512: at line 2Job “SYSTEM”.”SYS_EXPORT_FULL_01″ stopped due to fatal error at 16:12:31
or:

…ORA-39014: One or more workers have prematurely exited.ORA-39029: worker 1 with process name “DW01″
prematurely terminatedORA-31671: Worker process DW01 had an unhandled exception.ORA-00600: internal error code, arguments:
[unable to load XDB library], [], [], [], [], [], [], []ORA-06512: at “SYS.KUPW$WORKER”, line 1276ORA-06512: at line 2Job “SYSTEM”.”SYS_EXPORT_SCHEMA_16″ stopped due to fatal error at 16:22:42
@.
@ Possible stack traces:
@.
@ For ORA-600 [qmtInit1], [], [], [], [], [], [], []
@.
@ ksedst ksedmp ksfdmp kgerinv kgeasnmierr qmtInit qmtLookup qmtAddRef
@ qmxtgrGetSchemaProp qmxtgrCheckMkXML qctoxXMLGetTypeInfo qctoxmlexval
@ qctcopn qctsvcti qctcopn xtyopn kokvbwoc kokvaroid kkmevw kkmfcbvw
@ kkmfcblo kkmpfcbk qcsprfro qcsprfro_tree qcspafq qcspqb kkmdrv opiSem
@ opiDeferredSem opitca kksFullTypeCheck rpiswu2 kksSetBindType kksfbc
@ opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o
@ opimai_real main libc_start_main
@.
@ For ORA-600 [unable to load XDB library], [], [], [], [], [], [], []
@.
@ ksfdmp kgerinv kgeasnmierr sqmtbGetSharedData qmtLoadSharedData
@ qmtbInit qmtInit qm_init_sga_pass1 qm_init_uga qmkmgetParameter
@ qmrvsi_int qmrvsi qmrvsi1 spefcpfa spefmccallstd pextproc
@ pgmcetc_execute_tru sted_c pgmccc_call_c pciccc_call_c kkxmcexe
@ kgmexcb kkxmswu kgmexwi kgmexec evapls evaopnc rpiswu2 evaopn2 qximeop
@ qeroiStart qertbStart selexe opiexe opiall0 kpoal8 opiodr ttcpip
@ opitsk opiino opiodr opidrv sou2o main
@ .

Cause
—————–
These errors may be the result if the database was started and the environment variable LD_LIBRARY_PATH was not set, or was set to an incorrect version of $ORACLE_HOME/lib (e.g. to a different $ORACLE_HOME). If during the user level or full database export we are unable to locate the correct version of the libxdb.so / libxdb.sl library, the internal errors may occur.

Solution
——————
1. Stop the database and stop the listener.

2. Set LD_LIBRARY_PATH so the first directory referenced is $ORACLE_HOME/lib
Example (replace $ORACLE_HOME with the full path of the oracle home directory):

csh:$ setenv LD_LIBRARY_PATH=$ORACLE_HOME/lib$ setenv LIBPATH=$ORACLE_HOME/lib
ksh:$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib$ export LIBPATH=$ORACLE_HOME/lib
For Oracle9i and Oracle10g on AIX: set environment variable LIBPATH and afterwards, run /usr/sbin/slibclean as root
For Oracle9i and Oracle10g on HP-UX, Linux, Solaris, and Tru64: set environment variable LD_LIBRARY_PATH

3. Re-start the database and the listener.

4. Re-run the export.