DA Morgan wrote:
> 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
well you'd have to have the sysman schema installed (dbconsole or grid
control agent?) but I like the view.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info/services/
Received on Mon Aug 14 2006 - 14:29:40 CDT
