Let's assume we have Oracle Database server installed on our machine. For some reasons, we had to change the hostname of the machine on which the Oracle db server is installed.
In that case , the tnsping stops working (host1 has been changed to host2 ).
C:\Documents and Settings\amit.upadhyay>tnsping ams
TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 11-DEC-2
011 17:28:54
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
C:\app\amit.upadhyay\product\11.1.0\db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = HOST1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_N
AME = AMS)))
TNS-12545: Connect failed because target host or object does not exist
We come to know that tnsnames.ora has to be changed and we go and change it to host2 but now we get the following error -
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = HOST2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_N
AME = AMS)))
TNS-12541: TNS:no listener
This means the listener has not started but when we try to start from services , it shows getting started but it doesn't really start. So, to see what is the actual error , open command prompt and go to the location where LSNRCTL.EXE is present -
C:\app\amit.upadhyay\product\11.1.0\db_1\BIN
Type LSNRCTL.EXE
C:\app\amit.upadhyay\product\11.1.0\db_1\BIN>LSNRCTL.EXE
LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 11-DEC-2011 17:53
:58
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL>
Enter Start and we will get some error which will point to the actual issue -
LSNRCTL> start
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Production
System parameter file is C:\app\amit.upadhyay\product\11.1.0\db_1\network\admin
listener.ora
Log messages written to c:\app\amit.upadhyay\diag\tnslsnr\inmuml0087\listener\a
ert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC152
ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HOST1)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 1001: Unknown error
Listener failed to start. See the error message(s) above...
It points to listener.ora and when we go and modify the host in this file ( host1 to host2 ) and then try perform start , the tns listener starts successfully.
LSNRCTL can be used from command prompt to debug any issues related to tns listener not starting.
