Error during export in oracle 9i

Printable View

09-24-2003, 09:48 PM
castlerock

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!
09-24-2003, 11:43 PM
slimdave

Have a look at the server alert log, and any trace files produced, for more details -- there may be more error information there.
09-25-2003, 12:01 AM
castlerock

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,
09-25-2003, 01:37 AM
slimdave

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
09-25-2003, 02:08 AM
castlerock

Oracle 9i(9.0.1) on WINNT

Thanks,