RE: DB startup question

If that's the case, have the base initSID.ora file (in the default location where Oracle expects it) with somthing like below in it. Each ifile entry will be pertaining to special situation. Uncomment the one needed and comment out the rest. Then you will be able to see the value of 'ifile' parameter to find out which initSID.ora was used.

#ifile=/u01/app/oracle/product/8.1.6/dbs/initSID_job1.ora ifile=/u01/app/oracle/product/8.1.6/dbs/initSID_job2.ora #ifile=/u01/app/oracle/product/8.1.6/dbs/initSID_job3.ora

HTH..
- Kirti
> -----Original Message-----
> From: Jacques Kilchoer [SMTP:Jacques.Kilchoer_at_quest.com]
> Sent: Monday, January 08, 2001 1:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: DB startup question
>
>
> Sure, but suppose I call in sick due to weltschmerz or ennui the next day,
> and my colleague wants to know which pfile I used to startup the database
> the day before? e.g. we have different pfiles we employ depending on the
> type of tasks for which the database will be used. The only method I know
> is to view the parameters and compare them to the various pfiles (assuming
> none of the parameters have been changed since the database was
Received on Mon Jan 08 2001 - 14:13:27 CST