OraFAQ Forum: Networking and Gateways » Listener not working after changing IP Address

Home » RDBMS Server » Networking and Gateways » Listener not working after changing IP Address (windows 2012, oracle 12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Listener not working after changing IP Address [message #638149]

Thu, 04 June 2015 05:27

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hello All,

I am having a peculiar issue.

We have a test DB, was working, when the Network Team changed the IP Address of the server, then the listener stopped working.

Then, we recreated the listener still it shows the below error.

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

My listener file as below:


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ******)
      (ORACLE_HOME = C:\Oracle\ORA12C\**************)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:**************")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = **************)(PORT = 1521))
    )
  )

Kindly help

Regards
Muktha

Report message to a moderator