Wednesday, May 14, 2008

ORA-27123 unable to attach to shared memory segment

Error Description:

Whenever you try to start your database instance it failed with error as follows.

SQL> startup
ORA-27123: unable to attach to shared memory segment
Solaris-AMD64 Error: 13: Permission denied

Cause of the Problem:

As the error suggested permission denied so there is problem in proper permission settings. In the $ORACLE_HOME and in $ORACLE_HOME/bin proper permission is not set and hence error comes.

Solution of The Problem:

You need to change the "umask" to the required 022, set the proper permission on $ORACLE_HOME, $ORACLE_HOME/bin directories. In my computer, I ran the following.

1)Log on as root and change permission.
bash-3.00$ su
# umask 022
# chmod 755 *
# chmod 755 *
# cd $ORACLE_HOME/bin
# chmod 6751 oracle
# exit

2)Log on normal user and log on to database.
bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release - Production on Wed May 14 23:40:12 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release - Production
With the Partitioning, OLAP and Data Mining options

1 comment:

Anonymous said...

Solved my problems!