RE: PFILE location in NT

[Shahid Nasir]

Title: PFILE location in NT

The database creation is part of a server build which is restored to every new server. The PFILE parameter is specified but like I said I have been successful in finding the right PFILE only after making the changes and restarting the databases and checking if the changes have taken effect. But I am limited to do this only at night when no one is logged in. Thank God these are not 24x7 databases.

 

Shahid.

-----Original Message-----
From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 03, 2001 6:17 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: PFILE location in NT

It was true for versions before 8.1. Beginning with 8.1 default is the same as in unix - $ORACLE_HOME/dbs

 

Alex Hillman

-----Original Message-----
From: DEMANCHE Luc (Cetelem) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 03, 2001 6:20 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: PFILE location in NT

Hi Shahid,

Did you specify a PFILE parameter in your startup ?

If not, on NT, the default location for the parameter file is ORACLE_HOME\database.  Your database is using the file in this location.

 

Luc

-----Message d'origine-----
De: Shahid Nasir [mailto:[EMAIL PROTECTED]]
Date: Tuesday, July 03, 2001 11:30 AM
�: Multiple recipients of list ORACLE-L
Objet: PFILE location in NT

Hi all,
I have two parameter files in two different directories on the same machine. Is there a way I can find out which parameter file is being used by the database.

One way I tried was to make the changes in one file and see if it takes effect when the database is restarted. but I have more than 52 machines and it will be time consuming to do the same for all machines especially when these machines are on remote locations.

Thanks.
Shahid.