Home » RDBMS Server » Enterprise Manager » please tell me
please tell me [message #515505] Tue, 12 July 2011 00:51 Go to next message
amar99
Messages: 4
Registered: June 2011
Location: hyderabad
Junior Member

Hi friends ,,,i use oracle11g
i got some error messages ,,,,,,,plz reply how to solve this
ora - 03113: end-of-file on communication channel
Process ID : 13782
Session ID: 87 Serial number : 5
Re: please tell me [message #515516 is a reply to message #515505] Tue, 12 July 2011 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.

Regards
Michel
Re: please tell me [message #517748 is a reply to message #515516] Wed, 27 July 2011 21:54 Go to previous messageGo to next message
mail2subrahmanyam
Messages: 2
Registered: July 2011
Location: Hyderabad
Junior Member
Use the oerr utility to get the details for the ORA-03113 error:

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.


ORA-03113 could be signaled for any of these scenarios:

Server machine crashed

Your server process was killed at O/S level

Network problems

Oracle internal errors / aborts on the server

Client incorrectly handling multiple connections

BETTER TO GO FOR SUPPORT


Regards
Subrahmanyam
Re: please tell me [message #518882 is a reply to message #517748] Mon, 08 August 2011 04:23 Go to previous messageGo to next message
Markwillium
Messages: 13
Registered: December 2010
Location: India
Junior Member
Ora-03113 is an unexpected end of file error that could not be handled by sql*net.

Cause: The most possible cause for the above error message is net8 server is no longer available or unable to respond to net8 client request. It can also occur due to network problem.

Resolution:
First check the oracle server, see the alert log and prefer to the oracle support.
Make sure listener is working correctly.
Change the used protocol or call network administrator to fix the problem."
Re: please tell me [message #518893 is a reply to message #518882] Mon, 08 August 2011 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, this is most of the time (999 out of 1000) the signal there is an Oracle bug.

Regards
Michel

[Updated on: Mon, 08 August 2011 04:53]

Report message to a moderator

Re: please tell me [message #518900 is a reply to message #518893] Mon, 08 August 2011 06:28 Go to previous message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
Change the used protocol or call network administrator to fix the problem."

No first Consult you DBA Smile Then raise an SR as suggested by Michel.

Regards
sriram
Previous Topic: Multiple copies of the same alert appear on SCOM console
Next Topic: ERROR: SQLException null Resultset
Goto Forum:
  


Current Time: Tue Sep 16 11:28:57 CDT 2014

Total time taken to generate the page: 0.20230 seconds