Re: How to find out concrete ORACLE_HOME via SQL?

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Mon, 14 Aug 2006 21:58:03 GMT
Message-ID: <J40D0z.EDD@igsrsparc2.er.usgs.gov>

Mladen Gogala wrote:
> On Mon, 14 Aug 2006 18:27:47 +0000, Brian Peasland wrote:
>

>> $ORACLE_BASE/admin/$ORACLE_SID/pfile? Because 1) it centralizes all of 
>> your administrative files, 2) backups of all administrative files is as 
>> easy as backing up $ORACLE_BASE/admin, and 3) because it is a published 
>> standard.

>
> As well as a symbolic link from $ORACLE_BASE/admin/$ORACLE_SID/pfile to
> $ORACLE_HOME/dbs. Unfortunately, instance looks for parameters in
> $ORACLE_HOME/dbs. I am not opposed to symbolic links, but there should
> also be a practical side of things: instance looks in $ORACLE_HOME/dbs.
> No need to change it. In that case, the parameter will still be pointed to
> the right place and you can have your parameter files under the same roof
> as the trace files and core files, so that one erroneous "find" command
> can wipe all of that out.
>

I agree with the symbolic link idea. In fact, we implement such a standard in our site, but the links go the other way! :)

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 - 16:58:03 CDT