Home » Other » General » DB Down with the alert java.sql.SQLRecoverableException (oracle 11g, Windows, Java Applications)
DB Down with the alert java.sql.SQLRecoverableException [message #488165] Wed, 05 January 2011 06:51 Go to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

I am facing a problem of DB down just after getting the alert "java.sql.SQLRecoverableException: No more data to read from socket---java.sql.SQLRecoverableException: No more data to read from socket" and when I checked the Alert log file I didn't find any thing related to this.

Can some one tell me why my db is going down. and what is the solution for this.

Pradeep
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488170 is a reply to message #488165] Wed, 05 January 2011 07:08 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
are you able to connect from client using sqlplus to the database server?

[Updated on: Wed, 05 January 2011 07:08]

Report message to a moderator

Re: DB Down with the alert java.sql.SQLRecoverableException [message #488173 is a reply to message #488170] Wed, 05 January 2011 07:27 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

Yes I am able to connect from client to db server using sqlplus.


Pradeep
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488176 is a reply to message #488173] Wed, 05 January 2011 08:04 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
Quote:
Can some one tell me why my db is going down. and what is the solution for this.



you are able to connect to the database server,,,,database is not down.

do you see any errors in the listener log file?
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488209 is a reply to message #488176] Wed, 05 January 2011 11:39 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Is this through OEM?

sriram
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488277 is a reply to message #488209] Thu, 06 January 2011 02:06 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

I m not able to understand "Is this through OEM?"


Pradeep
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488278 is a reply to message #488277] Thu, 06 January 2011 02:10 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Is this Error Occurred/happened when using your custom Java application or Oracle Enterprise Manager?

Sriram
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488282 is a reply to message #488278] Thu, 06 January 2011 02:35 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

There are few custom java based application running on this database.


Pradeep
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488490 is a reply to message #488282] Fri, 07 January 2011 22:28 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi ,

Today db again down due to the same below mentioned error ??

Help me to resolve or identify this problem ??

Regards

Pradeep
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488497 is a reply to message #488490] Sat, 08 January 2011 02:36 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
According to your alert log, you had some "Fatal NI connect error 12170." events. Don't worry about them, just suppress them by putting
diag_adr_enabled_listenername=OFF
in your sqlnet.ora file, if I remember correctly. They are nothing to do with the instance failing.

Then there was some sort of shutdown at 23:20:02 and a startup at 23:21:32. Do you know what was happening then? Is it possible that someone accidentally shut it down and re-started it immediately? (We've all done it, nothing to be ashamed of)
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488498 is a reply to message #488490] Sat, 08 January 2011 02:38 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Based on the scarce info you provided, this could be caused by a number of things.
Things that come to mind: connection pool lost connection, listener has hickups, database is down, application has bugs.
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488500 is a reply to message #488497] Sat, 08 January 2011 03:22 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi John,

As you said in your post I will add diag_adr_enabled_listenername=OFF in sqlnet.ora file. If the same errors persist in alert log file then i will back.

As you are talking about the server shutdown, No one is doing the shutdown db forcelly. Its going down automatically and alert is coming from application to us.

Regards

Pradeep

Re: DB Down with the alert java.sql.SQLRecoverableException [message #488501 is a reply to message #488498] Sat, 08 January 2011 03:26 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi Frank,

As you said this problem can be one of the connection pool lost connection, listener has hickups, database is down, application has bugs, But I want to know which cause is the culprit for the DB down.

Can we identify this ??

Regards

Pradeep
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488503 is a reply to message #488500] Sat, 08 January 2011 03:49 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Pradeep, you say Quote:
No one is doing the shutdown db forcelly. Its going down automatically
but your alert log says
Shutting down instance (immediate)
License high water mark = 1744
Stopping Job queue slave processes, flags = 7
Tue Jan 04 23:21:32 2011
Starting ORACLE instance (normal)

I do not know of any automatic process that could shutdown an instance and then restart it. The default level of auditing will log all SYSDBA logons but nothing more; if I were you, I would go to the audit_dest and see who was logged on as SYSDBA at the time. And set audit-sys_operations=true so that you can track what is done next time.
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488504 is a reply to message #488498] Sat, 08 January 2011 04:04 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

As you said I set the parameter audit_sys_operations =TRue in my database for tracking this problem further.

Kindly let me know is advance how can I track this i.e. commands for tracking or way of tracking when DB will be get restarted again.

Regards

pradeep
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488577 is a reply to message #488504] Sun, 09 January 2011 23:56 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

Kindly let me know the procedure stated below to find out reagrding the same problem.

Today DB is again down !!!!!!! Embarassed


Pradeep
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488579 is a reply to message #488500] Sun, 09 January 2011 23:59 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi John,

After placing the specified parameter in listener.ora file still I am facing the same errors in alert log files.
--------------------------------------------------
Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.1.0.6.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.1.0.6.0 - Production
Time: 09-JAN-2011 20:53:30
Tracing not turned on.
Tns error struct:
ns main err code: 12535
----------------------------------------------------

Pradeep
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488639 is a reply to message #488579] Mon, 10 January 2011 05:42 Go to previous messageGo to next message
ASMDB
Messages: 1
Registered: January 2011
Junior Member
This seems to be some application level issue. Check at Application level.
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488640 is a reply to message #488639] Mon, 10 January 2011 05:46 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

I want to know the application which is causing this problem.

Tell me the way to find out this application.


pradeep
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488652 is a reply to message #488640] Mon, 10 January 2011 06:26 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You haven't read my post, and neither have you read the documentation. DIAG_ADR_ENABLED is a sqlnet.ora parameter, not a listener.ora parameter. Better read up on it before you proceed.

And as for your audit records, if you have enabled auditing for all sys operations, you will have in your audit trail a complete list of every command executed as sysdba, with details that should let you find the culprit.
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488768 is a reply to message #488652] Tue, 11 January 2011 02:13 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

After placing the parameter DIAG_ADR_ENABLED in sqlnet file problem regarding massages in alert log still the same.


pradeep
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488780 is a reply to message #488768] Tue, 11 January 2011 02:39 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Since you haven't posted your sqlnet.ora file, I don't know what you have done wrong. Have you looked at Metalink? Note 1116960.1 might be worth reading.
I'm not replying again, until you say "thank you".
Re: DB Down with the alert java.sql.SQLRecoverableException [message #488794 is a reply to message #488780] Tue, 11 January 2011 03:35 Go to previous message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi,

For your confirmation I am sending sqlnet.ora file from servers.


Pradeep
  • Attachment: sqlnet.ora
    (Size: 0.48KB, Downloaded 1607 times)
Previous Topic: Question regarding database URL
Next Topic: Compatible
Goto Forum:
  


Current Time: Thu Mar 28 14:29:37 CDT 2024