Fatal Ni Connect Error 12541 Connecting To
Contents |
TNS:no listener | Lister is UP If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to
Fatal Ni Connect Error 12170 Tns-12535
proceed. To start viewing messages, select the forum that you want to visit from the fatal ni connect error 12170 ora-3136 selection below. Results 1 to 8 of 8 Thread: TNS-12541: TNS:no listener | Lister is UP Tweet Thread Tools Show Printable Version
Ns Main Err Code: 12535
Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-15-2011,10:35 AM #1 poling View Profile View Forum Posts Junior Member Join Date Feb 2011 Posts 4 TNS-12541: TNS:no nt secondary err code: 60 listener | Lister is UP Hi, im struggling with a listener issue. I have several Oracle/SAP environments i am responsible for. Most of them run fine but on some i get the error: TNS-12541: TNS:no listener. On one of them this occurs quite a lot actually. So what is the case? Im running Oracle 10.2.04 on windows 2003, of course the listener is running (DUH). Also the tnsnames.ora sqlnet.ora and listener.ora are defined properly. fatal ni connect error 12637 Most of the cases it is not even causing issues (since it SAP is running on top of it). However some actions do start a process outside the SAP instance, like applying a SAP transport. And on those cases sometimes I get the above mentioned error. So I got suspicious and started a tnsping in a loop. It turns out the 12541 pops up quite regularly, enough to make me worried. The frequency change from several times a minute to once every couple of minutes. It doesn’t seems to be an network issue since a ping to wherever always goes fine. So I turned on tracing (in the listener.ora) on to level ADMIN, turns out there are no trace entries from the failed tnsping. I moved up the level to SUPPORT. Same, no trace entries, there is a time gap on the moments that tnsping fails. The same counts for the listener.log…no logging of the failed occurrences. Then I added a R3trans –d in the loop. Of course this check also fails every now and then and the following info I find in the sqlnet.log Fatal NI connect error 12541, connecting to: (DESCRIPTION=(SDU=32768)(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=prd01)(PORT=1527))(CONNECT _DATA=(SID=PRD)(GLOBAL_NAME=PRD.WORLD)(CID=(PROGRAM=I:\usr\sap\PRD\SYS\exe\run\R3trans.exe)(HOST=PRD 01)(USER=prdadm)))) VERSION INFORMATION: TNS for 64-bit Windows: Version 10.2.0.2.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 10.2.0.2.0 - Production Time: 15-F
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 12637 Connecting To (local=no)
entries for Fatal NI connect error. Examples: *********************************************************************** Fatal NI connect error 12514, fatal ni connect error 12638 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 -
Nt Secondary Err Code: 110
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 http://www.dbasupport.com/forums/showthread.php?61789-TNS-12541-TNS-no-listener-Lister-is-UP 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 https://davidalejomarcos.wordpress.com/2011/01/18/removing-fatal-ni-connect-error-xxxx-from-your-alert-log/ 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: DIA
Wiki Search Tutorials/Articles Search HCL Search Reviews Search ISOs Go to Page... LinuxQuestions.org > Forums > Linux Forums > Linux - Networking tnsping : TNS-12541: TNS: no listener User http://www.linuxquestions.org/questions/linux-networking-3/tnsping-tns-12541-tns-no-listener-183742/ Name Remember Me? Password Linux - Networking This forum is for any issue related to networks or networking. Routing, network cards, OSI, etc. Anything is fair game. Notices Welcome to LinuxQuestions.org, a friendly and http://dba.stackexchange.com/questions/74803/oraclesid-local-no active Linux Community. You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads fatal ni and access many other special features. Registration is quick, simple and absolutely free. Join our community today! Note that registered members see fewer ads, and ContentLink is completely disabled once you log in. Are you new to LinuxQuestions.org? Visit the following links: Site Howto | Site FAQ | Sitemap | Register Now If you have any problems with the registration process or your account login, please contact fatal ni connect us. If you need to reset your password, click here. Having a problem logging in? Please visit this page to clear all LQ-related cookies. Introduction to Linux - A Hands on Guide This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter. For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own. Click Here to receive this Complete Guide absolutely free. Search this Thread 05-20-2004, 10:42 AM #1 hpmface LQ Newbie Registered: May 2004 Posts: 2 Rep: tnsping : TNS-12541: TNS: no listener Hi all, i have a problem to connect to a oracle database instance with my client. client OS = Fedora core 1 with oracle 10g client server
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top oracle