Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: PFILE location in NT

RE: PFILE location in NT

From: Shahid Nasir <shahidnasir_at_emirates.com>
Date: Tue, 03 Jul 2001 21:29:33 -0700
Message-ID: <F001.00340D47.20010703212522@fatcity.com>

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.
<SPAN
class=475411904-04072001> 
<SPAN
class=475411904-04072001>Shahid.

  <FONT face="Times New Roman"
  size=2>-----Original Message-----From: Hillman, Alex   [mailto:Alex.Hillman_at_usmint.treas.gov]Sent: Tuesday, July 03, 2001   6:17 PMTo: Multiple recipients of list ORACLE-LSubject:   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
  <FONT color=#0000ff face=Arial
  size=2> 
  Alex
  Hillman   

<FONT face=Tahoma

    size=2>-----Original Message-----From: DEMANCHE Luc (Cetelem)     [mailto:Luc.Demanche_at_cetelem.fr]Sent: Tuesday, July 03, 2001 6:20     AMTo: Multiple recipients of list ORACLE-LSubject: RE:     PFILE location in NT
    Hi
    Shahid,     

<SPAN

    class=991361609-03072001>Did you specify a PFILE parameter in your startup     ?
    If
    not, o<FONT color=#0000ff face=Arial     size=2>n NT, the default location for the     parameter file is ORACLE_HOME\database.  Your database is using the     file in this location.
<SPAN

    class=991361609-03072001> 
<SPAN

    class=991361609-03072001>Luc     

      -----Message 
      d'origine-----De: Shahid Nasir 
      [mailto:shahidnasir_at_emirates.com]Date: Tuesday, July 03, 2001 
      11:30 AMÀ: Multiple recipients of list 
      ORACLE-LObjet: 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 Tue Jul 03 2001 - 23:29:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US