Oracle 10g No Listener Error
Contents |
Anil Kumar on June 26, 2013 All Posts, Database, Oracle DBA 18 Comments Resolved ORA-12541: TNS no listener error 4.57 (91.43%) 7 votes N
Ora 12541 Tns No Listener But Listener Is Running
no. of articles you will find on the internet about "ORA-12541 TNS ora 12541 tns no listener oracle 11g client no listener error" but still finding an effective solution. Don't worry this solution helped me a lot and I tns no listener error in oracle 11g hope it will help you too. I got the same issue while working on Oracle 10g database then I decided to share my experience and steps to resolve this issue. Error
Ora-12514 Tns :no Listener.
Message: ORA-12541 TNS no listener error Resolution: Now you have to follow below mentioned steps to resolve the ORA-12541 issue. Step-1: First check your listener status. C:\>lsnrctl status The above command will show the current status of your listener. Step-2: Start the listener, if listener is not running. C:\>lsnrctl start This command will start all your listener services. Step-3: Stop the listener,
Ora-12541 Tns No Listener Toad
if listener is running. C:\>lsnrctl stop This command will stop all your listener services. Step-4: Now restart the listener. C:\>lsnrctl reload This command will restart all your listener services. Note: If you want to see all the available listener commands. Type lsnrtcl help on command prompt and you will get all available options. C:\>lsnrctl help LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 02-JUL-2015 20:25:14 Copyright (c) 1991, 2010, Oracle. All rights reserved. The following operations are available An asterisk (*) denotes a modifier or extended command: start stop status services version reload save_config trace change_password quit exit set* show* Step-5: One last and very important thing which you have to do. Open sqlnet.ora file and make the changes as suggested. Change NTS to NONE SQLNET.AUTHENTICATION_SERVICES = (NONE) Now restart the listener services and your listener problem ORA-12541 will be resolved. If this is not working, do write in comment section. I will try to help you at the earliest. Get Free Blogging Tips & Technology updates
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies ora-12541: tns:no listener linux of this site About Us Learn more about Stack Overflow the company Business
Tns-12560: Tns:protocol Adapter Error
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask tns-00511: no listener 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 http://itbloggertips.com/2013/06/resolved-ora-12541-tns-no-listener-error/ up Oracle client ORA-12541: TNS:no listener [closed] up vote 20 down vote favorite 1 I am new on Oracle database, but I have one issue, now on my Database server (server1) listener and database instance is run correctly and I can use sqlplus to connect to this DB, But when I connect to database by using other server, I check the TNS http://stackoverflow.com/questions/13358656/oracle-client-ora-12541-tnsno-listener configuration is correct but system said ERROR: ORA-12541: TNS:no listener My database is Oracle 10gR2 So how can I solve this issue? oracle listener share|improve this question edited Sep 23 '14 at 9:26 subhashis 1,55672430 asked Nov 13 '12 at 9:58 aliasosx 1332212 closed as off-topic by Jens Erat, Annjawn, Eric Brown, g00glen00b, showdev Feb 21 '14 at 23:30 This question appears to be off-topic. The users who voted to close gave this specific reason:"Questions on professional server- or networking-related infrastructure administration are off-topic for Stack Overflow unless they directly involve programming or programming tools. You may be able to get help on Server Fault." – Jens Erat, Annjawn, Eric Brown, g00glen00b, showdevIf this question can be reworded to fit the rules in the help center, please edit the question. 3 should be a serverfault.com / dba.stackexchange.com question –Raptor Nov 13 '12 at 10:01 But when I connect to database by using other server You mean to say that when you try to connect the same database from server? –user75ponic Nov 13 '12 at 10:01 I mean I connect to
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have http://dba.stackexchange.com/questions/12384/error-ora-12541-tnsno-listener 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 http://www.orafaq.com/forum/t/191233/ 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 no listener 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 Error ORA-12541: TNS:no listener up vote 3 down vote favorite Whenever I try to start tns no listener the listener (I just have only one Oracle database) I get the following: LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=admin-41f89f35d)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 32-bit Windows Error: 61: Unknown error tnsnames.ora # TNSNAMES.ORA Network Configuration File: F:\Oracle\network\admin\tnsnames.ora # Generated by Oracle configuration tools. PROJECT = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = admin-xxxxxx)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = PROJECT) ) ) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = admin-xxxxxx)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = MODOSE) (PRESENTATION = http://HRService) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) listerner.ora # LISTENER.ORA Network Configuration File: F:\Oracle\network\admin\listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = admin-xxxxxx)(PORT = 1521)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = F:\
listener [message #606419] Thu, 23 January 2014 11:03 thelearner Messages: 133Registered: April 2013 Location: INDIA Senior Member Hi, I changed my computer Name(system). after that it showing ORA-12541: TNS :No listener I updated the system name in Tnsnames file..... I restarted all the services also.... But it showing the above error How to resolve this issue. Report message to a moderator Re: ORA-12541: TNS :No listener [message #606420 is a reply to message #606419] Thu, 23 January 2014 11:13 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member post results from OS command below that run on DB Server lsnrctl status 12541, 00000, "TNS:no listener" // *Cause: The connection request could not be completed because the listener is not running. // *Action: Ensure that the supplied destination address matches one of // the addresses used by the listener - compare the TNSNAMES.ORA entry with // the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to // go by way of an Interchange). Start the listener on the remote machine. This error can result when listener has not been started or Firewall exists between client & DB server. Report message to a moderator Re: ORA-12541: TNS :No listener [message #606421 is a reply to message #606420] Thu, 23 January 2014 11:29 thelearner Messages: 133Registered: April 2013 Location: INDIA Senior Member LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 23-JAN-2014 22:55 :13 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ ction Start Date 23-JAN-2014 22:25:09 Uptime 0 days 0 hr. 30 min. 9 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File H:\app\system\product\11.2.0\dbhome_1\network\admin\ listener.ora Listener Log File h:\app\system\diag\tnslsnr\Oracle-PC\listener\alert\ log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully Report message to a moderator Re: ORA-12541: TNS :No l