From: rs_arwar@hotmail.com   
      
   Originally posted by Larry Lowe   
      
   > How do I find out which pfile the instance was started with?   
      
   >   
      
   > Larry   
      
      
      
      
      
   If you did not use option startup pfile=..... to start your database,   
   then Oracle looks for the pfile in the default location i.e.   
      
      
      
   Win*: ORACLE_HOME\database\init.ora   
      
   nix*:  ORACLE_HOME/dbs/init.ora   
      
      
      
   For 9i, if you have created an spfile "spfile.ora", then it would   
   look for spfile first in the same locations according to OS.   
      
      
      
   Regards   
      
   /Rauf   
      
      
   --   
   Posted via http://dbforums.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)