ORA-12154 TNS Error

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Unable to log into the UI because AE is not up and running.
AE processes cannot start because they are unable to connect to the DB. 

Error: 
U00003590 UCUDB - DB error: 'OCILogon', 'ERROR ', '', 'ORA-12154: TNS:could not resolve the connect identifier specified' 

Environment

Release: AUTWAB99000-11.2-Automic Workload Automation-Base Edition
Component:

Resolution

The error message is coming directly from Oracle and being reported by Automic.

It is saying that TNS cannot connect to the database specified in the SQLDRIVERCONNECT setting of the ucsrv.ini file. Please have your DBA verify that a TNS entry matches the DSN specified in the SQLDRIVERCONNECT setting. A test can be done by running the following in the command line: 

sqlplus <user>/<pass>@<dsn> 

where you have specified the same username, password, and DSN entry as are specified in the SQLDRIVERCONNECT setting.