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

Document ID : KB000085094
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.

 
Environment:
OS Version: N/A
Cause:
Cause type:
Other
Root Cause: When using a local Oracle database, a network alias does not need to be defined for the login.
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