DSXchange

Posted: **Thu Mar 15, 2007 6:56 pm**

Hi All,
Our ETL is going through testing,
I am starting getting weird problem, please see the log:

SQL*Loader-951: Error calling once/load initialization
ORA-03113: end-of-file on communication channel

If I stop and restart the server, it works fine for 1-2 runs and then it starts crashing again.

Any thoughts would be appreciated.

Thanks and regards,
Munish

Posted: **Thu Mar 15, 2007 7:39 pm**

You lost your connection to the Oracle database when SQL Loader was trying to start up. Something else to take to your DBA and see if they'll help you figure out the actual problem.

Posted: **Thu Mar 15, 2007 8:04 pm**

An ORA-03113 occurs when a session's process dies (or is killed). This is usually caused by an ORA-00600 or an ORA-07445. Both errors should be resolbed by Oracle support. ORA-00600 as well as ORA-07445 write a trace file in the background_dump_dest or user_dump_dest.
The 3rd file to look at in such a case is the alert log.

Posted: **Thu Mar 15, 2007 8:33 pm**

They should show in the log after the ORA-03113 if that was the case. Munish, are there any other errors in the log after the two you've shown?

Again, and regardless, your DBA should be encouraged to pitch in and help with this. They would be the ones to contact Oracle support, open a TAR, etc.