7 Replies Latest reply: Dec 1, 2012 3:24 PM by orafad RSS

    Oracle 11gR2 Express Edition ERROR: ORA-01034, ORA-27101

    977425
      Hi everyone,
      I recently formatted my system and reinstalled windows 7.

      Now I have Qracle 11g R2 Express Edition installed with SQL Developer.
      For some time everything worked fine den suddenly it stopped working.

      When i try to connect using command line interface i get error:
      ERROR:
      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Process ID: 0
      Session ID: 0 Serial number: 0

      when i try connecting via sqldeveloper:
      Listener refused the connection with the following error:
      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

      Also, If i go to services and restart OracleServiceXE i can connect for for 10-15 secs. but after dat same thing happens. Cant connect again. :(

      Now I have visited lots of google links but this error is just not going away. I have my project submittion on tuesday. and i reallyy need someones help in getting my oracle up and running.

      Thanks a lott in advance ppl.. :)
        • 1. Re: Oracle 11gR2 Express Edition ERROR: ORA-01034, ORA-27101
          977425
          I am posting my files here ...

          sqlnet.ora ->

          # This file is actually generated by netca. But if customers choose to
          # install "Software Only", this file wont exist and without the native
          # authentication, they will not be able to connect to the database on NT.

          SQLNET.AUTHENTICATION_SERVICES = (NTS)


          listener.ora ->

          SID_LIST_LISTENER =
          (SID_LIST =
          (SID_DESC =
          (SID_NAME = PLSExtProc)
          (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
          (PROGRAM = extproc)
          )
          (SID_DESC =
          (SID_NAME = CLRExtProc)
          (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
          (PROGRAM = extproc)
          )
          )

          LISTENER =
          (DESCRIPTION_LIST =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
          (ADDRESS = (PROTOCOL = TCP)(HOST = Cygnus-PC)(PORT = 1521))
          )
          )

          DEFAULT_SERVICE_LISTENER = (XE)


          tnsnames.ora ->

          XE =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = Cygnus-PC)(PORT = 1521))
          (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = XE)
          )
          )

          EXTPROC_CONNECTION_DATA =
          (DESCRIPTION =
          (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
          )
          (CONNECT_DATA =
          (SID = PLSExtProc)
          (PRESENTATION = RO)
          )
          )

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










          My Environment variables that i manually set ->
          ORACLE_HOME -> C:\oraclexe\app\oracle\product\11.2.0\server\
          checked the path.. its correct ...(\server has to be there ryt??)
          ORACLE_SID -> XE

          Edited by: 974422 on Dec 1, 2012 12:57 PM
          • 2. Re: Oracle 11gR2 Express Edition ERROR: ORA-01034, ORA-27101
            sb92075
            OS Services for both listener & DB must be started & running before Oracle DB can be started.
            Oracle is the victim; not the culprit.
            Root cause & fix must be done at OS level.
            • 3. Re: Oracle 11gR2 Express Edition ERROR: ORA-01034, ORA-27101
              977425
              Hi, Thanks for a quick reply there.

              Can you tell me how do i start both?
              • 4. Re: Oracle 11gR2 Express Edition ERROR: ORA-01034, ORA-27101
                Srini Chavali-Oracle
                Pl confirm you are using a certified edition of 32-bit Win 7 - http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#BABHICJH

                Home version or 64-bit Windows are not certified, so things may or may not work as advertised.

                HTH
                Srini
                • 5. Re: Oracle 11gR2 Express Edition ERROR: ORA-01034, ORA-27101
                  977425
                  Hi Srini

                  No i am not using 32 bit.
                  I have Windows 7 64 bit edition.

                  Does dat mean i cant run oracle 11g xe on my system??
                  • 6. Re: Oracle 11gR2 Express Edition ERROR: ORA-01034, ORA-27101
                    Srini Chavali-Oracle
                    Correct - 64-bit edition of 11g XE for Windows has been pending for a while - Re: XE 11.2 Windows 64

                    HTH
                    Srini
                    • 7. Re: Oracle 11gR2 Express Edition ERROR: ORA-01034, ORA-27101
                      orafad
                      974422 wrote:
                      For some time everything worked fine den suddenly it stopped working.
                      What changed?

                      When i try to connect using command line interface i get error:
                      How?

                      Please post PATH setting.

                      C:\Users>sqlplus test/test
                      
                      SQL*Plus: Release 11.2.0.2.0 Production on L÷ Dec 1 22:17:40 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
                      
                      
                      Enter user-name: ^C
                      
                      C:\Users>sqlplus / as sysdba
                      
                      SQL*Plus: Release 11.2.0.2.0 Production on L÷ Dec 1 22:18:02 2012
                      
                      Copyright (c) 1982, 2010, Oracle.  All rights reserved.
                      
                      Connected to an idle instance.
                      
                      SQL> startup
                      ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
                      ORACLE instance started.
                      
                      Total System Global Area  523108352 bytes
                      Fixed Size                  1384672 bytes
                      Variable Size             356519712 bytes
                      Database Buffers          159383552 bytes
                      Redo Buffers                5820416 bytes
                      Database mounted.
                      Database opened.
                      SQL>
                      Also, If i go to services and restart OracleServiceXE i can connect for for 10-15 secs. but after dat same thing happens. Cant connect again. :(
                      Connect how? Via sqlplus or SQL Developer?

                      Status of the service after 10-15 secs?

                      What do you have in alert.log at (and around) this time?