ORA-01804 error WP and CP do not start

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The AE server did not come up. The following error appears in the WP or CP log:

20210316/170210.476 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 2420510  DB-HDBC: 0
20210316/170210.477 - U00003591 UCUDB - DB error info: OPC: 'OCIEnvNlsCreate' Return code: 'ERROR'
20210316/170210.477 - U00003592 UCUDB - Status: '' Native error: '1804' Msg: 'Error while trying to retrieve text for error ORA-01804'
20210316/170210.477 - U00003590 UCUDB - DB error: 'OCIEnvNlsCreate', 'ERROR   ', '', 'Error while trying to retrieve text for error ORA-01804'
20210316/170210.477 - U00003611 DB OPEN executed. Return Code = '0000003590'
20210316/170210.477 - U00003620 Routine 'UCMAIN_R' forces trace because of error.
20210316/170210.477 - U00003590 UCUDB - DB error: 'OCIEnvNlsCreate', 'ERROR   ', '', 'Error while trying to retrieve text for error ORA-01804'
20210316/170210.515 - U00003449 Output to the TRACE file is finished.
20210316/170210.515 - U00003100 Memory TRACE was opened with the switches '0000000000000000'.
20210316/170210.515 - U00003380 Server 'UC4#WP' version '12.3.5+hf.2.build.1614346190490' (Runtime '0/00:00:00', Log# '1', Trc# '0').
20210316/170210.515 - U00003491 There is a time difference of '0/00:00:00' or '0' seconds to the Primary Server.
20210316/170210.515 - U00003375 Server usage of the last minute '0%', the last 10 minutes '0%' and the last hour '0%'.
20210316/170210.516 - U00003590 UCUDB - DB error: 'OCIEnvNlsCreate', 'ERROR   ', '', 'Error while trying to retrieve text for error ORA-01804'
20210316/170210.517 - U00003410 Server 'UC4#WP' version '12.3.5+hf.2.build.1614346190490' ended abnormally

Cause

This Oracle error is an indication that an environmental variable is not set correctly.

Environment

Release : 12.3

Component :

Resolution

Check the out put of the Unix command 'env' and check how variables like $ORACLE_HOME are set in .bashrc or .bash_profile.