Re: how does oracle know where its configuration is?

From: David Fitzjarrell <oratune_at_msn.com>
Date: 8 Aug 2001 08:03:04 -0700
Message-ID: <32d39fb1.0108080703.29d9b642@posting.google.com>

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_at_usa.net (Dusan Bolek) wrote in message news:<1e8276d6.0108072245.746ec35b_at_posting.google.com>...
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<997220264.23781.0.pluto.d4ee154e_at_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.
Received on Wed Aug 08 2001 - 10:03:04 CDT