Oracle 11g Fatal Ni Connect Error 12541
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 proceed.
Fatal Ni Connect Error 12170 Tns-12535
To start viewing messages, select the forum that you want to visit from the selection fatal ni connect error 12170 ora-3136 below. Results 1 to 8 of 8 Thread: TNS-12541: TNS:no listener | Lister is UP Tweet Thread Tools Show Printable Version Email ns main err code: 12535 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 listener |
Nt Secondary Err Code: 60
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. Most of the
Fatal Ni Connect Error 12170 Oracle 12c
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-FEB-2011 12:09:35 Tracing not turned on.
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without fatal ni connect error 12637 it enabled. Please turn JavaScript back on and reload this
Fatal Ni Connect Error 12638
page. Please enter a title. You can not post a blank message. Please type nt secondary err code: 110 your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 3 Previous Next http://www.dbasupport.com/forums/showthread.php?61789-TNS-12541-TNS-no-listener-Lister-is-UP 44 Replies Latest reply on Sep 17, 2008 3:16 AM by Maran Viswarayar Go to original post This content has been marked as final. Show 44 replies 15. Re: ORA-TNS:12541 639811 Sep 12, 2008 4:52 PM (in response to EdStevens) Hi steven Ha ha Ha... i laughed myself after https://community.oracle.com/thread/707091?start=15&tstart=0 reading ur mail..Anyway its good ya.. i m saying two listeners in that sense all listeners are up.(i too know its a server side connection establish file) now lets come to the matter.. first i ll start from the tnsping on client machine: ***************************************** TNS Ping Utility for Linux: Version 9.2.0.5.0 - Production on 12-SEP-2008 21:45:58 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: /oracle/product/92040/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.3.30)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = OWAZUAT1))) OK (10 msec) [oracle@inp1db02 ~]$ sqlplus system@owazuat1 SQL*Plus: Release 9.2.0.5.0 - Production on Fri Sep 12 21:46:33 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter password: ERROR: ORA-12541: TNS:no listener sqlnet_client.log(client machine) **************************** Fatal NI connect error 12514, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.30)(PORT=1521))(CONNECT_DATA=( SERVER=DEDICATED)(SERVICE_NAME=OWAZDEVPS)(CID=(PROGRAM=)(HOST=inp1db02.bagic.com )(USER=orac
to friend Error with shipping redo log from primary to standby [message #601350] Tue, 19 November 2013 20:56 trantuananh24hg Messages: 666Registered: January 2007 Location: Ha Noi, Viet Nam Senior Member Good http://www.orafaq.com/forum/t/190397/ morning! I've got error yesterday. Let me describe: I configure DG successfully at http://stackoverflow.com/questions/2059795/using-oracle-db-through-ssh-tunnel-error-ora-12541-tnsno-listener 15/10/2013, both of them are Oracle 11gr2, ASM, RHEL 5 (single), they are fine till 19/11/2013 when system administrator change the IP of primary. So, I got error shipping redo log from primary to standby. P/S: Because of long brief, so I device into 2 post. I'm sorry for inconvenience Primary (RHEL 5.5, fatal ni Oracle 11gr2 Grid Infrastructure, Enterprise) Error: Log Transport Services Error 2 1066 12504 YES 20-NOV-13 PING[ARC1]: Heartbeat failed to connect to standby 'wbstdby'. Error is 12504. Log Transport Services Error 0 1067 12504 YES 20-NOV-13 Error 12504 received logging on to the standby Log Transport Services Error 2 1068 12504 YES 20-NOV-13 PING[ARC1]: Heartbeat failed to connect to standby 'wbstdby'. Error is 12504. Log Transport Services fatal ni connect Error 0 1069 12504 YES 20-NOV-13 Error 12504 received logging on to the standby Log Transport Services Error 2 1070 12504 YES 20-NOV-13 PING[ARC1]: Heartbeat failed to connect to standby 'wbstdby'. Error is 12504. - error log file * alert log file: Fatal NI connect error 12541, connecting to: (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=)(CID=(PROGRAM=oracle)(HOST=webcharge)(USER=oracle)))(ADDRESS=(PROTOCOL=TCP)(HOST=10.54.5. 177)(PORT=1521))) VERSION INFORMATION: TNS for Linux: Version 11.2.0.1.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production Time: 19-NOV-2013 01:16:44 Tracing not turned on. Tns error struct: ns main err code: 12541 TNS-12541: TNS:no listener ns secondary err code: 12560 nt main err code: 511 TNS-12564: TNS:connection refused ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 TNS-00511: No listener nt secondary err code: 111 nt OS err code: 0 Error 12541 received logging on to the standby Check whether the listener is up and running. Errors in file /webcharge/app/oracle/diag/rdbms/webcharge/webcharge/trace/webcharge_arc1_4980.trc: ORA-12541: TNS:no listener PING[ARC1]: Heartbeat failed to connect to standby 'wbstdby'. Error is 12541. * dump file [oracle@webcharge trace]$ more /webcharge/app/oracle/diag/rdbms/webcharge/webcharge/trace/webcharge_arc1_4980.trc Trace file /webcharge/app/oracle/diag/rdbms/webcharge/webcharge/trace/webcharge_arc1_4980.trc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mi
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 Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Using oracle db through ssh tunnel. Error “ORA-12541: TNS:no listener” up vote 8 down vote favorite 2 Hello I've got a problem accessing Oracle DB from our datacenter through a tunnel. We've got a pretty standard datacenter with one machine being accessible from the outside (I put it's IP in the /etc/hosts file as dc) and the Oracle DB inside. The IP address of our oracle database on internal network is 192.168.1.7 To create a tunnel I'm using the command: ssh -L 1521:192.168.1.7:1521 root@dc and of course it works (sometimes I also add some debug -vv to see if anything is passing through). Now the difficult part - connecting to Oracle. I installed instantclient 11.2. and my tnsnames.ora looks like that: testdb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dbname) ) ) And when I try to connect using the command: ./sqlplus username/pass@testdb It starts connecting through the tunnel (I see it in the ssh debug) but then it fails telling: ./sqlplus username/pass@testdb SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 13 20:46:07 2010 Copyright (c) 1982, 2009, Oracle. All rights reserved. ERROR: ORA-12541: TNS:no listener Enter user-name: When I'm trying to execute this same command on when I'm on the intranet it works (obviously the only difference is that in the tnsnames.ora HOST we have 192.168.1.7 and not the localhost). I also tried to use the simple command line: ./sqlplus username/pass@//localhost:1521/testdb or alternatively ./sqlplus username/pass@//localhost:1521/testdb But nothing helped :) I would appreciate any help or suggestions. Am I missing some ssh flag to make it possible? Probably the log file: *********************************************************************** Fatal NI connect error 12541, connecting to: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=DBNAME)(CID=(