Re: spreading my wings -- looking for some recommdations/best practices

Ed Stevens <nospam_at_noway.nohow> wrote in message news:<3juhn0pe2021ut4kqm35abkdn82uqgmd4e_at_4ax.com>...

> Oh, absolutely that most scripts will survive version upgrades. But
> just to play devil's advocate, $ORACLE_BASE/admin also survives
> upgrades.
>
> $ORACLE_HOME = /u01/app/oracle/product/9.2.0
> $ORACLE_BASE = /u01/app/oracle
>
> and $ORACLE_BASE in turn contains
> ../admin
> ../admin/scripts (optional, for non-sid specific scripts)
> ../admin/logs (optional, for non-sid specific script logs)
> ../admin/MYSID
> ../admin/MYSID/bdump
> ../admin/MYSID/cdump
> ../admin/MYSID/create
> ../admin/MYSID/pfile
> ../admin/MYSID/udump
> ../admin/MYSID/ (optional, for sid specific scripts)
> ../admin/MYSID/ (optional, for sid specific script logs)
>
> When we upgrade to Oracle X.2, it will go into
> /u01/app/oracle/product/X.2.0, leaving everything in
> /u01/app/oracle/admin intact.
>
> That said, my preference leans toward keeping my scripts and logs in
> /local/home/oracle, thus
>
> /local/home/oracle/scripts (for non-sid specific scripts)
> /local/home/oracle/scripts/MYSID (for sid specific scripts)
> /local/home/oracle/logs (for non-sid specific script logs)
> /local/home/oracle/logs/MYSID (for sid specific script logs)
>
> I realize that either way is quite workable -- possibly equally so.
> But since I'm working in a bit of a vacuum, I thought I'd pick the
> brains of others before forging ahead and creating a structure that
> I'll look at in a couple of years and ask "what the h*** was I
> thinking?" I don't want to over-engineer something that is really
> rather simple, but at the same time I don't want to create something
> that will quickly collapse into an amorphous mess.

You are of course right about ORACLE_BASE, I'm once again asking myself "what the h*** was I thinking?" because a customer site insisted on "improving" on OFA. In some ways it's easier not in the vacuum because you don't have to think about it, but the worst of all worlds is going back and forth from one way to another. The upper level directories of OFA like /u04/oradata hark back to the olden days, of course.

The messiness comes with things you don't use every day. So make it as simple as you can and still stick with OFA. Yours is lookin' good.  Decide what you like and then think about where the backups will go.

jg

--
@home.com is bogus.
First we maim all the lawyers. 
http://www.signonsandiego.com/uniontrib/20041022/news_1n22gunmake.html