Error while exporting............

[oravijay]

Hi All,

OS: Windows NT.
Version: 8.1.5

I was trying to export a oracle8.1.5 database and got the following error message:



Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user PANDAOWNER
. exporting object type definitions for user PANDAOWNER
About to export PANDAOWNER's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export PANDAOWNER's tables via Conventional Path ...
. . exporting table A000_TBL 1 rows exported
. . exporting table A015_FORMS_TBL 0 rows exported
. . exporting table A015_RECEIPTS_TBL 20 rows exported
. . exporting table 015_REP_TBL 0 rows exported
. . exporting table A015_RTO_TBL 10 rows exported
. . exporting table A015_SORT_TBL 103 rows exported
. . exporting table A015_SUGS_TBL 0 rows exported
. . exporting table A025_REP_TBL 1 rows exported
. . exporting table A028_9_INT_TBL 0 rows exported
. . exporting table A028_SPD_TBL 0 rows exported
. . exporting table A029_A225_STOCKFIGSME_TBL 0 rows exported
. . exporting table A029_ACCEPT_TBL 0 rows exported
. . exporting table A029_DSB_EXT_TBL 0 rows exported
. . exporting table A029_LOG_TBL
EXP-00056: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
EXP-00222:
System error message 2
System error message: No such file or directory

EXP-00008: ORACLE error 3114 encountered
ORA-03114: not connected to ORACLE
EXP-00222:
System error message 2
System error message: No such file or directory

EXP-00000: Export terminated unsuccessfully

EXP-00222:
System error message 2
System error message: No such file or directory

Any help will be appreciated.

Thanks.
Vijay.

[afshin]

Hi Vijay

Off hand I can say that you have lost connection to the database . The error "end-of-file on communication channel "
suggests so also check if the directory and file where you exporting exists "No such file or directory " error suggests so.
Rather you could post the export parfile as well . We can help

Cheers
Afshin

[oravijay]

Hi,

This was the command that I used:

exp userid=uid/pwd file=exp.dmp log=exp.log.

Thanks.
Vijay.

[afshin]

Hi

Can you just give a path for example
like this and get back if it is working .

exp userid=uid/pwd file=c:\exp.dmp log=c:\exp.log.

Thanks.
Afshn

[oravijay]

Hi,

I tried like that. Still it behaves the same. Even in the previous methods the dumpfile was created in C drive only.

Thanks.
Vijay.

[afshin]

Hi

Weird it worked at my end . R u sure you are still connected ( thru sqlplus ) to the DB while the export is happening.
Do you receive an error message there I am worried about the "end of communication " error . It usually signifies when client loses connection with the server .
Please let us know so that we can help

Cheers
Afshin

[jamoji]

Hi,
try this:
exp userid/pwd@servicename file=c:\exp.dmp log=c:\exp.log
that should work if your Database is ok

[suvendu]

The error show that you gets disconnected while you are taking the export backup. Please check whether the instance was up or not when you encounter that error during export.

Thanks,
Suvendu

[Sureshy]

check note 100405.1 on metalink.

Export may corrupt export file without any wanings if the object being exported was previously imported into the database.

Only affects 8.1.5, fixed in 8.1.6 and upwards.

Contact Oracle.

[oravijay]

Guys, I need your help to overcome this.

Thanks.
Vijay.