2 Replies Latest reply: Aug 28, 2013 5:08 AM by Pradeepcmst Branched from an earlier discussion. RSS

    Re: ORA-01034 , ORA-27101 in windows Domain

    3faef7bd-63bb-4a4e-8c20-99cd22adcb86

      Hi to everyone, I have a problem with the Oracle 11g express edition.

      please help me...



      $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

      SQL> conn

      Enter user-name: system

      Enter password:

      ERROR:

      ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      Process ID: 0

      Session ID: 0 Serial number: 0

      SQL>



      $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

      listener.ora:

      #listener.ora Network Configuration File: F:\app\sialk\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 = F:\app\sialk\product\11.2.0\dbhome_1)

            (PROGRAM = extproc)

            (ENVS = "EXTPROC_DLLS=ONLY:F:\app\sialk\product\11.2.0\dbhome_1\bin\oraclr11.dll")

          )

        )

       

       

      LISTENER =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

            (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.mydomain.com)(PORT = 1521))

          )

        )

       

       

       

       

      SID_LIST_LISTENER=

        (SID_LIST=

          (SID_DESC=

           (SID_NAME=acmepos)

           (ORACLE_HOME=F:\app\sialk\product\11.2.0\dbhome_1)

           (PROGRAM=dg4odbc)

          )

        )

       

      $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

      tnsname.ora:

      # tnsnames.ora Network Configuration File: F:\app\sialk\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)

          )

        )

       

       

      ORCL =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.mydomain.com)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = orcl)

          )

        )

       

       

       

       

       

      ACMEPOS=

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = tcp)(HOST = 127.0.0.1)(PORT = 1521))

          (CONNECT_DATA =(SID=acmepos))

          (HS=OK)

      )