Re: How to find out concrete ORACLE_HOME via SQL?

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.

-- 
http://www.mgogala.com