Oracle DBA Tips and Techniques

By Arjun Raja

Avoid ORA -27123 error

Posted by Arjun Raja on January 18, 2011

To avoid ORA -27123 error while accessing database while logged in as another user into the unix machine other than oracle software owner.

Ex – Login as gentest into a machine where the software is owned by oracle user.

gentest@xxxxxxxxxs password:
gentestxxxxxxxx % 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

So 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

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

Now as gentest user it works….

gentest@xxxxxxx) %
gentest@xxxxxxxx % 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: