Our network team assigned one of our Oracle Server to new VLAN and that requires to assign new IP address to the server.
i disable the network card on the server and enable it again to get the new IP from DHCP.
Later our network team applied the policy to keep the Same IP for this machine.
While testing Oracle Connections with this machine , it start giving Error :
ORA-12541: TNS: no listener
Actually changing the IP stopped with Listener and while trying to start it using “Services” it was giving Unexpected error and Unable to start Service in timely fashion.
I thought of binding of Listener with old IP and just as a “Hit & Trial” method, I opened listener.ora file on the following Path:
and updated following entry with new IP address.
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
After that i just try to restart the Listener service from “Services” and it worked fine for me.