Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    12

    Error while export in oracle 9i

    Hi ,
    My database is oracle9i in winNT. While exporting the database as sys with full=y my export terminated unsucessfully.

    . . 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 ix this ?

    Many Thanks,

  2. #2
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102

    Re: Error while export in oracle 9i

    the main problem here is the "ORACLE error 3113"
    (also called ORA-3113)
    This means your program got disconnected from the database.
    there might be many causes, first check the alert-log and any traces, escpecially for ORA-600 or ORA-7445
    If there are no such errors you might have a problem on the network-layer.
    ^/\x

  3. #3
    Join Date
    Sep 2003
    Posts
    12
    Hi,
    Lines from the alertlog and trc file.ORA-00601 ERROR

    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:
    Text continued in next action...



    Cheers! Thanks

  4. #4
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102
    with this information you should contact Oracle Support.
    after a short research I guess this is a bug,
    but to be sure only Oracle Support can clarify this.

    Do you use the latest patchset?
    ^/\x

Posting Permissions

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