| ORA-03113: end-of-file on communication channel [message #42546] |
Wed, 09 April 2003 02:35  |
Arfat
Messages: 25
Registered: August 2002
|
Junior Member |
|
|
I m trying to insert values in a table called test in the folloeing way.
insert into test
select * from test1;
the table structures are same infact test1 is created from test table onle.
the above query gives me the error
ORA-03113: end-of-file on communication channel
And it disconnects from the server.
if i just run Select * from test1 the query runs fine.
The above query returns 2000 records.
If i restrict the insert into statement to record below 700 it works fine and insert the records
insert into test
select * from test1
Where rownum <= 700;
Can someone help me wid this problem and sugesst a solution for it.
|
|
|
|
| Re: ORA-03113: end-of-file on communication channel [message #42555 is a reply to message #42546] |
Wed, 09 April 2003 12:00  |
Ivan
Messages: 180
Registered: June 2000
|
Senior Member |
|
|
This error has nothing to do with a DML (data manipulation language) command.
Here's what the manual says:
ORA-03113 end-of-file on communication channel
Cause: An unexpected end-of-file was processed on the communication
channel. The problem could not be handled by the Net8, two task, software.
This message could occur if the shadow two-task process associated with a
Net8 connect has terminated abnormally, or if there is a physical failure of the
interprocess communication vehicle, that is, the network or server machine
went down. In addition, this message could occur when ALTER SYSTEM KILL
SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the
IMMEDIATE qualifier because, in those cases, the client’s connection to the
database is terminated without waiting for the client to issue a request.
Action: If this message occurs during a connection attempt, check the setup
files for the appropriate Net8 driver and confirm Net8 software is correctly
installed on the server. If the message occurs after a connection is well
established, and the error is not due to a physical failure, check if a trace file
was generated on the server at failure time. Existence of a trace file may suggest
an Oracle internal error that requires the assistance of customer support.
If this was a one time error (meaning that the next time you try it you'll succeed), you're already fine. Otherwise, check your network settings. For some reason you connection (via Net8) to the DB dies.
We had a similar problem. I'm not a network guy, but something was related to the firewall.
The statement was taking a very long time to run, much longer than one request was allowed to keep a network connection open. So, the firewall would disconnect the Net8's "pipe" to the DB. When the DB completes the job (the INSERT statement) it tries to communicate the result to your client session, but is can't. The "pipe"'s broken. Oracle issues a ROLLBACK (because of failure) and your client is returning the ORA-03113.
If this happens at work, talk to your network guys to monitor the network when you access the DB with this statement. If not, unless you understand networks, I'm not sure if you can do much.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
