Expdp ORA-600 unable to load XDB library-优快云博客

今天导数据碰到如下错误：

Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
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
Job "SYS"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 23:09:06

[@more@]

根据alert日志得到相应的trace文件，trace 文件里发现一条SQL，
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$.SCHEMA_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 IN (SELECT
object_name FROM "SYS"."SYS_EXPORT_SCHEMA_01" WHERE process_order = -55 AND duplicate BETWEEN 1 AND 13) 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)

看不懂trace接下来的东西，只好网上查一下，给出的方法是设置环境变量LD_LIBRARY_PATH=$ORACLE_HOME/lib, LIBPATH=$ORACLE_HOME/lib,但还是遇到上面的错误。Metalink上找到一文档：736049.1，给出的解决方法是，重新生成一些 DATAPUMP API用到的视图：
@?/rdbms/admin/catmeta.sql
@?/rdbms/admin/catmet2.sql
@?/rdbms/admin/utlrp.sql

expdp就可以正常导数据了，在导到过程中碰到一张表很慢，最后一个字段是long raw,这个问题上次碰到，原因是用了parallel,修正的办法是加上参数access_method=direct_path.

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

转载于:http://blog.itpub.net/45188/viewspace-1033037/