ORA-03113: end-of-file on communication channel
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
ORA-03113: end-of-file on communication channel
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..
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..
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 82
- Joined: Fri Jun 03, 2005 5:23 am
- Location: Bangalore
- Contact:
i think this helps
ORA-03113: end-of-file on communication channelivannavi 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?
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
Rajasekhar
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Re: i think this helps
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..irajasekharhexa wrote:ORA-03113: end-of-file on communication channelivannavi 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?
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
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Is it possible that your SQL or this particular job ending your connection with oracle, ?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..
Thanks,
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.