Re: Oracle base

P.S. Thank you also for your tip about the OFA standard. I will check it out.

DG

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:sdd6s0l24om0kcn7s09oqp0kmdm3vql3pt_at_4ax.com...
> On Fri, 17 Dec 2004 08:26:41 -0900, "David E. Grove"
> <david_grove_at_correct.state.ak.us> wrote:
>
> >I have previously been DBA of Informix on Sun Solaris platform. I am now
> >familiarizing myself with Oracle.
> >
> >Consistency being the hobgoblin of small minds, I have an inclination to
> >make the Oracle base directory consistent with other stuff.
Specifically,
> >I'd like to make it "/opt/oracle".
> >
> >Will this bite me in the future?
> >
> >Thank you.
> >
> >DG
> >
> >
> >
> >- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> >"I think not," said Descartes, and disappeared.
> >
>
> I don't have any links handy, but if you'll poke around on the web you
> should be able to find a paper by Carey Milsap called 'The OFA
> Standard - Oracle for Open Systems'. It is almost ten years old now,
> but I believe it is still the definitive paper on defining your
> directory structure for Oracle. A somewhat more concise statement of
> the same principals is located in Appendix G of the "Oracle9i
> Adminstrator's Reference Release 2 (9.2.0.1.0) for Unix Systems."
> Available at tahiti.oracle.com.
>
> Our implementation looks like this:
>
> /u01/app/oracle < this is ORACLE_BASE
> /u01/app/oracle/product/9.2.0 <-- this is ORACLE_HOME
> /u01/app/oracle/admin
> /u01/app/oracle/admin/<sid name>
> /u01/app/oracle/admin/<sid name>/bdump
> /u01/app/oracle/admin/<sid name>/cdump
> /u01/app/oracle/admin/<sid name>/pfile
> /u01/app/oracle/admin/<sid name>/scripts
> /u01/app/oracle/admin/<sid name>/trace
> /u01/app/oracle/admin/<sid name>/udump
>
> While Oracle doesn't really care where you put things, as long as you
> tell it, I'm not enough of a Unix SA to know if there might be some
> admin gotchas by placing it in the /opt directory. Other than that,
> the structure still works:
>
> <whatever>/oracle < this is ORACLE_BASE
> <whatever>/oracle/product/9.2.0 <-- this is ORACLE_HOME
> <whatever>/oracle/admin
> <whatever>/oracle/admin/<sid name>
> <whatever>/oracle/admin/<sid name>/bdump
> <whatever>/oracle/admin/<sid name>/cdump
> <whatever>/oracle/admin/<sid name>/pfile
> <whatever>/oracle/admin/<sid name>/scripts
> <whatever>/oracle/admin/<sid name>/trace
> <whatever>/oracle/admin/<sid name>/udump
>
> Thanks.
>
> - Ed Stevens
>
> Cohn's Law: The more time you spend in reporting on what you are doing,
the less time you have to do anything. Stability is achieved when you spend all your time doing nothing but reporting on the nothing you are doing. Received on Fri Dec 17 2004 - 17:27:20 CST