ORA-12154 TNS Error

Document ID : KB000107772
Last Modified Date : 25/07/2018
Show Technical Document Details
Issue:
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' 
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.