This discussion is archived
11 Replies Latest reply: Oct 11, 2012 3:49 AM by yoonas RSS

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

DipakKalamkar Newbie
Currently Being Moderated
Hi..

we are having a test server in bank environment.

Details:

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 10.2.0.3.0 - 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.

ERROR:
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..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points