Re: Parameter file location

From: Helena <harms_at_uk.nomad.com>
Date: Thu, 18 Jan 2001 20:00:33 -0000
Message-ID: <AWH96.182947$eT4.15174671@nnrp3.clara.net>

yeap, but the question really implies that the instance is mounted perhaps by the wrong pfile. Let's say you a have 10 dbs in your system and someone not very experienced starts the db.
So you want to really know if the right pfile has been used. You can start the db with the right pfile but you cannot really afford to shut it down unless really neccessary...

So, my answer is no, there is no way that by querying the db you can obtain the path and actual name of the init file.

"MDEHE" <mdehe_at_aol.com> wrote in message news:20010117172206.04765.00007140_at_ng-mi1.aol.com...
> One way to find out, provided you don't have multiple copies, is to do a
search
> for init*.ora. Typically, the name of your sid is inserted in your
init.ora.
> In our case, we have four servers, one named B03. The init.ora on that
server
> is called initb03.ora, and I keep that file in the same location as the
> datafiles. You can keep it whereever you want. Just be sure you know the
path
> when starting up your database.
Received on Thu Jan 18 2001 - 14:00:33 CST