This discussion is archived
3 Replies Latest reply: Jan 14, 2013 6:27 AM by 729777 RSS

Create WLS Domain with SOA - ORA-01882: timezone region  not found

687349 Newbie
Currently Being Moderated
Hi All,

I am installing SOA 11g 11.1.1.5 on my windows 7 machine. I have installed my XE database and the dbtimezone is set to = +02:00( which i have set and bounced the db).

I have installed the RCU, Weblogic server and SOA. Now when I am trying to create a WLS domain, after I configure JDBC schemas, when i try to test it i get the following:

Component Schema=SOA Infrastructure
Driver=oracle.jdbc.xa.client.OracleXADataSource
URL=jdbc:oracle:thin:@localhost:1521/XE
User=DEV_SOAINFRA
Password=*********
SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='SOAINFRA' and version='11.1.1.5.0'

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

CFGFWK-60850: Test Failed!

Component Schema=User Messaging Service
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@localhost:1521/XE
User=DEV_ORASDPM
Password=*********
SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='ORASDPM' and version='11.1.1.2.0'

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

CFGFWK-60850: Test Failed!

Component Schema=OWSM MDS Schema
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@localhost:1521/XE
User=DEV_MDS
Password=*********
SQL Test=select 1 from schema_version_registry where
                    owner=(select user from dual) and mr_type='MDS' and
                    version='11.1.1.5.0'

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

CFGFWK-60850: Test Failed!

Component Schema=SOA MDS Schema
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@localhost:1521/XE
User=DEV_MDS
Password=*********
SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='MDS' and version='11.1.1.5.0'

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

CFGFWK-60850: Test Failed!

My Windows time region is set to (UTC+02:00) Harare, Pretoria

Any help on resolving this ?

Thanks
K

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points