Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help! How to find pfile
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
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