OraFAQ Forum: Enterprise Manager

Home » RDBMS Server » Enterprise Manager » please tell me

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

please tell me [message #515505]

Tue, 12 July 2011 00:51

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

Report message to a moderator

Re: please tell me [message #515516 is a reply to message #515505]

Tue, 12 July 2011 01:21

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: please tell me [message #517748 is a reply to message #515516]

Wed, 27 July 2011 21:54

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

Report message to a moderator

Re: please tell me [message #518882 is a reply to message #517748]

Mon, 08 August 2011 04:23

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."

Report message to a moderator

Re: please tell me [message #518893 is a reply to message #518882]

Mon, 08 August 2011 04:52

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

ramoradba
Messages: 2457
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 04:03:54 CST 2024