5 Replies Latest reply: Sep 20, 2013 2:10 AM by 1041050 RSS

    ORA-01034: ORACLE not available while database is up

    1041050

      Hi,

       

      I am having one Oracle database with below configurations:

           Oracle 11.2.0.3 64bit, 2 node RAC, ASM 11.2.0.3, AIX 7.1

       

      one application module accessing this database reported an error with "ORA-01034: ORACLE not available" at 2013-09-16 11:55:03, yet both instances have been up since 2013-09-14 22:32. Other applications using this database is not impacted. The problematic module was later restarted successfully.

       

      Appreciate for any clue that may lead to this situation.

       

      Regards,

       

      LIU GaoYuan


        • 1. Re: ORA-01034: ORACLE not available while database is up
          DK2010

          Hi,

           

          Have you checked your alert log around that time, may you can get some hint there.

          • 2. Re: ORA-01034: ORACLE not available while database is up
            1041050

            Hi,

             

            Have checked on alert log and listener log, but no error/warning at that period.

            • 3. Re: ORA-01034: ORACLE not available while database is up
              DK2010

              Hi,

              >>Other applications using this database is not impacted. The problematic module was later restarted successfully.

              Then probably it is the application bug/error, something like  try to connect with wrong sid etc..

              • 4. Re: ORA-01034: ORACLE not available while database is up
                1041050

                Hi,

                 

                The application module has been running for years, and there is no change in the application/configuration.

                 

                We just notice that the monitoring tool from a different server had the same issue at that period as well. The monitoring showed that instance 1 was not reachable at 11:49, while instance 2 was not reachable at 11:54.

                 

                Both the application module and the monitoring tool are using JDBC.

                 

                Further check on RDBMS listener log, and below are the interesting entries:

                 

                ===================================================================================================================
                Node 1
                ===================================================================================================================

                <msg time='2013-09-16T11:48:49.706+08:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='xxx'
                host_addr='xxx'>
                <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
                </txt>
                </msg>

                # sequence of similar error
                <msg time='2013-09-16T11:49:19.088+08:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='xxx'
                host_addr='xxx'>
                <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
                </txt>
                </msg>

                 

                 

                ===================================================================================================================
                Node 2
                ===================================================================================================================

                <msg time='2013-09-16T11:54:53.532+08:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='xxx'
                host_addr='xxx'>
                <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
                </txt>
                </msg>

                # sequence of similar error

                <msg time='2013-09-16T11:55:28.178+08:00' org_id='oracle' comp_id='tnslsnr'
                type='UNKNOWN' level='16' host_id='xxx'
                host_addr='xxx'>
                <txt>TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
                </txt>
                </msg>

                 

                The RAC has been configured with remote listener and local listener.

                 

                So suspecting Oracle may fail to establish the connection for some unknown reason?

                • 5. Re: ORA-01034: ORACLE not available while database is up
                  1041050

                  Hi,

                   

                  The issue was likely caused by listener reload. The instancces seemed not able to response to new connection request for about 30 seconds when listener was being reloaded.

                   

                  SR was logged with Oracle support, but no conclusion yet.

                   

                  Regards,