6 Replies Latest reply: Aug 6, 2012 2:24 AM by Helios-GunesEROL RSS

    11g instance creation database connection testing error with ORA-01882

    953592
      I am installing 11g on RHEL 6.1 64bit. The Oracle software seems to install properly. When I start the the process to create the database instance it errors out. Here is the relevant portion of the database.creation.log file:

      -----

      Look at the log file "/home/oracle/OraHome11g/cfgtoollogs/dbca/arcsight/arcsight.log" for further details.

      Status: The instance arcsight has been created successfully and is now running.
      Progress: Setting up Oracle environment

      Status: Setting up Oracle environment for all users ...


      Status: Setting up the TNS Listener ...

      Info: The TNS Listener will only allow connections from localhost,10.67.61.108,10.67.61.110.

      Status: Starting the TNS listener for arcsight ...

      LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 02-AUG-2012 16:52:43

      Copyright (c) 1991, 2010, Oracle. All rights reserved.

      Starting /home/oracle/OraHome11g/bin/tnslsnr: please wait...

      TNSLSNR for Linux: Version 11.2.0.2.0 - Production
      System parameter file is /home/oracle/OraHome11g/network/admin/listener.ora
      Log messages written to /home/oracle/OraHome11g/log/diag/tnslsnr/STRMV3126/listener/alert/log.xml
      Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.67.61.108)(PORT=1521)))

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.67.61.108)(PORT=1521)))
      STATUS of the LISTENER

      Alias LISTENER
      Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
      Start Date 02-AUG-2012 16:52:45
      Uptime 0 days 0 hr. 0 min. 2 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /home/oracle/OraHome11g/network/admin/listener.ora
      Listener Log File /home/oracle/OraHome11g/log/diag/tnslsnr/STRMV3126/listener/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.67.61.108)(PORT=1521)))
      Services Summary...
      Service "arcsight" has 1 instance(s).
      Instance "arcsight", status UNKNOWN, has 1 handler(s) for this service...
      The command completed successfully

      Status: Oracle is ready for network connections.


      Status: Testing database connection ....


      Assuming ARCSIGHT_HOME: /home/oracle
      Assuming JAVA_HOME: /home/oracle/jre

      ArcSight Database Connection testing...

      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:439)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:388)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:381)
           at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:564)
           at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
           at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)
           at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)
           at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359)
           at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
           at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
           at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
           at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
           at java.sql.DriverManager.getConnection(DriverManager.java:582)
           at java.sql.DriverManager.getConnection(DriverManager.java:185)
           at com.arcsight.config.util.DBUtil.isDBReachable(DBUtil.java:166)
           at com.arcsight.install.util.TestDBConnection.go(TestDBConnection.java:121)
           at com.arcsight.install.util.TestDBConnection.main(TestDBConnection.java:63)
      [Thu Aug 02 16:52:47 UTC 2012] [INFO ] Database jdbc:oracle:thin:@10.67.61.108:1521:arcsight is not reachable!
      Error: Could not login to the database with system account!
      -----

      Any suggestions?

      Edited by: 950589 on Aug 2, 2012 1:01 PM
        • 1. Re: 11g instance creation database connection testing error with ORA-01882
          Srini Chavali-Oracle
          Pl identify the exact version of "11g" - only 11.2.0.3 is certified on Linux 6.x versions.

          http://docs.oracle.com/cd/E11882_01/relnotes.112/e23558/toc.htm#CHDFHIEA

          If you are using an earlier version (seems to be 11.2.0.2), pl use a supported OS version listed at http://docs.oracle.com/cd/E11882_01/install.112/e24321/pre_install.htm#CIHFICFD

          HTH
          Srini
          • 2. Re: 11g instance creation database connection testing error with ORA-01882
            sb92075
            950589 wrote:
            I am installing 11g on RHEL 6.1 64bit. The Oracle software seems to install properly. When I start the the process to create the database instance it errors out. Here is the relevant portion of the database.creation.log file:

            -----

            Look at the log file "/home/oracle/OraHome11g/cfgtoollogs/dbca/arcsight/arcsight.log" for further details.

            Status: The instance arcsight has been created successfully and is now running.
            Progress: Setting up Oracle environment

            Status: Setting up Oracle environment for all users ...


            Status: Setting up the TNS Listener ...

            Info: The TNS Listener will only allow connections from localhost,10.67.61.108,10.67.61.110.

            Status: Starting the TNS listener for arcsight ...

            LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 02-AUG-2012 16:52:43

            Copyright (c) 1991, 2010, Oracle. All rights reserved.

            Starting /home/oracle/OraHome11g/bin/tnslsnr: please wait...

            TNSLSNR for Linux: Version 11.2.0.2.0 - Production
            System parameter file is /home/oracle/OraHome11g/network/admin/listener.ora
            Log messages written to /home/oracle/OraHome11g/log/diag/tnslsnr/STRMV3126/listener/alert/log.xml
            Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.67.61.108)(PORT=1521)))

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.67.61.108)(PORT=1521)))
            STATUS of the LISTENER

            Alias LISTENER
            Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
            Start Date 02-AUG-2012 16:52:45
            Uptime 0 days 0 hr. 0 min. 2 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File /home/oracle/OraHome11g/network/admin/listener.ora
            Listener Log File /home/oracle/OraHome11g/log/diag/tnslsnr/STRMV3126/listener/alert/log.xml
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.67.61.108)(PORT=1521)))
            Services Summary...
            Service "arcsight" has 1 instance(s).
            Instance "arcsight", status UNKNOWN, has 1 handler(s) for this service...
            The command completed successfully

            Status: Oracle is ready for network connections.


            Status: Testing database connection ....


            Assuming ARCSIGHT_HOME: /home/oracle
            Assuming JAVA_HOME: /home/oracle/jre

            ArcSight Database Connection testing...

            java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
            ORA-01882: timezone region not found
            bcm@bcm-laptop:~$ oerr ora 1882
            01882, 00000, "timezone region not found"
            // *Cause: The specified region name was not found.
            // *Action: Contact Oracle Support Services.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
            • 3. Re: 11g instance creation database connection testing error with ORA-01882
              Helios-GunesEROL
              Hi;
              Alias LISTENER
              Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
              It seems you are using 11.2.0.2.0 which is not certified wiht Rhel6. Please see:
              NOTE:1441282.1 - Requirements for Installing Oracle 11gR2 RDBMS on RHEL6 or OL6 64-bit (x86-64)

              PS:Please dont forget to change thread status to answered if it possible when u belive your thread has been answered, it pretend to lose time of other forums user while they are searching open question which is not answered,thanks for understanding

              Regard
              Helios
              • 4. Re: 11g instance creation database connection testing error with ORA-01882
                953592
                I understand that RHEL 6.1 is supported starting with 11.2.0.3. But I did a successful installation last week on a different server using the same versions as this currently problematic server.

                Lets assume that I was using 11.2.0.3, what would be the answer to the above problem?

                Thanks
                • 5. Re: 11g instance creation database connection testing error with ORA-01882
                  Srini Chavali-Oracle
                  Open an SR with Support - issue is with timezone region not being found - see "sb"'s response above

                  HTH
                  Srini
                  • 6. Re: 11g instance creation database connection testing error with ORA-01882
                    Helios-GunesEROL
                    Hi;

                    You could may install 11.2.0.1. to RHEL6-OEL6 without issue, but it doesnt man You can get support from oracle. Because they will say you its not certified combination

                    Regard
                    Helios