ora-24324 during export on 10g

[badrinathn]

Hi all,

I tried to just export the test (SCOTT) schema from my 10g installation, it errored with
EXP-00056 and ora-24324 .

But if I just export one table (EMP), the export is successful. Any idea why my export with OWNER=SCOTT errors out?

As suggested on Google, I did run the catalog/catproc and utlrp.sql scripts.

Thanks in advance (No metalink account).

Badrinath

[SANJAY_G]

Anything in alert log? Any trace file generated?

[badrinathn]

oh my...recompiling the invalid procedures is throwing out ora-0600

I am seeing ora-600 errors - i thought with 10g those were either rare or non-occuring.

BTW, I am on Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production


Thu Oct 20 13:42:01 2005
Errors in file /u01/app/admin/admin/ora10g/udump/ora10g_ora_7754.trc:
ORA-00600: internal error code, arguments: [qmtInit1], [], [], [], [], [], [], [
]
Thu Oct 20 13:47:18 2005
Errors in file /u01/app/admin/admin/ora10g/udump/ora10g_ora_7754.trc:
ORA-00600: internal error code, arguments: [qmtInit1], [], [], [], [], [], [], [
]
Thu Oct 20 13:52:35 2005
Errors in file /u01/app/admin/admin/ora10g/udump/ora10g_ora_7754.trc:
ORA-00600: internal error code, arguments: [qmtInit1], [], [], [], [], [], [], [
]
Thu Oct 20 13:57:52 2005
Errors in file /u01/app/admin/admin/ora10g/udump/ora10g_ora_7754.trc:
ORA-00600: internal error code, arguments: [qmtInit1], [], [], [], [], [], [], [
]
Thu Oct 20 14:03:09 2005
Errors in file /u01/app/admin/admin/ora10g/udump/ora10g_ora_7754.trc:
ORA-00600: internal error code, arguments: [qmtInit1], [], [], [], [], [], [], [
]

and the trace file has

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qmtInit1], [], [], [], [], [], [], [
]
Current SQL statement for this session:
ALTER VIEW "SYS"."KU$_FHTABLE_VIEW" COMPILE
----- PL/SQL Call Stack -----
object line object
handle number name
3b5630970 946 package body SYS.DBMS_UTILITY
3ae7469c8 1 anonymous block
3ae7dcc00 320 package body SYS.UTL_RECOMP
3ae7dcc00 636 package body SYS.UTL_RECOMP
3ae7dcc00 589 package body SYS.UTL_RECOMP
3ae7dd450 4 anonymous block

[dbasan]

Hi all,

I tried to just export the test (SCOTT) schema from my 10g installation, it errored with
EXP-00056 and ora-24324 .

But if I just export one table (EMP), the export is successful. Any idea why my export with OWNER=SCOTT errors out?

As suggested on Google, I did run the catalog/catproc and utlrp.sql scripts.

Thanks in advance (No metalink account).

Badrinath

Is there any change in the environment/permission settings?
more over the SCOTT schema is marked as non-exportable in the NOEXP$ table.

[badrinathn]

Hi DBASAN,
Let me try with the other schemas - thanks.

[badrinathn]

Looks like the invalid procedures are causing further problems here. Now export fails because some of the procedures are invalid. The utlrp.sql script (for re-validating the procedure fails with ORA-600) . Is n't that utlrp.sql should be used for re-compiling all the procedures?



About to export NBN's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 4045 encountered
ORA-04045: errors during recompilation/revalidation of SYS.KU$_XMLSCHEMA_VIEW
ORA-00600: internal error code, arguments: [qmtInit1], [], [], [], [], [], [], []
EXP-00000: Export terminated unsuccessfully