SQL Job failing with ORA-12154 error after upgrading Oracle from 10g to 11i

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.
 

Fix Version(s):
N/A

Additional Information

Workaround :
N/A