Re: How to find out concrete ORACLE

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 14 Aug 2006 08:47:16 -0700
Message-ID: <1155570437.781915@bubbleator.drizzle.com>

Mladen Gogala wrote:
> On Mon, 14 Aug 2006 00:18:54 +0000, Bob Jones wrote:
>

>> Actually it is quite common for the spfile to be placed outside of 
>> $ORACLE_HOME directory, such as /u01/admin.

>
> You and me definitely have the different understanding of DBA job. I don't
> see any reason to change this parameter, unless I have a need for
> maintaining a RAC system with shared spfile. What would be a reason for
> such a change? Why would I want to move that file elsewhere? To confuse
> the enemy or to make life harder for the possible new DBA? What is there
> to be gained by moving it to non-standard place? As an old school DBA, I'm
> always trying to abide by the old "don't fix it if it ain't broken"
> wisdom. It doesn't make me look fancy and wise, but it does usually make
> my environments stable.

I don't think this is about different people having different ideas of their job. It is just a fact of life that there are a lot of installs where internal rules, or bad DBAs, or outside vendors, move stuff all over the place.

If someone wants to find the home directories I posted the answer. For those that didn't see it the method is documented in Morgan's Library (www.psoug.org) under Environment Variables. The first heading, Product Homes has the solution and it can not be fooled by someone using a non-standard install.

It should be noted that if the server contains multiple Oracle home directories ... this catches them all: Though I don't know how.

SQL> set linesize 131
SQL> set pagesize 20
SQL> col host_name format a30
SQL> col home_name format a20
SQL> col home_location format a50
SQL>  SELECT *

2 FROM sysman.mgmt$software_homes;

HOST_NAME HOME_NAME HOME_TYPE HOME_LOCATION

-------------- -------------------- ----------- -------------------------
192.168.1.100  OraDb10g_home1       ORACLE_HOME C:\oracle\product\ora102
192.168.1.100  OraComp              ORACLE_HOME C:\oracle\product\oraHTTP
192.168.1.100  XMLPubHome           ORACLE_HOME C:\oracle\product\xmlpub
192.168.1.100  Independent Products INDEPENDENT N/A
192.168.1.100  OraDev               ORACLE_HOME c:\oracle\product\oradev

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Mon Aug 14 2006 - 10:47:16 CDT

Re: How to find out concrete ORACLE_HOME via SQL?