Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

DipakKalamkarOct 11 2012 — edited Oct 11 2012
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..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 8 2012
Added on Oct 11 2012
11 comments
5,442 views