SQL Job failing with ORA-12154 error after upgrading Oracle from 10g to 11i
book
Article ID: 85094
calendar_today
Updated On:
Products
CA Automic Applications Manager (AM)
Issue/Introduction
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.
Cause
Cause type: Other Root Cause: When using a local Oracle database, a network alias does not need to be defined for the login.
Environment
OS Version: N/A
Resolution
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.