TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
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