SQL Job failing with ORA-12154 error after upgrading Oracle from 10g to 11i
Article ID: 85094
CA Automic Applications Manager (AM)
Error Message :
ORA-12154: TNS:could not resolve the connect identifier specified
After upgrading Oracle from 10g to 11, all SQL Jobs run from Applications Manager (AM) fail with the above ORA-12154 error.
Root Cause: When using a local Oracle database, a network alias does not need to be defined for the login.
OS Version: N/A
Ensure that the dblogin defined in Applications Manager does not have a network alias defined for the login being used by the SQL Job if the Oracle database is on the same machine as the AM Master.
If the Oracle database is local (on the same machine as the Master), remove the network alias and restart the failed SQL Jobs.