Oracle – Database – Changing the IP address causes Listener to stop or failed to start

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:

<ORACLE_HOME>/network\admin\listener.ora

and updated following entry with new IP address.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s