My Oracle Support Banner

EM 12c: Generating "Response And Load" Graph For Weblogic Target in Enterprise Manager Cloud Control Console Fails with java.sql.SQLDataException: ORA-01882: timezone region not found (Doc ID 1375262.1)

Last updated on DECEMBER 13, 2019

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.1.0 to 12.1.0.2.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Note: this problem can also occur in ENterprise manager Grid Control 11g. Please check the document:

<Document 1148503.1> - 11g Grid Control "Response and Load" Graph for Weblogic Server Targets Shows "ORA-01882: timezone region not found"

"Response and Load" graph on any weblogic target home page in Enterprise manager Cloud Control 12c shows the following error:

Error fetching data :
java.sql.SQLDataException: ORA-01882: timezone region not found
timezone region not found ORA-06512: at "SYSMAN.MGMT_GLOBAL", line 8

- Following are the errors shown in <EM_INSTANCE_BASE>/em/EMGC_OMS1/sysman/log/emoms.trc:

[[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN graph.MetricChartDataSourceImpl logp.251 - java.sql.SQLDataException: ORA-01882: timezone region not found
ORA-06512: at "SYSMAN.MGMT_GLOBAL", line 8

java.sql.SQLDataException: ORA-01882: timezone region not found
ORA-06512: at "SYSMAN.MGMT_GLOBAL", line 8

-
Followed the steps as mentioned in the below note by setting TZ variable to "Australia/Brisbane" but still getting the ORA-01882 error on the weblogic home page.
<Note 1148503.1> - "Response and Load" Graph for Weblogic Server Targets Shows "ORA-01882: timezone region not found"

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
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.