Oracle 10g Listener Error 1060
Contents |
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 failed to start service error 0 on and reload this page. Please enter a title. You
Tns-12560: Tns:protocol Adapter Error
can not post a blank message. Please type your message and try again. More discussions in Database Installation All PlacesDatabaseGeneral Database DiscussionsDatabase Installation This discussion is archived 1 2 3 Previous Next 39 Replies Latest reply on Sep 26, 2008 9:08 PM by 661470 Go to original post This content has been marked as final. Show 39 replies 30. Re: Could not start the TNSListener service on Local Computer ebrian Sep 26, 2008 3:20 AM (in response to 661470) Have you started the database itself? set oracle_sid=hcm sqlplus / as sysdba SQL> startup Like Show 0 Likes(0) Actions 31. Re: Could not start the TNSListener service on Local Computer 661470 Sep 26, 2008 3:33 AM (in response to ebrian) Yes - when I issue the startup command it says that Oracle is already running. Like Show 0 Likes(0) Actions 32. Re: Could not start the TNSListener service on Local Computer 654268 Sep 26, 2008 8:10 AM (in response to 661470) do the following sqlplus / as sysdba sql> alter system register; sql> show parameter listener -- note down this value exit c:\> lsnrctl services cross check whether the lservice is registered. Like Show 0 Likes(0) Actions 33. Re: Could not start the TNSListener service on Local Computer 661470 Sep 26, 2008 2:15 PM (in response to 654268) Result of show parameter listener: local_listener remote_listener both type string, nothing in Value column. Result of lsnrctl services: LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 25-SEP-2008 23:13:30 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting t
Stopped OracleOraDb11g_home1TNSListener Service On Local Computer Started And Then Stopped alex February 11, 2011 2 Comments Tweet While doing some testing of Oracle on a Windows 7 computer I stopped the TNS Listener service also known as OracleOraDb11g_home1TNSListener. The problem is when I attempted to restart the service it would not start. While testing various other things I had made numerous changes so I started looking into what might cause the issue and was pretty confident that the $ORACLE_HOME variable I set within the Windows Environment Variables was probably the culprit. Below I describe more details about the error as well as how I resolved the TNS Listener https://community.oracle.com/thread/712995?start=30&tstart=0 not being able to start. OracleOraDb11g_home1TNSListener Service On Local Computer Started And Then Stopped: I also attempted to start the Oracle TNS Listener service from the command line using net start but ended up with a similar error as shown below. net start OracleOraDb11g_home1TNSListener Error: text C:\>net start OracleOraDb11g_home1TNSListener The OracleOraDb11g_home1TNSListener service is starting. The OracleOraDb11g_home1TNSListener service could not be started. The service did not report https://www.question-defense.com/2011/02/11/oracleoradb11g_home1tnslistener-service-on-local-computer-started-and-then-stopped an error. More help is available by typing NET HELPMSG 3534. C:\> As you can see above the Oracle TNS Listener would attempt to start and then fail. You can also check the status of the Oracle TNS Listener using the lsnrctl command as shown below. Check Status Of Oracle TNS Listener On Windows 7: text C:\> lsnrctl status LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 17-FEB-2011 01:34:45 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 2: No such file or directory Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown error Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.10)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown error C:\> Anyhow my issue did end up being with the $ORACLE_HOME variable I had set to troubleshoot something else. Once the incorrect $ORACLE_HOME variable was removed from the Windows 7 Environment Variables I was able to start the Oracle TNS Listener without issue as shown below. Start Oracle TNS Listener Using lsnrctl C
start. [message #557883] Sat, 16 June 2012 23:30 dsnaveen Messages: 3Registered: http://www.orafaq.com/forum/t/182079/ June 2012 Junior Member Hello huys, Please need your help in resolving the error C:\Documents and Settings\naveen>lsnrctl start PLSExtProc LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 17-JUN-2012 11:41 :02 Copyright (c) 1991, 2006, Oracle. All rights reserved. Starting tnslsnr: please oracle 10g wait... Failed to open service
be down. Please try the request again. Your cache administrator is webmaster. Generated Sun, 23 Oct 2016 16:15:03 GMT by s_wx1085 (squid/3.5.20)