Re: Parameter file location

From: <buckeye714_at_my-deja.com>
Date: Wed, 17 Jan 2001 21:30:47 GMT
Message-ID: <9452u8$kqm$1@nnrp1.deja.com>

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

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