Re: Parameter file location

In article <9452u8$kqm$1_at_nnrp1.deja.com>,   buckeye714_at_my-deja.com wrote:
> In article <lxn96.40926$0d.4589316_at_nnrp4.clara.net>,
> "peter" <pjones_at_prodigy-uk.com> wrote:
> > Hi,
> > Can i query the db and find out where is the path to init.ora file
 in
 use?
> > I can query v$parameter and see the value of the different non-
 default
> > parameters, but how can I find out which is the actual pfile that i
 am
 using
> > (location,name...)
> >
> > thanx!
> >
> > pj
> >
> >
>
> You don't say what OS you are using, so I'm not exactly sure. On UNIX
> you can look in the $ORACLE_HOME/dbs directory. The default pfile, or
> more likely a link to the default pfile, will be in this directory.
 You
> can always specify a different pfile on the startup command line, so
 if
> you didn't start the database I don't think you can be 100% sure which
> pfile was used.
>
> HTH,
> Patrick

You're not answering his question.

The answer is, no, you can't query its location. It's not in any table or view inside the database.

Yong Huang
yong321_at_yahoo.com

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 17 2001 - 15:45:03 CST