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 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:
- C:\>net start OracleOraDb11g_home1TNSListener
- The OracleOraDb11g_home1TNSListener service is starting.
- The OracleOraDb11g_home1TNSListener service could not be started.
- The service did not report 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:
- 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 Command On Windows 7:
- C:\> lsnrctl start
- LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 17-FEB-2011 01:37:09
- Copyright (c) 1991, 2010, Oracle. All rights reserved.
- Starting tnslsnr: please wait...
- TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
- System parameter file is E:\app\FILESERVER\product\11.2.0\dbhome_1\network\admin\listener.ora
- Log messages written to e:\app\fileserver\diag\tnslsnr\FILE-SERVER\listener\alert\log.xml
- Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
- Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
- Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.10)(PORT=1521)))
- Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
- STATUS of the LISTENER
- ------------------------
- Alias LISTENER
- Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
- Start Date 17-FEB-2011 01:37:15
- Uptime 0 days 0 hr. 0 min. 5 sec
- Trace Level off
- Security ON: Local OS Authentication
- SNMP OFF
- Listener Parameter File E:\app\FILESERVER\product\11.2.0\dbhome_1\network\admin\listener.ora
- Listener Log File e:\app\fileserver\diag\tnslsnr\FILE-SERVER\listener\alert\log.xml
- Listening Endpoints Summary...
- (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
- (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
- (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.10)(PORT=1521)))
- Services Summary...
- Service "CLRExtProc" has 1 instance(s).
- Instance "CLRExtProc", status UNKNOWN, has 2 handler(s) for this service...
- The command completed successfully
- C:\>
The Oracle TNS Listener is now running without issue.
acquire the recent voucher codes from the protein works
protein works discount codes
Thanks, it was really helpful.