Re: Instance parameter file location

Detlev Goebel wrote:
>
> Ludo Joris wrote:
> >
> > When an instance starts up,
> > it reads it's parameter file initSID.ora.
> > But I've got one in $ORACLE_BASE/admin/$ORACLE_SID/pfile
> > and one in $ORACLE_HOME/dbs.
> > Where an instance looks for it's parameter file should be in
> > the operating system specific Oracle manual.
> > I can't find it.
> >
> > I'm using Oracle7 7.3.2.2 on HP-UX 10.20.
> >
> > --
> > Ludo Joris
> > RUCA - University of Antwerp, Belgium
> > lujo_at_ruca.ua.ac.be
>
> Hi,
>
> Oracle looks in the $ORACLE_BASE/admin/$ORACLE_SID/pfile directory.
> In the $ORACLE_HOME/dbs directory resides the default configuration init
> file.
>
> Information on that I can read in the Oracle 7 Server for UNIX
> Administrator's Reference Guide Chapter 1.
> But this is an older release (7.1).

7.3.2 reads from $ORACLE_HOME/dbs directory and you can create a soft link to $ORACLE_BASE/admin/$ORACLE_SID/pfile such as ln -s $ORACLE_BASE/admin/$ORACLE_SID/pfile/init<sid>.ora $ORACLE_HOME/dbs/init<sid>.ora

Joseph Lee
The Ohio State University
lee.98_at_osu.edu Received on Wed Jun 18 1997 - 00:00:00 CDT