Error during export in oracle 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Error during export in oracle 9i

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    Error during export in oracle 9i

    Hi,
    An eror occured during export as sys user with full=y


    . . exporting table DESSTEPS 157500 rows exported
    . . exporting table GROUPS 11 rows exported
    . . exporting table HISTORY 127134 rows exported
    . . exporting table HOSTS 0 rows exported
    . . exporting table HOST_GROUP 0 rows exported
    . . exporting table HOST_IN_GROUP 0 rows exported
    . . exporting table LOCKS 0 rows exported
    . . exporting table MAILCOND 0 rows exported
    . . exporting table MODULES 5 rows exported
    . . exporting table REPORTS 0 rows exported
    . . exporting table REQ 479 rows exported
    . . exporting table REQ_COVER 2736 rows exported
    . . exporting table RUN 15619 rows exported
    . . exporting table SEQUENCES 21 rows exported
    . . exporting table STEP
    EXP-00056: ORACLE error 3113 encountered
    ORA-03113: end-of-file on communication channel
    EXP-00056: ORACLE error 24324 encountered
    ORA-24324: service handle not initialized
    EXP-00056: ORACLE error 24324 encountered
    ORA-24324: service handle not initialized
    EXP-00056: ORACLE error 24324 encountered
    ORA-24324: service handle not initialized
    EXP-00056: ORACLE error 24324 encountered
    ORA-24324: service handle not initialized
    EXP-00002: error in writing to export file
    EXP-00000: Export terminated unsuccessfully

    How to fix this?

    cheers!

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Have a look at the server alert log, and any trace files produced, for more details -- there may be more error information there.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jan 2003
    Posts
    141
    Hi,
    The ALERT LOG and SMON TRC file informations

    ALERT LOG:

    Wed Sep 24 03:35:59 2003
    Errors in file E:\oracle\admin\TD\bdump\tdSMON.TRC:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01001: invalid cursor
    ORA-00601: cleanup lock conflict

    Thu Sep 25 06:02:15 2003
    Errors in file E:\oracle\admin\TD\bdump\tdSMON.TRC:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01001: invalid cursor
    ORA-00601: cleanup lock conflict


    SMON.TRC:

    *** 2003-09-24 03:35:59.000
    SMON: following errors trapped and ignored:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01001: invalid cursor
    ORA-00601: cleanup lock conflict
    *** 2003-09-25 06:02:15.000
    SMON: following errors trapped and ignored:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01001: invalid cursor
    ORA-00601: cleanup lock conflict


    Many Thanks,

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    The 601 error is not common, and you would probably do well to open a tar with Oracle for this.

    Also, what version are you on? I saw a mention of a problem with this in 8.1.6.0.0 that was solved by an upgrade to 8.1.6.2.0
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Jan 2003
    Posts
    141
    Oracle 9i(9.0.1) on WINNT

    Thanks,

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