DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ora-24324 during export on 10g

  1. #1
    Join Date
    Jan 2001
    Posts
    642

    ora-24324 during export on 10g

    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
    There is always a better way to do the things.

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Anything in alert log? Any trace file generated?
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Jan 2001
    Posts
    642
    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
    There is always a better way to do the things.

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by 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
    Is there any change in the environment/permission settings?
    more over the SCOTT schema is marked as non-exportable in the NOEXP$ table.
    "What is past is PROLOGUE"

  5. #5
    Join Date
    Jan 2001
    Posts
    642
    Hi DBASAN,
    Let me try with the other schemas - thanks.
    There is always a better way to do the things.

  6. #6
    Join Date
    Jan 2001
    Posts
    642
    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
    There is always a better way to do the things.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width