This applies to Oracle 10g XE that is used on the nodes.

After installing on the node you may get the following error when trying to login using sqlplus:

ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
Linux Error: 13: Permission denied

This is caused by Oracle installer not setting setuid on $ORACLE_HOME/bin/oracle.

To fix this:

  1. cd $ORACLE_HOME/bin
  2. su to root
  3. chmod 6751 oracle

After changing the permissions the oracle permissions should look like this:

-rwsr-s--x 1 oraclexe dba 71709876 2005-10-25 01:02 oracle 

ORA-27121 (last edited 2010-02-17 19:07:08 by Eric)