ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

ORA-12154 TNS Error


Article ID: 107772


Updated On:


CA Automic Workload Automation - Automation Engine


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. 

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


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


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.