How do I find out which pfile the instance was started with?
Larry
Larry
-
-
Re: Pfile Question
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\dat abase\init<SID> .ora
nix*: ORACLE_HOME/dbs/init<SID>.ora
For 9i, if you have created an spfile "spfile<SID>.or a", then it would
look for spfile first in the same locations according to OS.
Regards
/Rauf
--
Posted via http://dbforums.com
Comment