Fatal Ni Connect Error 12640
Contents |
have a script to monitor the alert.log file for any ORA-xxxx errors. With 11g we found out many entries in regards of: Fatal NI connect error The problem: alert.log file has many
Fatal Ni Connect Error 12170 Tns-12535
entries for Fatal NI connect error. Examples: *********************************************************************** Fatal NI connect error 12514, fatal ni connect error 12170 ora-3136 connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=nnn))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=sss)(CID=(PROGRAM=oracle)(HOST=xxx)(USER=oracle)))) VERSION INFORMATION: TNS for Linux: Version 11.2.0.2.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 -
Ns Main Err Code: 12535
Production Time: 17-JAN-2011 10:20:45 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: TNS:connection refused ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 fatal ni connect error 12637 connecting to (local=no) nt OS err code: 0 Error 12514 received logging on to the standby Mon Jan 17 10:21:45 2011 *********************************************************************** or *********************************************************************** Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 11.2.0.2.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.2.0 - Production Time: 18-JAN-2011 15:13:08 Tracing not turned on. Tns error struct: ns main err fatal ni connect error 12638 code: 12535 TNS-12535: TNS:operation timed out ns secondary err code: 12560 nt main err code: 505 TNS-00505: Operation timed out nt secondary err code: 110 nt OS err code: 0 Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.x.xx)(PORT=nnnn)) Tue Jan 18 15:40:20 2011 The solution: We will have an entry on the alert.log file every time a client connection of any kind fails to complete or is aborted. One way to minimize the impact is by using the parameter SQLNET.INBOUND_CONNECT_TIMEOUT (default to 60 seconds on 10gR2 and 11g) but, sometimes, this value is not adequate. Oracle also mentions the occurrence of this error if you use DB Console or Enterprise Manager to monitor your databases and the emagent will try to connect to the target database repeatedly and, statistically, some will fail (frequency will depend on how busy your system is). Most of the time (certainly for DB Console and Enterprise Manager Agent) the application will try to connect again and it will succeed. To fix the problem you could increase the value of SQLNET.INBOUND_CONNECT_TIMEOUT on the listener.ora and the sqlnet.ora file located on the server side. If you already have a value you have considered adequate, you might want to add the following line on your listener.ora file: DIAG_ADR_ENABLED_li
errors If this is your first visit, be sure to check out the FAQ by clicking the link above. You may
Tns-12564: Tns:connection Refused
have to register before you can post: click the register link nt secondary err code: 110 above to proceed. To start viewing messages, select the forum that you want to visit from the
Ns Main Err Code: 12564
selection below. Results 1 to 2 of 2 Thread: sqlnet.log errors Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch https://davidalejomarcos.wordpress.com/2011/01/18/removing-fatal-ni-connect-error-xxxx-from-your-alert-log/ to Hybrid Mode Switch to Threaded Mode 08-24-2002,05:48 AM #1 diwakar View Profile View Forum Posts Member Join Date May 2002 Posts 193 Dear Sir, Could anyone let me know the cause of these errors in sqlnet.log ------------------------------------------------------------------------ Fatal NI connect error 12640, connecting to: (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.7.0.0 - Production http://www.dbasupport.com/forums/showthread.php?28669-sqlnet-log-errors Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production Time: 24-AUG-2002 10:15:32 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12640 TNS-12640: Authentication adapter initialization failed ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Regards, K.Diwakar Reply With Quote 08-24-2002,12:52 PM #2 rohitsn View Profile View Forum Posts Advisor Join Date Feb 2001 Location Bombay,India Posts 530 Hi, The function specified in the authentication table entry for the service failed. Enable tracing to determine the exact error. Regards, Rohit Nirkhe,Oracle/Apps DBA,OCP 8i oracle-support@indiatimes.com Thanks and Regards Rohit S Nirkhe rohitsnirkhe@rediffmail.com Reply With Quote Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Development Oracle Certification Oracle : How To Oracle Careers Oracle Positions Available Oracle Job Wanted Archives Forum Archives Other Feedback and Questions re
Topic Database design Database Admin View All Cloud infrastructure Availability Backup and recovery Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application http://searchoracle.techtarget.com/answer/Clients-cant-connect-after-registering-Oracle-server-at-domain Clusters (RAC) Applications View All Enterprise and business performance management Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, fatal ni upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure fatal ni connect Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Section Problem Solve News Get Started Evaluate Manage Problem Solve Sponsored Communities Q Clients can't connect after registering Oracle server at domain Sections Share this item with your network: Related Expert Q&A Database link works for a few days then returns an ... – SearchOracle Fatal NI connect error – SearchOracle Problems with Oracle applications after upgrading to ... – SearchOracle Sponsored News How DBAs Can Drive Oracle Performance With All-Flash