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>
Arjun Raja
