Tuesday, May 1, 2012

export fails with ORA-00600 [qmtGetColumnInfo1]

I was taking export as below .
/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=None
and 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