0 Replies Latest reply: Feb 11, 2011 3:37 AM by user8934440 RSS

    ORA-27101: shared memory realm does not exist-- forcing database down

    user8934440
      Hi Firends,

      I am facing below mentioned error:

      SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
      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

      Oracle_home, oracle_sid, tnsnames.ora,listerner.ora...all have same sid and oracle home..so no issues

      It is not like my database is completely down.it is working fine but...it goes down by throughing above exception in between and again we have to login as sysdba and bring the database up.

      Request you provide some suggestion on this.

      Thanks a lot in advance.

      My database details:
      x86_64 x86_64 x86_64 GNU/Linux -64 bit
      Oracle 11.2.0 version

      Edited by: user8934440 on Feb 11, 2011 1:33 AM

      Edited by: user8934440 on Feb 11, 2011 1:36 AM