Home » RDBMS Server » Server Administration » No more data to read from socket (Unix , Weblogic , Oracle 10g)
No more data to read from socket [message #404978] Mon, 25 May 2009 23:54 Go to next message
brutus.i
Messages: 5
Registered: October 2007
Location: India
Junior Member
Hi all.
I have an application running in weglodic server with oracle 10g enterprise edition database.
When ever i perform a particular task in a particular page , iam getting an error " No more data to read from socket".
This error is not occuring when i do the same from the backend procedure instead of java calling the procedure.

when i googled "No more data to read from socket" , it says that the db session java makes is getting stale or useless.

This db procedure uses a big object with numberous collection objects inside. When i comment out a particular piece of code ( 15 to 20 lines) where a particular collection object is getting populated , this error is not occuring.

could anybody tell me the diagnosis , this is actaully urgent and its only in production , and develpoment and QA environments are running fine.
Re: No more data to read from socket [message #405138 is a reply to message #404978] Tue, 26 May 2009 08:36 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Have a look in the Alert log, and in the trace files.

You can get this message as a result of an Ora-3113 or an ORA-7445
Re: No more data to read from socket [message #405788 is a reply to message #405138] Fri, 29 May 2009 08:01 Go to previous messageGo to next message
brutus.i
Messages: 5
Registered: October 2007
Location: India
Junior Member
Thank you sir.
You are right.
I found in the trace files the following lines.

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [memcpy()+116] [SIGSEGV] [Address not mapped to object] [0xC40635015A000088] [] []

I have reported this to oracle.
It would be more helpful if we could get some more details of this error, so that we could start analyzing the cause.
Thanks.

Re: No more data to read from socket [message #405790 is a reply to message #404978] Fri, 29 May 2009 08:04 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
submit a Service Request to metalink.oracle.com
Previous Topic: ORA-01034: ORACLE not available, ORA-27101: shared memory realm does not exist followed by ORA-01017
Next Topic: increase Rollback segment on oracle 7.3.3
Goto Forum:
  


Current Time: Wed Jul 03 06:39:52 CDT 2024