Database Administration (MOSC)

MOSC Banner

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

edited Feb 12, 2015 7:14AM in Database Administration (MOSC) 1 commentAnswered

All,

I created a service using dbms_service.create_service('xyx','xyz') and dbms_service.start_service('xyz') and everything was running fine.

But lately application connection attempt started receiving TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

I would like to figure out how this service was deregistered from listener. I searched the listener log (both text and xml) for service_died keyword, don't find anything.

Is there anyway to figure out how the service became unavailable abruptly, although the database as well as listener did not have any outage

FYI: I worked around the issue just by updating the service_names parameter with the required service name

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center