Re: Help! How to find pfile

ok everybody,
I checked it in our database and you are totally right! Sorry to get some doubt from Jonathan answer. BR
Olivier

"Jonathan Gennick" <jonathan_at_gennick.com> a écrit dans le message news: 38d39fdf.18883983_at_netnews.worldnet.att.net...
> 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