Re: Oracle base

David E. Grove wrote:
> >
> > I see nothing random about this:
> >
> > /<mount point>/<maybe_something>/oracle <== ORACLE_BASE
> >
> > then
> >
> > $ORACLE_BASE/product/<8.1.7> <==ORACLE_HOME
> > $ORACLE_BASE/product/<9.2.1> <==ORACLE_HOME
> > $ORACLE_BASE/product/<10.?.?> <==ORACLE_HOME
> >
> > $ORACLE_BASE/admin/<db-1>
> > $ORACLE_BASE/admin/<db-1>/scripts
> > $ORACLE_BASE/admin/<db-1>/bdump
> > $ORACLE_BASE/admin/<db-1>/pfile
> > etc.
> > $ORACLE_BASE/admin/<db-2>
> > $ORACLE_BASE/admin/<db-2>/scripts
> > $ORACLE_BASE/admin/<db-2>/bdump
> > $ORACLE_BASE/admin/<db-2>/pfile
> > etc.
> > $ORACLE_BASE/rda <== RDA files
> > etc.
> >
>
>
> From my newby point of view that looks great, but what the OUI and
> Installation Documentation proposes is:
>
> $ORACLE_BASE/product/10.1.0/db_1 <==ORACLE_HOME
>
> Here's another interesting thing-- in the Installation docs, the
"db_1" is
> NOT in italics (like "oracle_base" is). According to the typographic
> convention, that would seem to indicate that it is not a placeholder,
but a
> literal value.
>
> Still a little confused,

I used to be not confused about it, but have become confused again :-) Ed certainly understands it better than I do just now.

What I can advise is to pick a layout you do understand, and stick with it. Over time, you will come to see if you have missed something for your particular situation. In particular, backups seem to be very site-dependent (10g recovery-area stuff notwithstanding).

There was a time I was doing support for a vendor, and would see up to a dozen different customer sites a day. That's when you appreciate OFA! There was a time I was working for a large site with many databases - definitely appreciated OFA then - especially when going back and forth between non-OFA NT db's and OFA unix db's.

But even for single sites over a long period, having experience with OFA is good, because eventually you will go on a job interview elsewhere and someone is bound to ask you where something is, and look at you cross-eyed when you say something unexpected. Also easier for outsiders to help.

jg

--
@home.com is bogus.
10069, 00000, "Trusted Oracle test event"
// *Cause:
// *Action: Should never be enabled by customers.  Used to prevent
diffs in
//          regression testing by making Trusted behave like Oracle in
//          specific events.
//          level > 1  - handle 254 column tables without error
//          level = 20 - implicitly include ROWLABEL in views