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

Hi Steve,

may be I should tell why I am asking this question. I have written a little utility which generates the backup procedures for an Oracle online backup. The utility reads all necessary information from the data dictionary of a running database and generates the procedures for NT, VMS or UNIX depending of the operating system under which the database is running. I like to make a backup not only of the control files, the data files ... but also of the init.ora file. Here comes the problem. The utility can not shut down the database. But it should be possible to get the information from the database itself at least the information where the default location of the init.ora file in the context of the operating system and the Oracle version is.

Best regards
Jan Dieckmann

steveee_ca_at_my-deja.com wrote:

> Hi,
>
> If you don't specify a parameter file to use when you start up, it'll
> use the default..if you want to look at some stats you can check
> v$instance,v$sga, or v$parameter to see what your settings are..or, if
> it's reasonable to do so, just shut down and restart but specify a
> parameter file name
>
> startup pfile = directory/directory/init.ora
>
> Hth,
>
> Steve
>
> In article <3A3A579A.E60A1AA6_at_gmx.de>,
> Christian Wandrei <Christian.Berlin_at_gmx.de> wrote:
> > 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
> > >
> >
> >
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Dec 18 2000 - 03:44:17 CST