Re: Oracle user group

From: JMecc <jmecc_at_telus.net>
Date: 7 May 2007 15:34:03 -0700
Message-ID: <1178577243.009188.261340@n59g2000hsh.googlegroups.com>

OK it finally works. Apparently $ORACLE_HOME used to be visible to everyone but was changed to private in version 9.2.0.7 due to some wanting to keep all non-dba users from accessing the server side of the database (they can apparently still access it from the client side). The workaround is to set the permissions before running the root.sh script at the end of installation (I just re-ran it after chmod) and changing the permission on the oracle executable separately:

chmod -R 755 $ORACLE_HOME
$ORACLE_HOME/root.sh

The above is the solution from Bug 4516865, which allows sqlplus to start but refuses your login due to :
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment Linux Error: 13: Permission denied

so the permission on the oracle executable has to be changed (per http://www.lazydba.com/oracle/0__75539.html)

cd $ORACLE_HOME/bin
chmod 6751 oracle

Thanks very much for the replies!
Jonathan Received on Mon May 07 2007 - 17:34:03 CDT