Re: How do I find the init.ora file?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 18 Dec 2000 10:11:40 -0000
Message-ID: <91knss$kct$1@soap.pipex.net>

hmm I can't find this either. However if you have a setup as per the default 8i detup with an init.ora with nothing but an ifile entry in it, which is changed depending on configuration then you can issue show parameter ifile.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Cliff Dabrowski" <cliffdw_at_my-deja.com> wrote in message
news:n6X_5.151151$hD4.38295245_at_news1.rdc1.mi.home.com...


> Jan,

>

> I have searched and searched but did not find an answer to your question,

 at


> least not a documented way. I will keep looking when I have time but

 please


> keep me in mind and let me know if you find an answer.

>

> Cliff

>

> "Christian Wandrei" <Christian.Berlin_at_gmx.de> wrote in message

> news:3A3A579A.E60A1AA6_at_gmx.de...

> > Hi Al,

> >

> > thank you very much for your answer. But these are only the default

> > directories for the init.ora file. It is possible to start Oracle using

 an


> > init.ora file in a different directory. If there are two files - one in

 the


> > default directory and another one anywhere else - how do I find out

 which


> > one was actually used when the instance was started.

> >

> > Best regards Jan Dieckmann

> > (sorry for the incorrect email address. I use the pc of my friend

 Christian


> > Wandrei)

> >

> > alistair.thomson_at_sphinxcst.co.uk wrote:

> >

> > > It depends what version of oracle you're using and platform.

> > >

> > > On Oracle 7 / 8 it will be in

> > >

> > > NT: d:\orant\database

> > > UNIX: $ORACLE_HOME/dbs

> > >

> > > with 8i it will be in

> > >

> > > NT: oracle_home\admin\sid_name\pfile

> > > UNIX: $ORACLE_BASE/admin/sid_name/pfile

> > >

> > > Hope it helps

> > >

> > > Al

> > >

> >

>

>

Received on Mon Dec 18 2000 - 04:11:40 CST