Export: Release 10.2.0.3.0 - Production on Wed Oct 3 11:52:37 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options Export done in WE8ISO8859P9 character set and AL16UTF16 NCHAR character set About to export specified users ... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user PARITEM . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user PARITEM About to export PARITEM's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions EXP-00056: ORACLE error 600 encountered ORA-00600: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], [] EXP-00000: Export terminated unsuccessfully
It seems there is a problem with the XDB library. When i select from dba_registry to see the components and the statuses, i realized there is a problem with the XML Database component. After investigation and searching the metalink, i came up to the a document which explains how to recreate the XML database (please see the end of the post for the related resources)
--INVALID XML Database component SQL> col comp_name format a30 SQL> set pagesize 100 SQL> select comp_name, status, version from dba_registry; COMP_NAME STATUS VERSION ------------------------------ ----------- ------------------------------ Oracle9i Catalog Views VALID 9.2.0.7.0 Oracle9i Packages and Types VALID 9.2.0.7.0 Oracle Workspace Manager VALID 9.2.0.1.0 JServer JAVA Virtual Machine VALID 9.2.0.7.0 Oracle XDK for Java VALID 9.2.0.9.0 Oracle9i Java Packages VALID 9.2.0.7.0 Oracle Text VALID 9.2.0.7.0 Oracle XML Database INVALID 9.2.0.7.0 Spatial VALID 9.2.0.7.0 Oracle Ultra Search VALID 9.2.0.7.0 Oracle Data Mining VALID 9.2.0.7.0 OLAP Analytic Workspace UPGRADED 9.2.0.7.0 Oracle OLAP API UPGRADED 9.2.0.7.0 OLAP Catalog VALID 9.2.0.7.0 14 rows selected. -- Dropping xml database SQL> @?/rdbms/admin/catnoqm.sql; SQL> drop trigger sys.xdb_installation_trigger; SQL> drop trigger sys.dropped_xdb_instll_trigger; SQL> drop table dropped_xdb_instll_tab; -- Recreating the xml database SQL> startup migrate; SQL> @?/rdbms/admin/catproc.sql; SQL> @?/rdbms/admin/catqm.sql; SQL> @?/rdbms/admin/dbmsxsch.sql; SQL> @?/rdbms/admin/catxdbj.sql; -- only in 9i SQL> @?/rdbms/admin/xdbpatch; SQL> select comp_name, status, version from dba_registry; COMP_NAME STATUS VERSION ------------------------------ ----------- ------------------------------ Oracle9i Catalog Views VALID 9.2.0.7.0 Oracle9i Packages and Types VALID 9.2.0.7.0 Oracle Workspace Manager VALID 9.2.0.1.0 JServer JAVA Virtual Machine VALID 9.2.0.7.0 Oracle XDK for Java VALID 9.2.0.9.0 Oracle9i Java Packages VALID 9.2.0.7.0 Oracle Text VALID 9.2.0.7.0 Oracle XML Database VALID 9.2.0.7.0 Spatial VALID 9.2.0.7.0 Oracle Ultra Search VALID 9.2.0.7.0 Oracle Data Mining VALID 9.2.0.7.0 OLAP Analytic Workspace UPGRADED 9.2.0.7.0 Oracle OLAP API UPGRADED 9.2.0.7.0 OLAP Catalog VALID 9.2.0.7.0 14 rows selected. Re run the export now !...
resources:
http://www.oratransplant.nl/2005/11/22/unable-to-export-char-semantic-102-database/
Note:339938.1 - Full Export From 10.2.0.1 Aborts With EXP-56 ORA-932 (Inconsistent Datatypes) EXP-0
Note:243554.1 - How to Deinstall and Reinstall XML Database (XDB)
