OraFAQ Forum: Networking and Gateways » Fatal NI connect error 12537

Home » RDBMS Server » Networking and Gateways » Fatal NI connect error 12537 (windows)

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

Fatal NI connect error 12537 [message #544275]

Tue, 21 February 2012 00:56

sandeip
Messages: 23
Registered: May 2011
Location: pune

Junior Member

I have one error in alert log of my database with version 11.2.0.1.0 and OS is microsoft windows 2003(service pack 2)
"********************************************* **************************
Fatal NI connect error 12537, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for 32-bit Windows: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production Time: 17-JAN-2012 23:51:10 Tracing not turned on. Tns error struct: ns main err code: 12537 TNS-12537: TNS:connection closed ns secondary err code: 12560 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 opiodr aborting process unknown ospid (7980) as a result of ORA-609 Tue Jan 17 23:51:12 2012 *********************************************************************** Fatal NI connect error 12537, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for 32-bit Windows: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protoco
l Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production Tue Jan 17 23:51:12 2012 *********************************************************************** Time: 17-JAN-2012 23:51:12 Fatal NI connect error 12537, connecting to: (LOCAL=NO) Tracing not turned on. VERSION INFORMATION: TNS for 32-bit Windows: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production Tns error struct: Time: 17-JAN-2012 23:51:12 ns main err code: 12537 Tracing not turned on. Tns error struct: TNS-12537: TNS:connection closed ns main err code: 12537 ns secondary err code: 12560 TNS-12537: TNS:connection closed nt main err code: 0 ns secondary err code: 12560 nt secondary err code: 0 nt main err code: 0 nt OS err code: 0 nt secondary err code: 0 nt OS err code: 0 opiodr aborti
ng process unknown ospid (3612) as a result of ORA-609 opiodr aborting process unknown ospid (4440) as a result of ORA-609"

For this I have set SQLNET.INBOUND_CONNECT_TIMEOUT = 120 in sqlnet.ora and INBOUND_CONNECT_TIMEOUT_LISTENER = 110 in listener.ora but error remains as it is, please suggest how should I troubleshoot with this error.

Report message to a moderator

Re: Fatal NI connect error 12537 [message #544290 is a reply to message #544275]

Tue, 21 February 2012 01:50

John Watson
Messages: 3107
Registered: January 2010
Location: Global Village

Senior Member

This isn't an error, it is to do with the way Oracle Net events are logged. See note 1286376.1 if you want to supress the messages.
Rgds, John.

Report message to a moderator

Re: Fatal NI connect error 12537 [message #544305 is a reply to message #544290]

Tue, 21 February 2012 03:18

sandeip
Messages: 23
Registered: May 2011
Location: pune

Junior Member

Hi John,
thanks for your reply..!
The note suggested by you contains "Fatal NI connect error 12170."
where my alert log contains error as "Fatal NI connect error 12537"
whether setting
DIAG_ADR_ENABLED = OFF
DIAG_ADR_ENABLED_<listenername> = OFF
parameter are applicable for both the errors.

Or shall i try with increasing the parameters SQLNET.INBOUND_CONNECT_TIMEOUT = 120
and INBOUND_CONNECT_TIMEOUT_LISTENER = 110

Or is there any other method to troubleshoot with the same.

Report message to a moderator

Previous Topic:	Performance difference between Windows PC and Windows on VMware
Next Topic:	Oracle HTTP SSL Certificate causes errors in IE 6/7/8

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 13:49:08 CDT 2013

Total time taken to generate the page: 0.86868 seconds