3 Replies Latest reply: Jan 14, 2013 8:27 AM by 729777 RSS

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

    687349
      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