OWB Control Center Service Start Results In ORA-01882: Timezone Region Not Found (Doc ID 391717.1)

Last updated on AUGUST 27, 2014

Applies to:

Oracle Warehouse Builder - Version 10.2 and later
Information in this document applies to any platform.
Warehouse Builder, Control Center

Symptoms

The Control Center Service fails to start.

The Control Center Service log file shows:

runtime service connection failure for user OWB_REP on Service
TEST.Hostname.comp.com at Host Hostname -RPE-01003: An infrastructure condition prevented the request from completing.
- ORA-01882: timezone region not found

 

Or

A manual start shows  :

SQL> @C:\oracle\owb\owb\rtp\sql\start_service.sql
Not available
Diagnostics:
service startup failure using command "cmd /q/c c:\oracle\owb\owb\bin\win32\run
_service.bat -manual 1 c:\oracle\owb DWH_REP localhost 1521 AAADWH" reason ORA-
29532: Java call terminated by uncaught Java exception: java.io.IOException: se
rvice early exit: code=0 : err=2007/10/05-14:11:57-GMT+02:00 [126804E] oracle.w
h.runtime.platform.adapter.InfrastructureException: RPE-01003: An infrastructur
e condition prevented the request from completing.
- ORA-01882: timezone region not found
at oracle.wh.runtime.platform.service.controller.PlatformDb.con
nect(PlatformDb.java:83)
at oracle.wh.runtime.platform.service.Service.<init> (Service.java:125

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