Database Error Code 12541
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ora 12541 tns no listener but listener is running ORA-12541: TNS: no listener Oracle Tips by John Garmany ora-12541 tns no listener 11g You Asked: I get the ORA-12541 error message when I try to connect through Forms6i and Reports6i Builder. I've started the listener tns no listener error in oracle 11g also. I have no problems accessing the database through SQL*Plus. I've checked the listener.ora and tnsnames.ora files and everything seems okay. We Said: From the docs: ORA-12541: TNS no listener Cause: Listener for the source ora 12541 tns no listener oracle 11g client repository has not been started. Action: Start the Listener on the machine where the source repository resides. Basically the Forms server could not find the listener. First check the tnsnames.ora file and ensure that it points to the correct server and port. If the Forms server is on another machine, test the TNS resolve with tnsping from the command prompt. Finally, check the listener. First, ensure that your listener service is running.Ora 12541 Tns No Listener Toad
C:\Documents and Settings\ME>lsnrctl stat This should show the status of the listener and the services it is listening for. Remember that when you run SQL*Plus on the database server, it does not need the listener to connect unless you specify the database tnsnames.ora entry.Try to start the listener service using lsnrctl from DOS prompt. set ORACLE_HOME= cd %ORACLE_HOME%/bin lsnrctl start LISTENER If the listener service is not running, re-start the listener service using the Windows task manager or use the DOS command line utility to re-start the Windows service with the "net start" command: C:\Documents and Settings\ME>net start OracleOraDb10g_home1TNSListener You can use the lsnrctl status command to verify that the listener is down, and lsnrctl start to start your listener. If you are on Windows, also verify that the listener service is running. Here are more notes on lsnrctl: Oracle listener lsnrctl command Oracle listener lsnrctl command Oracle listener security tips Blocking Oracle access by IP Addresses �� Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting pro
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have
Ora-12541: Tns:no Listener Linux
Meta Discuss the workings and policies of this site About Us tns-12560: tns:protocol adapter error Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with ora-12541: tns:no listener windows 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 http://www.dba-oracle.com/t_ora_12541_tns_no_listener.htm 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 the http://dba.stackexchange.com/questions/12384/error-ora-12541-tnsno-listener 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:\Oracle) (PROGRAM =
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 it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and https://community.oracle.com/thread/371929 try again. More discussions in PL/SQL and SQL All PlacesDatabaseDatabase Application DevelopmentPL/SQL and SQL This http://www.orafaq.com/wiki/ORA-12541 discussion is archived 11 Replies Latest reply on Mar 13, 2006 11:25 AM by 496898 ORA-12541 TNS :no listener. 472972 Mar 13, 2006 5:15 AM Hi All, I have installed oracle server on my machine, but not able to login Scott with password as tiger. The error is ORA-12541 no listener. So I have changes an entry in the tnsnames.ora, no listener also added a listener to listener.ora for same entry. Can you please suggest any next steps in this direction? Thanks 285621Views Tags: none (add) This content has been marked as final. Show 11 replies 1. Re: ORA-12541 TNS :no listener. 453363 Mar 13, 2006 5:40 AM (in response to 472972) please check whether the listener service is up and running or else try lsnrctl and start the listener Like Show 0 Likes(0) Actions 2. Re: ORA-12541 tns no listener TNS :no listener. 472972 Mar 13, 2006 5:47 AM (in response to 453363) Hi, Thanks for the reply. I have started the listener but now while connecting getting an error ORA-12154 TNS:could not resolve the service name. Can you please help with some next steps Thanks a lot Like Show 0 Likes(0) Actions 3. Re: ORA-12541 TNS :no listener. 453363 Mar 13, 2006 5:53 AM (in response to 472972) Do u have any domain name set.... like .us.oracle.com Or else please check the sqlnet.ora and tnsnames.ora file Like Show 0 Likes(0) Actions 4. Re: ORA-12541 TNS :no listener. 477152 Mar 13, 2006 6:04 AM (in response to 453363) Hi, check the user name and password. if u r connecting like SQL> sqlplus scott/tiger@oracle9i then check whether the service oracle9i is present in tnsnames.ora if not edit it and shutdown and restart the databse. Trinath Somanchi, Like Show 0 Likes(0) Actions 5. Re: ORA-12541 TNS :no listener. 472972 Mar 13, 2006 6:52 AM (in response to 477152) Hi Sashi/Trinath I am getting a bit confused.....so let me start again While installing the oracle server, the insatalltaion asks you for 1) SID 2) Global Database Name so i provided the following values SID=practice Global Database Name=axxx.byyy The tnsoranames conatins the follwing enrty axxx.byyy.com= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.18.39)(PORT = 1
causes this error?[edit] An ORA-12541 error occurs when the listener for the destination server is down or unreachable when you try to connect. This can be due to the listener not being started or being incorrectly configured, or it can be due to a network connection problem. How to fix it[edit] Make sure that the listener is up and listening on the address[edit] For example if you want to connect to the instance with SID=ORCL on a computer named TAMIN_NT using TCP protocol on PORT=1521 then it means that a listener has to be associated with SID = ORCL on machine TAMIN_NT and be listening for TCP protocol on port 1521. The listener must be up and running when one requests a connection. To check that the listener is up and running use operating system facilities (like Start -> Settings -> Control Panel -> Services under NT) or LSNRCTL (Listener Control Program.) The STATUS command of LSNRCTL shows the current state of the listener. If the listener is up and running then it may not have been associated with correct instance or not listening for the specified protocol. This information is the Listener Parameter File ( a text file) usually located under ORACLE_HOME\Network|Admin with the name of listener.ora. The STATUS command of LSNRCTL also shows the current location of this file. However, in my personal experience a STOP and START command in LSNRCTL is required for the STATUS command to show latest changes, especially when there are multiple Oracle homes on the same computer. The listener parameter file consists of two parts. The first part is the specification of the protocols for which this listener is listening, and the second part specifies the instances to which this listener is attached. Check and make sure that they are correct. You may edit listener.ora file either by an ordinary text editor or by using the Oracle Net8 Assistant utility. Just keep in mind that a restart of the listener is required for the changes to be effective. Here is an example listener.ora file: # Filename......: listener.ora # Node..........: local.world # Date..........: 24-MAY-94 13:23:20 ################ LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC) (KEY= oracle.world) ) (ADDRESS= (PROTOCOL= IPC) (KEY= ORCL) ) (ADDRESS= (COMMUNITY= NMP.world) (PROTOCOL= NMP) (SERVER= NTSERVER) (PIPE= ORAPIPE) ) (ADDRESS= (PROTOCOL= TCP) (Host= ntserver) (Port= 1521) ) (ADDRESS= (PROTOCOL= TCP) (Host= ntserver) (Port= 1526) ) (ADDRESS= (PR