Variant on ORA-27101 error
oracleaccount can login through SQL*Plus without a hitch. However, when we attempt to connect through the OPS$ accounts, via
sudo, we get the following error:
ERROR:The first thought which occurs is the ORACLE_SID is wrong but it is not. Although the answer does lie in the
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
.profileas it is the ORACLE_HOME which is wrong. The
oracleaccount has an ORACLE_HOME of
/u01/app/oracle/products/9.2.0and the other accounts have
/u01/app/oracle/product/9.2.0. Subtle, eh?
I think the difference occurred because Oracle was originally installed on this server at an earlier version and then subsequently upgraded, whereas the
.profilefiles were copied from a server which had had a greenfield installation of Oracle 9iR2. The default path suggested by DBCA is definitely
app/oracle/product/n.n.nand has been for quite a while. I don't know where the
/products/variant originated; judging by the relative number of Google hits,
/product/is the industry standard. Perhaps it didn't always used to be.