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 APRIL 30, 2014

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>/gc_inst/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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms