ORA-03113: end-of-file on communication channel

DeepakCorning · Post by **DeepakCorning** » Mon Apr 16, 2007 12:57 pm

While running a job I am getting this error for each row which it is trying to insert in an oracle Database --

ORA-03113: end-of-file on communication channel

I searched the forum but they have resultions like "timeout" or check connectivity. I have checked both of them and they are fine.

The job is very simple (and further simplified it by reducing it to source from a flat file and insert in to the table). But still i keep on getting the same error.

Is it with the table setting in the Database or I should be looking somewhere else? Thanks for the help..

DSguru2B · Post by **DSguru2B** » Mon Apr 16, 2007 1:05 pm

This error, basically tells you that there was a communication problem between your oracle client and database. For more info, search on the error code in google. Like this for instance.

ivannavi · Post by **ivannavi** » Tue Apr 17, 2007 4:47 am

Do you have some other job that works well with this database?
Can you read some data from the database using Datastage(try an Oracle stage with an output link and then click view data)?
Can you connect to the database from the Datastage machine using SQLplus?

irajasekharhexa · Post by **irajasekharhexa** » Tue Apr 17, 2007 6:12 am

ivannavi wrote:Do you have some other job that works well with this database?
Can you read some data from the database using Datastage(try an Oracle stage with an output link and then click view data)?
Can you connect to the database from the Datastage machine using SQLplus?

ORA-03113: end-of-file on communication channel
Cause: The connection between Client and Server process was broken.
Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

Deepak pls check and let me know if it works fine

Thanks

DeepakCorning · Post by **DeepakCorning** » Tue Apr 17, 2007 9:28 am

ivannavi wrote:Do you have some other job that works well with this database?
Can you read some data from the database using Datastage(try an Oracle stage with an output link and then click view data)?
Can you connect to the database from the Datastage machine using SQLplus?

Yes to all...

DeepakCorning · Post by **DeepakCorning** » Tue Apr 17, 2007 9:29 am

irajasekharhexa wrote:
ivannavi wrote:Do you have some other job that works well with this database?
Can you read some data from the database using Datastage(try an Oracle stage with an output link and then click view data)?
Can you connect to the database from the Datastage machine using SQLplus?
ORA-03113: end-of-file on communication channel
Cause: The connection between Client and Server process was broken.
Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

Deepak pls check and let me know if it works fine

Thanks

Raja , Yeah i got this from the oracle site , but nope I do not think this is the issue..The SQL net works fine and all other jobs work fine with thsi DB..

DSguru2B · Post by **DSguru2B** » Tue Apr 17, 2007 9:34 am

Is this a recurring issue with this partuicular job?

DeepakCorning · Post by **DeepakCorning** » Tue Apr 17, 2007 9:42 am

Yes , it is showing me the same error everytime i run it. As a matter of fact I wa snot able to run this job successfully even once.

DSguru2B · Post by **DSguru2B** » Tue Apr 17, 2007 10:53 am

For testing purposes, run the job with a row limit set to 1. See what happens.
What kind of update action do you have in the target OCI stage? Are you using generated sql or user defined?

DeepakCorning · Post by **DeepakCorning** » Tue Apr 17, 2007 12:46 pm

Row limit set to 1 - Same Error.
I introduced a seq file in between the trans and target stage - Same error
Removed all other stages and just kept the seq file and Target stage - Same error
Using generated SQL , Update Action is Update or Insert.

Target stage is a DRS stage.

DSguru2B · Post by **DSguru2B** » Tue Apr 17, 2007 12:51 pm

Delete the job. Create a new one. Use odbc stage, just for testing purposes. See if the error persists. This is really odd. You said you have other jobs that connect to the same database without any issues right, then why this one.

DeepakCorning · Post by **DeepakCorning** » Tue Apr 17, 2007 1:18 pm

Thats what is bugging me

Let me try.. Also someone to,ld me that the generated SQL may be too long .. but thats also not the case..

mctny · Post by **mctny** » Tue Apr 17, 2007 2:04 pm

DeepakCorning wrote:Thats what is bugging me

Let me try.. Also someone to,ld me that the generated SQL may be too long .. but thats also not the case..

Is it possible that your SQL or this particular job ending your connection with oracle, ?

DeepakCorning · Post by **DeepakCorning** » Tue Apr 17, 2007 2:09 pm

mctny wrote: Is it possible that your SQL or this particular job ending your connection with oracle, ?

How is that possible ? (Sorry I have very less knowlegde of this)

ray.wurlod · Post by **ray.wurlod** » Tue Apr 17, 2007 2:46 pm

Might your data contain any special characters, such as EOT (end of transmission), EOF (end of file), etc., that might cause the connection to be interrupted?

DSXchange

ORA-03113: end-of-file on communication channel

ORA-03113: end-of-file on communication channel

i think this helps

Re: i think this helps