1 2 Previous Next 28 Replies Latest reply: May 29, 2013 12:36 AM by 913809 Go to original post RSS
      • 15. Re: ORA-01882: timezone region  not found
        897457
        SQL DEVELOPER


        edit this config file:


        C:\Program Files\sqldeveloper 3\sqldeveloper\bin\sqldeveloper.conf


        then add this line anywhere in the file:


        AddVMOption -Duser.timezone="+02:00" (My time zone)





        ORACLE DATA MODELER


        edit this config file:


        C:\Program Files\datamodeler 3\datamodeler\bin\datamodeler.conf


        then add this line anywhere in the file:


        AddVMOption -Duser.timezone="+02:00" (My time zone)
        • 16. Re: ORA-01882: timezone region  not found
          671653
          Hello There!

          I had the next error when I try to connect to a DB using SQLDeveloper 3.1.06 Buil-MAN-06.82, OSX Version.

          >
          An error was encountered performing the requested operation:

          ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found 00604. 00000 - "error occurred at recursive SQL level %s"
          *Cause:    An error occurred while processing a recursive SQL statement
          (a statement applying to internal dictionary tables).
          *Action:   If the situation described in the next error on the stack
          can be corrected, do so; otherwise contact Oracle Support.
          Vendor code 604
          I found the solution in here :), In OSX (Lion 10.7.2), edited this file:

          >
          /Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf
          And just add my timezone code

          >
          AddVMOption -Duser.timezone="-06:00"
          then, just restarted SQLDeveloper and Voila! works fine :)


          Rgrd,
          iVieL

          p.s. Thank you to everyone involved in this thread :P
          • 17. Re: ORA-01882: timezone region  not found
            922176
            you rocks, timgaulza!!!!!!!!!!
            simple fix for a time consuming error!!!!!!!!!
            • 18. Re: ORA-01882: timezone region  not found
              user11321596
              Thank you, this was very helpful
              • 19. Re: ORA-01882: timezone region  not found
                925051
                This solution is perfect. Thanks
                • 20. Re: ORA-01882: timezone region  not found
                  921728
                  yea where is d code added?
                  • 21. Re: ORA-01882: timezone region  not found
                    928425
                    Thanks.. It worked.
                    • 22. Re: ORA-01882: timezone region  not found
                      943949
                      hi

                      when im trying to create a master repository on oracle data integrator i get this error message

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

                           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
                           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:397)
                           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
                           at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:662)
                           at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:438)
                           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
                           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
                           at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:370)
                           at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:817)
                           at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:376)
                           at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:670)
                           at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:230)
                           at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
                           at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
                           at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:409)
                           at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:385)
                           at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:352)
                           at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:331)
                           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:99)
                           at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
                           at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1121)
                           at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1066)
                           at oracle.odi.ui.gallery.support.MasterCreateRepositoryPage.getLocalConnect(MasterCreateRepositoryPage.java:750)
                           at oracle.odi.ui.gallery.support.MasterCreateRepositoryPage.testLocalConnect(MasterCreateRepositoryPage.java:1129)
                           at oracle.odi.ui.gallery.support.MasterCreateRepositoryPage.testConnections(MasterCreateRepositoryPage.java:1082)
                           at oracle.odi.ui.gallery.support.MasterCreateRepositoryPage.access$3(MasterCreateRepositoryPage.java:1080)
                           at oracle.odi.ui.gallery.support.MasterCreateRepositoryPage$IvjEventHandler.actionPerformed(MasterCreateRepositoryPage.java:114)
                           at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
                           at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
                           at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
                           at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
                           at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
                           at java.awt.Component.processMouseEvent(Component.java:6289)
                           at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
                           at java.awt.Component.processEvent(Component.java:6054)
                           at java.awt.Container.processEvent(Container.java:2041)
                           at java.awt.Component.dispatchEventImpl(Component.java:4652)
                           at java.awt.Container.dispatchEventImpl(Container.java:2099)
                           at java.awt.Component.dispatchEvent(Component.java:4482)
                           at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
                           at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
                           at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
                           at java.awt.Container.dispatchEventImpl(Container.java:2085)
                           at java.awt.Window.dispatchEventImpl(Window.java:2478)
                           at java.awt.Component.dispatchEvent(Component.java:4482)
                           at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644)
                           at java.awt.EventQueue.access$000(EventQueue.java:85)
                           at java.awt.EventQueue$1.run(EventQueue.java:603)
                           at java.awt.EventQueue$1.run(EventQueue.java:601)
                           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
                           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
                           at java.awt.EventQueue$2.run(EventQueue.java:617)
                           at java.awt.EventQueue$2.run(EventQueue.java:615)
                           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
                           at java.awt.EventQueue.dispatchEvent(EventQueue.java:614)
                           at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
                           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
                           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
                           at java.awt.Dialog$1.run(Dialog.java:1046)
                           at java.awt.Dialog$3.run(Dialog.java:1098)
                           at java.awt.Dialog.show(Dialog.java:1096)
                           at java.awt.Component.show(Component.java:1585)
                           at java.awt.Component.setVisible(Component.java:1537)
                           at java.awt.Window.setVisible(Window.java:842)
                           at java.awt.Dialog.setVisible(Dialog.java:986)
                           at oracle.bali.ewt.wizard.WizardDialog.runDialog(WizardDialog.java:382)
                           at oracle.bali.ewt.wizard.WizardDialog.runDialog(WizardDialog.java:298)
                           at oracle.ide.dialogs.WizardLauncher.runDialog(WizardLauncher.java:51)
                           at oracle.odi.ui.gallery.support.AbstractMasterRepositoryWizard.invoke(AbstractMasterRepositoryWizard.java:131)
                           at oracle.odi.ui.gallery.CreateNewMasterRepositoryWizard.invoke(CreateNewMasterRepositoryWizard.java:56)
                           at oracle.ide.wizard.WizardManager.invokeWizard(WizardManager.java:372)
                           at oracle.ide.wizard.WizardManager$1.run(WizardManager.java:420)
                           at oracle.ide.util.IdeUtil$3.run(IdeUtil.java:1089)
                           at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
                           at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:642)
                           at java.awt.EventQueue.access$000(EventQueue.java:85)
                           at java.awt.EventQueue$1.run(EventQueue.java:603)
                           at java.awt.EventQueue$1.run(EventQueue.java:601)
                           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
                           at java.awt.EventQueue.dispatchEvent(EventQueue.java:612)
                           at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
                           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
                           at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
                           at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
                           at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
                           at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)


                      i already tried to add
                      AddVMOption -Duser.timezone=Cet

                      to the ojmigrator.conf file

                      but i still having the same problem

                      if any one can help

                      last thing i install it on win7 after chnaging the compatibility to xp

                      thanks
                      • 23. Re: ORA-01882: timezone region  not found
                        Udo
                        Hi and welcome to the OTN forums,

                        your issue is technically related to the original post, but it does not belong to APEX Listener - which this forum is dedicated to. You'll find the forum related to your problem here: {forum:id=374}
                        Now, just to be sure it's not just a simple typo:
                        i already tried to add
                        AddVMOption -Duser.timezone=Cet
                        Did you actually write "Cet" or did you type "CET" instead? Depending on the libraries used, it could be that timezones are matched case sensitive, so "Cet" might not be accurate.

                        -Udo
                        • 24. Re: ORA-01882: timezone region  not found
                          964821
                          Thanks you very much and It saved a lot of time !!
                          • 25. Re: ORA-01882: timezone region  not found
                            976920
                            you are answar working fine.
                            you are awesome.


                            thanqqqqqqqqq very much
                            • 26. Re: ORA-01882: timezone region  not found
                              997067
                              Hi,
                              AddVMOption -Duser.timezone="+05:30" (My time zone
                              This works for me.

                              Thanks
                              • 27. Re: ORA-01882: timezone region  not found
                                997800
                                Thanks vielinko - this fixed the same problem I was having on my mac.
                                • 28. Re: ORA-01882: timezone region  not found
                                  913809
                                  Hi ,
                                  its fixed the problem. thanks a lot for your help.
                                  Why the timezone entry not automatically updated? Is it a bug?
                                  It would be more helpful if you explain more on this.

                                  Thanks in advance,
                                  Prabhakar
                                  1 2 Previous Next