My Oracle Support Banner

OBI Publisher Data Source On Exalytics Fails With Errors: "Could not create pool connection... DBMS driver exception ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found" (Doc ID 1555994.1)

Last updated on FEBRUARY 02, 2020

Applies to:

Oracle Exalytics Software - Version 1.0.0.2.0 and later
Information in this document applies to any platform.

Symptoms

Using Oracle Exalytics with Oracle Business Intelligence Enterprise Edition (OBIEE) and BI Publisher version 11.1.1.6.5 (Build 121010.0955 64-bit).
When trying to use Web Logic Server (WLS) version 10.3.6 to create a new JDBC Data Sources for an Oracle 9.2.0.8 database, and selecting driver Oracle Driver (Thin) for Instance connections; Versions:9.0.1 and later,
it fails with error:

Connection test failed.
ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found ...

Activate changes also gives error:

An error occurred during activation of changes, please see the log for details.

weblogic.application.ModuleException:
weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: ORA-00604: error occurred at recursive SQL level 1 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


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