From: oratune@msn.com (David Fitzjarrell)
Newsgroups: comp.databases.oracle.server
Subject: Re: how does oracle know where its configuration is?
Date: 8 Aug 2001 08:03:04 -0700
Organization: http://groups.google.com/
Lines: 28
Message-ID: <32d39fb1.0108080703.29d9b642@posting.google.com>
References: <894b11eb.0108071236.206ee277@posting.google.com> <997220264.23781.0.pluto.d4ee154e@news.demon.nl> <1e8276d6.0108072245.746ec35b@posting.google.com>
NNTP-Posting-Host: 64.19.63.135
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 997282985 25839 127.0.0.1 (8 Aug 2001 15:03:05 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2001 15:03:05 GMT


Sybrand did NOT mistype anything.  The control files, where Oracle
stores all of the database configuration information, ARE listed in
the init file specified.  The question asked was:
 
'When the database engine starts up, where does it look
for its configuration that tells it where and how the database
is laid out? I'm planning to use Oracle on a Solaris box if that
matters.'

This information IS found in the control file, NOT the init file.

David Fitzjarrell
Senior Database Administrator

pagesflames@usa.net (Dusan Bolek) wrote in message news:<1e8276d6.0108072245.746ec35b@posting.google.com>...
> "Sybrand Bakker" <postbus@sybrandb.demon.nl> wrote in message news:<997220264.23781.0.pluto.d4ee154e@news.demon.nl>...
> 
> > In the controlfile located in $ORACLE_HOME/dbs/init$ORACLE_SID.ora
> > 
> > ORACLE_HOME/ORACLE_SID combos are defined in /var/opt/oracle/oratab
> > 
> > Hth,
> > 
> > Sybrand Bakker, Senior Oracle DBA
> 
> It's not a control file, but init file. Control file is something
> completely different. I know that it was just mistype, but some newbie
> can get confused.