Re: Help! How to find pfile

That's a file included in the parameter file with the line ifile =

Hth,

Sybrand Bakker, Oracle DBA

<oberco_at_my-deja.com> wrote in message news:8alios$p2u$1_at_nnrp1.deja.com...
> Hello Jonathan,
> you are right for all but how do you explain it :
>
> SQL*Plus: Release 3.3.4.0.0 - Production on Tue Mar 14 15:36:22 2000
>
> Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
>
> Connecté à:
> Oracle7 Server Release 7.3.4.4.0 - Production
> With the distributed, replication and parallel query options
> PL/SQL Release 2.3.4.4.0 - Production
>
> SQL> col name for a20
> SQL> col value for a50
> SQL> select name,value from v$parameter where name='ifile';
>
> NAME VALUE
> -------------------- --------------------------------------------------
> ifile /usr/local/oracle/share/conf/init.ora
>
> SQL>
>
> Olivier
>
> In article <38d39fdf.18883983_at_netnews.worldnet.att.net>,
> jonathan_at_gennick.com wrote:
> > I'm fairly certain that the parameter file location is not
> > recorded in the database. The pfile is actually read by the
> > program used to start the database (Server Manager, Instance
> > Manager, SQL*Plus, etc). The parameters are passed to the
> > instance when it is started, but as far as I know, the
> > parameter file name is not recorded anywhere.
> >
> > The default location, at least on systems that I've worked
> > on, is $ORACLE_BASE/admin/SID/pfile. Actually, the default
> > location is $ORACLE_HOME/dbs, but there's usually a symbolic
> > link pointing to the other location.
> >
> > Jonathan
> >
> > _____________________________________________________
> > jonathan_at_gennick.com
> > http://gennick.com
> > Brighten the Corner Where You Are
> >
> > On Mon, 13 Mar 2000 21:59:31 GMT, sjoshi_at_ingr.com wrote:
> >
> > > Quick question..is there an easy way to tell where an instance's
 pfile
> > >is located from within Oracle
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Mar 14 2000 - 00:00:00 CST