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 184.108.40.206.0 and later
Information in this document applies to any platform.
Using Oracle Exalytics with Oracle Business Intelligence Enterprise Edition (OBIEE) and BI Publisher version 220.127.116.11.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 18.104.22.168 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.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
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