Home » RDBMS Server » Networking and Gateways » Listener not working after changing IP Address (windows 2012, oracle 12c)
Listener not working after changing IP Address [message #638149] Thu, 04 June 2015 05:27 Go to next message
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
Re: Listener not working after changing IP Address [message #638150 is a reply to message #638149] Thu, 04 June 2015 05:32 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You have a SID_LIST entry for launching external procesures, not for registering a database service. Get rid of the PROGRAM and ENVS lines.
Re: Listener not working after changing IP Address [message #638152 is a reply to message #638150] Thu, 04 June 2015 06:10 Go to previous message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Jhon,

Yes, it is now working,

Thanks
Muktha
Previous Topic: Network disconnection
Next Topic: Dedicated servers and "handoff"
Goto Forum:
  


Current Time: Thu Mar 28 11:51:45 CDT 2024