Printable View
We have connected our one site through radio frequency link.
Now some times not always client lost the connection with Oracle
server with ORA-03113 or ORA-03114.
In our Local area network we are not facing this problem.
The error log is also not generated. Not in UDUMP or BDUMP
Quote:
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.
Is there any solution for that?
Because after error if client connect throgh other session it works
fine.
My guess is intermittant network problems - i.e. the quality of the radio link. Can this be monitored? Can it be correlated with the errors?
Thanks for your reply
Before some days i have changed my database server. Old server was running with 100 MBPS and new server run with 1 GBPS adapter.
I am facing this problem since i have changed my server.
The error was not encounter in old server.
I have just restore the cold backup from my old server.
Any previous database was there in the new system?
Any upgrade done..?
(If so not running catpatch.sql caused the same error once for us.)
If first one is the case, start your db using pfile,
and try.