RA OEBS Agent fails to start: ORA-01882: timezone region not found

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

RA OEBS agent does not start with the error message below in the agent's log.

20220713/082452.763 - 25     java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

 

Environment

Release : 12.x,21.x

Component : RA OEBS Agent

Cause

The timezone of the RA OEBS agent's server and of the target OEBS database is different.

Resolution

This could also be related to the timezone used by the RA OEBS agent's server that is not listed in the timezone of the target Oracle database.

-Please run the command on the server:

timedatectl |grep -i zone

-Execute SQL command on the target Oracle DB

SELECT DISTINCT tzname FROM V$TIMEZONE_NAMES;

 

If the Timezone used by the RA OEBS Agent's server is NOT listed  in the target Oracle DB, please change the Timezone used by  RA OEBS Agent's server that is listed in the Oracle DB. Restart of the server  RA OEBS Agent's server so the new Timezone will be taken into consideration.