Hello guys. I am having trouble with ORA-03113 error.
Ok, so here is the deal, I have a script which runs traditional export to export a schema from one database. The script runs fine and executes the exp and the tables from the selected schema gets loaded into a dumpfile.
The problem occurs when few tables are loaded, the script suddenly terminates with the following errors.
{code}
. . exporting table HBT_FFS_CLMS_BREAKDOWN_BY_SRC 160 rows exported
. . exporting table HBT_FFS_VS_ENC_CLM_SUBMISSION 21 rows exported
. . exporting table HBT_HIPAA_FILE_TRNSCTN_ACTVTY 598 rows exported
. . exporting table HBT_INTERFACE_DB2DB_DW_JOB_STS
EXP-00056: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
Process ID: 31528
Session ID: 1523 Serial number: 46937
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-00000: Export terminated unsuccessfully
{code}
I've checked for the ORA-03113 error. and it says it is a communication error between the client and the server and that the target database must have been either shutdown or the connection got lost.
So I did the tnsping to the target database.
{code}
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 204.23.252.157)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = CHPPRD1)))
OK (120 msec)
The connection is fine and the database is not down, since the database is a production database and it shouldn't be down, or else all hell breaks loose :-D. It is not a problem with the script since the exp executes just fine.
So I was wondering if anyone encountered the same issue or scenario. Any and all help is very much appreciated.
Thank You
{code}