RE: PFILE location in NT

Like I
said "I have two parameter files in two different directories on the same machine". I more of a UNIX guy so I know that if I want to look at the pfile in unix I would go directly to the ORACLE_HOME/DBS directory. But in NT, it is only at the time of instance creation that the pfile location can be specified. Therefore I am looking for some command/utility that can tell me that path after the DB creation.

<FONT face="Times New Roman"

  size=2>-----Original Message-----From: Kevin Kostyszyn   [mailto:kevin_at_dulcian.com]Sent: Tuesday, July 03, 2001 5:46   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   PFILE location in NT
<FONT color=#0000ff face=Arial

  size=2>Couldn't you look at the name of the db in the pfile and compare it to   the sid in sqlplus?
<FONT color=#0000ff face=Arial

  size=2>KK   

    <FONT face=Tahoma
    size=2>-----Original Message-----From: root_at_fatcity.com     [mailto:root_at_fatcity.com]On Behalf Of Shahid NasirSent:     Tuesday, July 03, 2001 5:30 AMTo: Multiple recipients of list     ORACLE-LSubject: 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.    Received on Wed Jul 04 2001 - 00:00:53 CDT