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"
Last updated on SEPTEMBER 01, 2016
Applies to:Oracle Exalytics Software - Version 220.127.116.11.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 18.104.22.168.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 22.214.171.124 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms