OEM 13c Reports "ORA-01882: timezone region not found" on Home Page of the Cluster DB Target
(Doc ID 2596578.1)
Last updated on SEPTEMBER 26, 2023
Applies to:
Enterprise Manager for Oracle Database - Version 13.2.1.0.0 and laterInformation 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
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
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 |