Oracle DBA Tips and Techniques

By Arjun Raja

ORA-27123 and Operating System permissions

Posted by Arjun Raja on July 7, 2009

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

Login as another operating system user – test.

Oracle software owner is oracle.

test@xxxxxxx password:
test@test(xxxxx/u03/users/app/test) % 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….

test@test(xxxxxx/u03/users/app/test) %
test@test(xxxxxx/u03/users/app/test) % 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>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: