Re: How to find out concrete ORACLE_HOME via SQL?

Brian Peasland wrote:
> 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! :)

I've seen some places do it both ways and neither :-( The latter includes having disimilar copies in both places, perhaps because some people don't know what a link is.

I well remember someone thought I was stupid for not assuming $ORACLE_HOME/dbs on a system I had not seen - me having been on half-a-dozen different OFA systems that day.

I've also seen many places that leave old useless homes laying around, and all sorts of pseudo-OFA. There simply is no general way to know where a home is. Sometimes you can play games with OS utilities ( for example, /usr/sbin/fuser `find / -type f -name oracle`), but that only works if there happens to be a running instance under it...

Then there's database links...
And instances that don't have databases... And homes that are in the middle of being messed up testing quarterly CPU's...

The concrete is not very viscous.

jg

--
@home.com is bogus.
"One plus one actually equaled two-plus"
http://www.newsfactor.com/story.xhtml?story_id=0330012RUQGR