oracle account 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
.profile as it is the ORACLE_HOME which is wrong. The oracle account has an ORACLE_HOME of /u01/app/oracle/products/9.2.0 and 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
.profile files 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.n and 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.
2 comments:
Given the fun and games you can have with column names and other naming standards within the data dictionary, little suprises me with Oracle changing "standard" names from time to time :-) Annoying isn't it?
hi Andrew,
have you any information how the (hash-)values for shared memory and semaphore is calculated from $ORACLE_HOME and $ORACLE_SID?
Post a Comment