2 Replies Latest reply on Nov 10, 2015 12:18 PM by RaviKRC

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

    RaviKRC

      Dear All,

       

      Iam trying to connect to establish a connection to an oracle database using JDBC thin client. Iam getting the following error.

       

      Could anyone please help me with a solution

       

      Operating System: Oracle linux

      Database Version : 12c

       

      java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1

      ORA-01882: timezone region not found

       

      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)

      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)

      at com.sunopsis.sql.SnpsConnection.testConnection(SnpsConnection.java:1243)

      at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.getLocalConnect(SnpsDialogTestConnet.java:173)

      at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$400(SnpsDialogTestConnet.java:51)

      at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:629)

      at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:625)

      at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)

      at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:947)

      at java.lang.Thread.run(Thread.java:745)

      Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1

      ORA-01882: timezone region not found

       

      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)

      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)

      at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87)

      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:228)

      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

      at java.util.concurrent.FutureTask.run(FutureTask.java:262)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

      ... 1 more

      Caused by: 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:466)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:391)

      at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1126)

      at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:503)

      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)

      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)

      at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:436)

      at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1021)

      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:682)

      at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:789)

      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)

      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:608)

      at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:412)

      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)

      ... 6 more


      Best Regards