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: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/03/14
Message-ID: <38d39fdf.18883983@netnews.worldnet.att.net>#1/1

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
Received on Tue Mar 14 2000 - 00:00:00 CST

Original text of this message

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