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 SEPTEMBER 01, 2016

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

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