My Oracle Support Banner

OEM 13c Reports "ORA-01882: timezone region not found" on Home Page of the Cluster DB Target (Doc ID 2596578.1)

Last updated on NOVEMBER 17, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

OEM 13.2.1.0.0
Newly discovered 12.1.0.2 cluster DB target is being shown in metric evaluation error with the below error reported in home page:

Regions that display real-time data will not be displayed. Exception while loading RAC Database Home Page: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found
ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found



Output of the getmetric giving the below error:

emctl getmetric agent TARGET_NAME,TARGET_TYPE,Response
Oracle Enterprise Manager Cloud Control 13c Release 2
Copyright (c) 1996, 2016 Oracle Corporation.  All rights reserved.
---------

Status,State,oraerr,Archiver,DatabaseStatus,ActiveState
0,UNKNOWN,Failed to connect: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
,UNKNOWN,UNKNOWN,UNKNOWN

emctl reload agent dynamicproperties -upload_timeout 240 TARGET_NAME:TARGET_TYPE
Oracle Enterprise Manager Cloud Control 13c Release 2
Copyright (c) 1996, 2016 Oracle Corporation.  All rights reserved.
---------
EMD reload error:Target rac_database.TARGET_NAME is broken: Target {rac_database.TARGET_NAME} is broken: Get dynamic property error,Dynamic Category property error - Failed to connect: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found



 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.