ORA-12154 TNS Error

book

Article ID: 107772

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

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.