/testc/qual/orasw10/app/oracle/admin/testdummy6/scripts (Dummy_server) $ cat export.sh export ORACLE_HOME=/testc/qual/orasw10/app/oracle/product/10.2.0.3 export PATH=/testc/qual/orasw10/app/oracle/product/10.2.0.3/bin:$PATH export ORACLE_SID=testdummy6 exp userid=system/**** owner=stscorp file=/testc/qual/testdummy6/arch/stscorp.dmp consistent=y STATISTICS=Noneand i have hit below error.
Export: Release 10.2.0.4.0 - Production on Tue May 1 14:20:29 2012 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application testing options Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion) About to export specified users ... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user dummy_schema . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user dummy_schema About to export dummy_schema's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitionsWarning: Entry/Exit code is optimized. Cannot restore context (UNWIND 22) EXP-00056: ORACLE error 600 encountered ORA-00600: internal error code, arguments: [qmtGetColumnInfo1], [], [], [], [], [], [], [] EXP-00000: Export terminated unsuccessfully
I check that is there any cluster tables are in schema or not.
SQL> SELECT OWNER,SEGMENT_NAME,TABLESPACE_NAME FROM DBA_SEGMENTS WHERE SEGMENT_TYPE='CLUSTER'; OWNER SEGMENT_NAME TABLESPACE_NAME ------------------------------ -------------------- ------------------------------ SYS C_USER# SYSTEM SYS C_TS# SYSTEM SYS C_OBJ# SYSTEM SYS C_FILE#_BLOCK# SYSTEM SYS C_COBJ# SYSTEM SYS C_MLOG# SYSTEM SYS C_TOID_VERSION# SYSTEM SYS C_RG# SYSTEM SYS C_OBJ#_INTCOL# SYSTEM SYS SMON_SCN_TO_TIME SYSTEM
so i have open alert log, and found below contents.
Tue May 1 14:20:37 2012 Errors in file /testc/qual/testdummy6/admin/udump/testdummy6_ora_17082.trc: ORA-00600: internal error code, arguments: [qmtGetColumnInfo1], [], [], [], [], [], [], []
Below is call stack from trace file.
/testc/qual/testdummy6/admin/udump/testdummy6_ora_17082.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 = /testc/qual/orasw10/app/oracle/product/10.2.0.4_2
System name: HP-UX
Node name: Dummy_server
Release: B.11.11
Version: U
Machine: 9000/800
Instance name: testdummy6
Redo thread mounted by this instance: 1
Oracle process number: 25
Unix process pid: 17082, image: oracle@Dummy_server (TNS V1-V3)
*** ACTION NAME:() 2012-05-01 14:20:37.159
*** MODULE NAME:(exp@Dummy_server (TNS V1-V3)) 2012-05-01 14:20:37.159
*** SERVICE NAME:(SYS$USERS) 2012-05-01 14:20:37.159
*** SESSION ID:(142.3367) 2012-05-01 14:20:37.159
*** 2012-05-01 14:20:37.159
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qmtGetColumnInfo1], [], [], [], [], [], [], []
No current SQL statement being executed.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+40 ? ksedst1() 4000000001ADAB5B ?
000000000 ?
800003F9FFFFF1B8 ?
800003FFC0012ED8 ?
ksedmp()+424 ? ksedst() 800003F9FFFFF1B8 ?
800003FFC0012ED8 ?
800003FFC0014400 ?
1000000010 ?
ksfdmp()+32 ? ksedmp() 800003FFC0012980 ?
4000000001B35633 ?
000000006 ? 000000000 ?
kgerinv()+152 ? ksfdmp() 000000006 ? 000000000 ?
C00000007FFFFFFF ?
4020000000000000 ?
kgeasnmierr()+88 ? kgerinv() 000000000 ?
8000000100147A00 ?
000000458 ?
8000000000000001 ?
qmtkGetColumnInfo() ? kgeasnmierr() 4000000080 ? 00000000C ?
+140 C000000134155608 ?
C000000134B371B4 ?
koksxmlticm()+3908 ? qmtkGetColumnInfo() 800003F7C006A9F0 ?
C000000134156DA0 ?
000000000 ?
8000000100013468 ?
koksicm()+1120 ? koksxmlticm() C000000134156848 ?
5101002000 ? 000000000 ?
000000001 ?
kokaccx()+1304 ? koksicm() 000000001 ?
800003FFC000D560 ?
C00000013FF6F8B0 ?
1000000000000000 ?
kokacmc()+64 ? kokaccx() C000000134B37228 ?
4000000001BD19B3 ?
00005E8A8 ?
800003FFC0010E88 ?
I have put this call stack into Metalink Note
ORA-600/ORA-7445 Error Look-up Tool [ID 153788.1]
Which suggest me to export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH.
but no luck again.So I check dba_registry and found that Oracle XML Database is invalid in XDB schema.
COMP_NAME SCHEMA STATUS VERSION --------------------------------------------- -------------------- ----------- ------------------------------ Oracle Enterprise Manager SYSMAN VALID 10.2.0.4.0 Spatial MDSYS VALID 10.2.0.4.0 Oracle interMedia ORDSYS VALID 10.2.0.4.0 OLAP Catalog OLAPSYS VALID 10.2.0.4.0 Oracle XML Database XDB INVALID 10.2.0.4.0 Oracle Text CTXSYS VALID 10.2.0.4.0 Oracle Expression Filter EXFSYS VALID 10.2.0.4.0 Oracle Rule Manager EXFSYS VALID 10.2.0.4.0 Oracle Workspace Manager WMSYS VALID 10.2.0.4.3 Oracle Data Mining DMSYS VALID 10.2.0.4.0 Oracle Database Catalog Views SYS VALID 10.2.0.4.0 Oracle Database Packages and Types SYS VALID 10.2.0.4.0 JServer JAVA Virtual Machine SYS VALID 10.2.0.4.0 Oracle XDK SYS VALID 10.2.0.4.0 Oracle Database Java Packages SYS VALID 10.2.0.4.0 OLAP Analytic Workspace SYS VALID 10.2.0.4.0 Oracle OLAP API SYS VALID 10.2.0.4.0
This time i have search Metalink again found something similar.
Datapump Export expdp Fails With ORA-600 [unable to load XDB library] [ID 736049.1]
where solution was given as below.
As the SYSDBA user, please run the following scripts :-
SQL>@/rdbms/admin/catmeta.sql
SQL>@/rdbms/admin/catmet2.sql
SQL>@/rdbms/admin/utlrp.sql
I executed above scripts and tried again this time i got below error.
Export: Release 10.2.0.4.0 - Production on Tue May 1 14:50:44 2012 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application testing options Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion) About to export specified users ... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user dummy_schema . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user dummy_schema About to export dummy_schema's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions EXP-00056: ORACLE error 932 encountered ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR EXP-00000: Export terminated unsuccessfully
Since it was 10.2.0.4 ,I tried to run export using Datapump. It went through.
Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 4.590 GB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/AUDIT_OBJ Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION Processing object type SCHEMA_EXPORT/VIEW/VIEW Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/TRIGGER Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
