Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle base

Re: Oracle base

From: Holger Baer <>
Date: Wed, 22 Dec 2004 09:22:38 +0100
Message-ID: <cqbasg$f8c$1@news.BelWue.DE>

Ed Stevens wrote:

> On Tue, 21 Dec 2004 11:02:10 -0900, "David E. Grove"
> <> wrote:

>>>And now *I'm* confused! OK,I'll admit I've not yet seen 10g. If you
>>>just shake it out of the box and do an installation with all defaults,
>>>the installer asks for a a name and full path to Oracle Home. What do
>>>you specify at that point? Does the installation create this db_1
>>Yes, it does.
>>I specified ORACLE_BASE as "/opt/oracle". When I ran OUI, the default name
>>for Oracle home was something I don't quite remember. It was maybe 8
>>characters and was Ora-something. I used "DOC" (Dept. of Corrections) for
>>name of home. The default for path to home was automatically supplied as
>>"/opt/oracle/product/10.1.0/db_1". (Note the "db_1"). I changed that to
>>"/opt/oracle/product/10.1.0/DOC" because that "db_1" didn't make any sense,
>>and there was no real explanation that I could find in the installation
>>docs. Since there is a possibility that another government agency may soon
>>be sharing this Sun box with their own Oracle install, I figured it would be
>>prudent to have an additional level below "10.1.0". For us, "DOC" is more
>>meaningful than "db_1". I hope it doesn't bite me, later.
>>>If so, where is it and what's in it? Where do you find
>>>the such directories as bin, dbs, network, rdbms, and sqlplus ?
>>Presuming that, had I not modified the home path, that ".../db_1" would
>>contain the same things that are currently present in ".../DOC", this is
>>what's in it:
>>$ pwd
>>$ ls
>>DOC-SOB-MAIN_NOTIS install nls
>>OPatch install.platform oc4j slax
>>assistants inventory olap sqlj
>>bin javavm opmn sqlplus
>>cdata jdbc oraInst.loc srvm
>>cfgtoollogs jdk oracore sysman
>>config jlib ord tg4ifmx
>>css jre oui tg4ingr
>>ctx ldap owm tg4sybs
>>dbs lib perl tg4tera
>>demo lib32 plsql uix
>>diagnostics md precomp ultrasearch
>>dm mesg racg wwg
>>has mgw rdbms xdk
>>hs network relnotes
> Wowsers!  That really is your ORACLE_HOME!  To quote one of my
> favorite curmudgeons, 'Well, I don't like it!"  I see no rational at
> all for putting the Oracle binaries and other product files into a
> directory whose name seems to indicate that it is for a specific
> database ....

I dare a wild shot in the dark: The idea behind the db_1 might be that you could also have an oid_1, apps_1 etc. meaning that it's the first Oracle_home that's for the database *software*, subsequent installations probably should get db_2, db_3 (although such things as test, QA and prod would be more self explanatory I guess).

So with this, you might get a consistent directory tree for all Oracle software you happen to install to one machine. Who in their right mind would actually do this is beyond my imagination but then my imagination doesn't go that far ;-)

> Lacking that rational (and remember - also lacking any hands-on with
> 10g) I'd blow that away and re-install with ORACLE_HOME  set at
> /opt/oracle/product/10.1.0
> YMMV, and others may -- WILL -- disagree with me.

Happy to rush in ;-)
I'm very cautious in discarding anything OUI suggests. I attended OUs 'Managing Oracle on Linux' course, where the instructor for reasons I never understood tried to put ORACLE_BASE and ORACLE_HOME into the same directory. Not that OUI complained, but IIRC at the stage where you can relocate the jre installation it would not give any sensible path. It was possible to get around this, too, but I had the nagging feeling that I wouldn't be too comfortable with such an installation.

> 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.

Holger Received on Wed Dec 22 2004 - 02:22:38 CST

Original text of this message