News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

ORA-27123 and Operating System permissions

  • Posted by Arjun Raja
  • On July 7, 2009
  • 0 Comments

PERMISSION ON ORACLE FILES FOR OTHER USERS OTHER THAN SOFTWARE OWNERS TO ACCESS DATABASE.

Login as another operating system user – gentest.

Oracle software owner is oracle.

gentest@10.53.200.236’s password:
gentest@imisd(devu001/u03/users/app/gentest) % sqlplus /

SQL*Plus: Release 10.2.0.3.0 – Production on Wed Dec 3 11:11:17 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

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

To fix this issue –

Login as owner oracle

cd $ORACLE_HOME/bin

ls -l oracle

-rwxr-xr-x 1 oracle oinstall 131619948 May 31 2007 oracle

chmod ug+s oracle or chmod 6751 oracle

oracle@ bin> ls -l oracle
-rwsr-sr-x 1 oracle oinstall 131619948 May 31 2007 oracle
oracle@ bin>

Now as gentest user connection to database works….

gentest@imisd(devu001/u03/users/app/gentest) %
gentest@imisd(devu001/u03/users/app/gentest) % sqlplus /

SQL*Plus: Release 10.2.0.3.0 – Production on Wed Dec 3 11:19:14 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

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

SQL>

 

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *