11 Replies Latest reply: Oct 11, 2012 5:49 AM by yoonas RSS

    *ORA-27123: unable to attach to shared memory segment*


      we are having a test server in bank environment.


      IBM p series servers
      AIX 5.3
      Server memory : 16G
      there are 2 instances on this server.
      1. Near DR - 9840M
      2. Test server - 1344M
      Rest is for server.
      Oracle - Production

      2 days ago we are running a stored procedure on this test server. After some time DB gave this error and stored procedure stopped.

      After that we were unable to login through Oracle Client Software. Whenever we try to login to this DB through client software, it gives following errors.

      ORA-01034: ORACLE not available
      ORA-27123: unable to attach to shared memory segment
      IBM AIX RISC System /6000 Error: 13: Permission denied

      We tried to shut the DR database and then login but still gives error..

      Please help me out.
      Thanks in advance..