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

expdp mcis01/mcis01 dumpfile=expdp.dmp directory=MCISDMP
 报如下错误：
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-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 1397
ORA-06512: at line 2

告警日志错误如下：
Sun Jan 20 13:10:57 2019
Errors in file /oracle/admin/orau10g/bdump/orau10g_dw01_3219612.trc:
ORA-00600: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], []

跟踪文件/oracle/admin/orau10g/bdump/orau10g_dw01_3219612.trc部分内容
/oracle/admin/orau10g/bdump/orau10g_dw01_3219612.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/product/10g/rdbms
System name:    AIX
Node name:      SHP59518
Release:        3
Version:        5
Machine:        00C9ADA44C00
Instance name: orau10g
Redo thread mounted by this instance: 1
Oracle process number: 38
Unix process pid: 3219612, image: oracle@SHP59518 (DW01)

*** ACTION NAME:(SYS_EXPORT_SCHEMA_05) 2019-01-20 13:10:53.369
*** MODULE NAME:(Data Pump Worker) 2019-01-20 13:10:53.369
*** SERVICE NAME:(SYS$USERS) 2019-01-20 13:10:53.369
*** SESSION ID:(621.1) 2019-01-20 13:10:53.369
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
[kdl_trim]: newlen: 0
Dynamic link error:     0509-022 Cannot load module /oracle/product/10g/rdbms/lib32/libxdb.so.
        0509-103   The module has an invalid magic number.
*** 2019-01-20 13:10:57.074
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], []
Current SQL statement for this session:
SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('CLUSTER_T', '7')), KU$.OBJ_NUM ,KU$.SCHEMA_OBJ.NAME ,KU$.SCH
EMA_OBJ.NAME ,'CLUSTER' ,KU$.SCHEMA_OBJ.OWNER_NAME FROM SYS.KU$_CLUSTER_VIEW KU$ WHERE NOT (BITAND (KU$.SCHEMA_OBJ.FLAGS,16)=
16) AND  KU$.SCHEMA_OBJ.OWNER_NAME=:SCHEMA1 AND  NOT EXISTS (SELECT 1 FROM  SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='CLUSTER' AND
 A.NAME=KU$.SCHEMA_OBJ.NAME AND A.SCHEMA=KU$.SCHEMA_OBJ.OWNER_NAME) AND NOT EXISTS (SELECT 1 FROM  SYS.KU$NOEXP_TAB A WHERE A
.OBJ_TYPE='SCHEMA' AND A.NAME=KU$.SCHEMA_OBJ.OWNER_NAME)

其中“0509-103   The module has an invalid magic number”是aix上系统错误，意思是类库位数不对。
echo $LIBPATH
发现32位类库在前，aix是从前向后搜索文件名。因先找到32位的libxdb.so，所以报错。
在profile修改环境变量

在aix中进程在启动的时候读取环境变量，因此需要重新启动数据库。有些资料说重启lisener。但这个场景不行，因为dw进程的父进程不是listener

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15711267/viewspace-777050/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15711267/viewspace-777050/