4 Replies Latest reply: Nov 30, 2012 4:38 AM by OBYYS RSS

    Persistent ORA-01034: ORACLE not available

    OBYYS
      Hi,
      I'm using Oracle 11g database Version 11.2.0.1.0 and this problem im having seems not to get solved on my system...
      Im working directly with the computer Oracle is installed and i have tried all solutions i could find on the OTN forum for the ORA-01034 error, but none seemed to work for me please anyone have anymore ideas?
      EXPLANATION: first i had this ORA-12505, so i applied a solution from OTN forum by editing the listener.ora file and added one more SID_DESC and it seemed to solve the ORA-12505 error, after which i reboot my system and tried connecting, instead a new error appeared ORA-01034.
      This is what my listener.ora file looks lik after i edited it:

      # listener.ora Network Configuration File: C:\app\OBI\product\11.2.0\dbhome_1\network\admin\listener.ora
      # Generated by Oracle configuration tools.

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\app\OBI\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\OBI\product\11.2.0\dbhome_1\bin\oraclr11.dll")
      )
      (SID_DESC =
      (GLOBAL_DBNAME = obyys)
      (ORACLE_HOME = C:\app\OBI\product\11.2.0\dbhome_1)
      (SID_NAME = obyys)
      )
      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
           (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      )
      )

      ADR_BASE_LISTENER = C:\app\OBI

      This is my tnsnames.ora file:

      # tnsnames.ora Network Configuration File: C:\app\OBI\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
      # Generated by Oracle configuration tools.

      ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
      (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
      )
      )

      OBYYS =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = obyys)
      )
      )

      These are the solutions i tried out for the 0RA-01034 BUT NONE WORKED
      1) do you find in your sqlnet.ora an entry like SQLNET.AUTHENTICATION_SERVICES=(NTS)? If so, change it on trial to SQLNET.AUTHENTICATION_SERVICES=(NONE) .
      2) set oracle_sid = grms
      sqlplus /nolog
      conn system/manager as sysdba
      shutdown abort
      startup
      3) changing the service name to CAPS
      Please anyone have any other better ideas.. would appreciate. Thanks
        • 1. Re: Persistent ORA-01034: ORACLE not available
          Niket Kumar
          post results


          cmd>tnsping OBYYS

          cmd>lsnrctl status
          • 2. Re: Persistent ORA-01034: ORACLE not available
            OBYYS
            cmd>tnsping OBYYS

            Microsoft Windows [Version 6.0.6001]
            Copyright (c) 2006 Microsoft Corporation. All rights reserved.

            C:\Windows\system32>tnsping OBYYS

            TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 30-NOV-2
            012 09:52:01

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

            Used parameter files:
            C:\app\OBI\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


            Used TNSNAMES adapter to resolve the alias
            Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos
            t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = obyys)))
            OK (0 msec)


            cmd>lsnrctl status

            LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 30-NOV-2012 09:57
            :12

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

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
            ction
            Start Date 30-NOV-2012 06:52:32
            Uptime 0 days 3 hr. 4 min. 39 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File C:\app\OBI\product\11.2.0\dbhome_1\network\admin\liste
            ner.ora
            Listener Log File c:\app\obi\diag\tnslsnr\OBI-PC\listener\alert\log.xml
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=OBI-PC)(PORT=1521)))
            Services Summary...
            Service "CLRExtProc" has 1 instance(s).
            Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service...
            Service "obyys" has 1 instance(s).
            Instance "obyys", status UNKNOWN, has 1 handler(s) for this service...
            The command completed successfully
            • 3. Re: Persistent ORA-01034: ORACLE not available
              Niket Kumar
              connect like this

              cmd>sqlplus username/password@OBYYS

              it will work for you

              if you got error please post error with full text.

              move your question to below category:

              Oracle Discussion Forums » Oracle Database » General Questions
              • 4. Re: Persistent ORA-01034: ORACLE not available
                OBYYS
                It didnt work and this is the error i got..

                Microsoft Windows [Version 6.0.6001]
                Copyright (c) 2006 Microsoft Corporation. All rights reserved.

                C:\Windows\system32>sqlplus hr/hr@OBYYS

                SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 30 11:14:20 2012

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

                ERROR:
                ORA-01034: ORACLE not available
                ORA-27101: shared memory realm does not exist
                Process ID: 0
                Session ID: 0 Serial number: 0


                Meanwhile, i jus saw this in my windows Event Log Viewer

                Archive process error: ORA-16038: log 2 sequence# 182 cannot be archived
                ORA-19809: limit exceeded for recovery files
                ORA-00312: online log 2 thread 1: 'C:\APP\OBI\ORADATA\OBYYS\REDO02.LOG'
                .

                And i browse my oracle home and check the path C:/app/OBI/oradata/obyys the three REDO LOG groups read as follows:

                Name Size
                REDO01 51,201kb
                REDO02 51,201kb
                REDO03 51,201kb

                Is this somehow related to the problem im having with the ORA-01034?
                If so, any better solution and how can i clear the logs because i have tried the command ALTER DATABASE CLEAR LOGFILE GROUP 1; but since im not connected to ORACLE, the command fails.