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

fudaliang1999發表於2013-11-20

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: (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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章