Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help! How to find pfile

Re: Help! How to find pfile

From: <oberco_at_my-deja.com>
Date: 2000/03/14
Message-ID: <8alios$p2u$1@nnrp1.deja.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US