Need help finding Oracle home path corresponding to a database instance in RAC environment. I am aware of few of the ways to achieve the same. Listing them below to avoid the same answers.
/etc/oratabThis file is not mandatory and hence may not have all instance information.
Parsing contents of Listener.ora In RAC environment, the listener.ora can be located at non default location.
use TNS_ADMIN to find Listener.ora location and parse the file.
ORACLE_HOME env variable May not be set always.
ps -ef | grep tnsto get the home path from service name. Gives path for currently running listener
where "SYSMAN"."MGMT$TARGET_COMPONENTS"."TARGET_NAME" = <Database SID>
The schema sysman can be dropped after first time login to oracle.
SELECT NVL(SUBSTR(FILE_SPEC, 1, INSTR(FILE_SPEC, '\', -1, 2) -1) , SUBSTR(FILE_SPEC, 1, INSTR(FILE_SPEC, '/', -1, 2) -1)) FOLDER
WHERE LIBRARY_NAME = 'DBMS_SUMADV_LIB';
So if a DBA changes Oracle Home (and hence the location of libqsmashr.so) after installation of Oracle, the path retrieved from above query would be invalid.
. oraenvWorks only for 11g
I am trying to find out a generic way which will work for all Oracle versions and it should not be dependent on anything which is not useful to DBA.
Do you have any way other than listed above to do the same?
Many Thanks in advance.