Home » RDBMS Server » Networking and Gateways » Fatal NI connect error 12537 (windows)
Fatal NI connect error 12537 [message #544275] Tue, 21 February 2012 00:56 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8702
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 16 20:24:06 CDT 2022
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.