Re: How to find out concrete ORACLE_HOME via SQL?

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Mon, 14 Aug 2006 16:22:07 GMT
Message-ID: <J3zxH4.Bu2@igsrsparc2.er.usgs.gov>

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.
>

Actually, Bob's location, $ORACLE_BASE/admin is OFA compliant. As such, I would not consider this a "change" but a "standard". See the following:

http://download-east.oracle.com/docs/cd/B19306_01/install.102/b15660/app_ofa.htm#BGBIBCAC

Go to section D.3.2.4 Naming Subdirectories. In that section, they talk about "To facilitate the organization of administrative data, Oracle recommends that you store database-specific administration files in subdirectories matching the pattern /h/admin/d/a/, where h is the Oracle base directory, d is the database name (DB_NAME), and a is a subdirectory for specific types of database administration files. Table D-4 describes the database administration file subdirectories."

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Mon Aug 14 2006 - 11:22:07 CDT