After Database Upgrade Error ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
Last updated on APRIL 18, 2017
Applies to:Oracle Applications DBA - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, ISSUES WITH FUNCTIONALITY OF AD UTILITIES
When attempting to run Adadmin after Database upgrade to make sure the system is working correctly the following error occurs.
Exception oracle.aurora.server.tools.loadjava.ConnectionError: could not open connection
SQL Error while connecting with thin driver to (DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=server.tnb.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=YYY.ZZZZ))): Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Database upgraded from 22.214.171.124 to 126.96.36.199
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms