2 Replies Latest reply: Nov 14, 2013 11:26 AM by clcarter RSS

    Database Configuration failed. ORA-27101: shared memory realm does not exist

    52479ca5-13a2-4e01-a158-16a50e6baa39

      Hi,

       

      I am trying to install Oracle 11g XE on a Amazon VM (X-Large CentOS 6.3) instance.

      When I come to /etc/init.d/oracle-xe configure I get the message ' Database Configuration failed'

       

      Looking in log files (cloneDBCreation.log) I see

       

      ORA-01034: ORACLE not available

      ORA-27101: shared memory realm does not exist

      Linux-x86_64 Error: 2: No such file or directory

      LRM-00116: syntax error at 'sessions' following '='

      ORA-01078: failure in processing system parameters

      Create controlfile reuse set database "XE"

       

      I have enough tmpfs (At least I think)

      #df -k

      Filesystem           1K-blocks      Used Available Use% Mounted on

      /dev/xvde             30963708   4939996  26023712  16% /

      tmpfs                  7685872         0   7685872   0% /dev/shm

       

      # cat /etc/hosts

      127.0.0.1        localhost.localdomain localhost

      ::1             localhost6.localdomain6 localhost6

       

      I am not so sure that my host settings are correct because my VM has an elastic IP setup. The eth0 is actually set on DHCP. IP shown in ifconfig is different than the elastic IP (I use to ssh from my laptop).

      #/sbin/sysctl -p    gives me following errors

      error: "net.bridge.bridge-nf-call-ip6tables" is an unknown key

      error: "net.bridge.bridge-nf-call-iptables" is an unknown key

      error: "net.bridge.bridge-nf-call-arptables" is an unknown key

       

      I have following swap

      Swap:  2097144k total,        0k used,  2097144k free,   100004k cached

       

      Please suggest how can I proceed ahead.

       

      Thanks in advance

      PSetty

        • 1. Re: Database Configuration failed. ORA-27101: shared memory realm does not exist
          52479ca5-13a2-4e01-a158-16a50e6baa39

          Hi

           

          I could move a bit ahead, but stuck again.

           

          For the first time when I tried to install oracle, my VM had no swap allotted. May be because of that or some other reason, 'memory_target' in init.ora was not instantiated .

          I added 1GB for memory_target in init.ora, and it passed one step ahead.

           

          Now when I configure it fails with,

          ********************************************

          ERROR at line 1:

          ORA-01034: ORACLE not available

          Process ID: 0

          Session ID: 0 Serial number: 0

           

           

           

           

           

           

          File created.

           

           

          ORA-01034: ORACLE not available

          ORA-27101: shared memory realm does not exist

          Linux-x86_64 Error: 2: No such file or directory

          ORACLE instance started.

           

           

          Total System Global Area 1068937216 bytes

          Fixed Size                  2233344 bytes

          Variable Size             616565760 bytes

          Database Buffers          444596224 bytes

          Redo Buffers                5541888 bytes

          Database mounted.

          ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

           

           

           

           

           

           

          'UTL_RECOMP_BEGIN:'||TO_CHAR(SYSDATE,'HH:MI:SS')

          ------------------------------------------------------------------------------

          utl_recomp_begin: 10:06:31

           

           

          BEGIN utl_recomp.recomp_serial(); END;

           

           

                *

          ERROR at line 1:

          ORA-06550: line 1, column 7:

          PLS-00201: identifier 'UTL_RECOMP.RECOMP_SERIAL' must be declared

          ORA-06550: line 1, column 7:

          PL/SQL: Statement ignored

           

           

           

           

           

           

          'UTL_RECOMP_END:'||TO_CHAR(SYSDATE,'HH:MI:SS')

          ------------------------------------------------------------------------

          utl_recomp_end: 10:06:31

           

          *******************************************************

           

          I could see the oracle process in 'top' but after restart of the machine I cannot see anything.

           

          I get the same error when I try to connect using sqlplus to restart the databse with resetlog option

          Enter user-name: sys as sysdba

          Enter password:

          ERROR:

          ORA-01031: insufficient privileges

           

          Enter user-name: sys

          Enter password:

          ERROR:

          ORA-01034: ORACLE not available

          ORA-27101: shared memory realm does not exist

          Linux-x86_64 Error: 2: No such file or directory

          Process ID: 0

          Session ID: 0 Serial number: 0

           

          Any ideas?

           

          PSetty

          • 2. Re: Database Configuration failed. ORA-27101: shared memory realm does not exist
            clcarter

            >> ORA-01034: ORACLE not available

             

            Database is not running. Looks like the db creation may have gotten whacked out on the open/resetlogs, might be worth a try an open resetlogs as the oracle user.

             

            Set a password for the oracle user, as root (or use sudo if that has been set up) `passwd oracle`, switch (`su - oracle`) to the oracle user, and source the environment setup script. Or do the manual way, export ORACLE_HOME=/u...;export PATH=$ORACLE_HOME/bin;export ORACLE_SID=XE and:

             

            sqlplus /nolog

            conn /as sysdba;

            ... connected to idle instance ...

            startup mount;

            alter database open resetlogs;