Hi,
 
By default, during startup, Oracle uses the $ORACLE_HOME/dbs/spfileSID.ora
If it does not find it, it uses the initfile $ORACLE_HOME/dbs/initSID.ora
 
What I use to do:
I copy my spfile in another folder, let say $ORACLE_BASE/admin/SID/pfile/.
Then I create an initfile $ORACLE_HOME/dbs/initSID.ora containing:
spfile='$ORACLE_BASE/admin/SID/pfile/spfileSID.ora'
#ifile='$ORACLE_BASE/admin/SID/pfile/initSID.ora'
 
this way I can swith from one to the other when needed.
Hope this helps.
Regards,
 
Jean-Hilaire Yapi

Silviu Marin-Caea <silviu_marin-caea@(protected) :
On a test cluster we're experimenting with upgrading to 10.2.0.2.

We have upgraded Clusterware to 10.2.0.2 and everything went fine. It started
the database (not patched yet), all ok.

Then we upgraded the database software too.

Now things are not so well anymore.

When we start the database manually, with sqlplus from the oracle user, it
works fine, it reads the spfile
from /opt/oracle/product/10gr2/db/dbs/initprod1.ora This is what we expect.

But when we leave it to Clusterware to start the database, it reads a wrong
spfile from /srv/database/data/prod (where we keep the datafiles). In alert
log appears as "parameter with non-default value".

Why would it want to use that spfile after the upgrade?

If we rename the wrong spfile, Clusterware does not start the database at all.


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting



__________________________________________________
Do You Yahoo!?
En finir avec le spam? Yahoo! Courriel vous offre la meilleure protection possible contre les messages non nollicit?s
http://mail.yahoo.ca Yahoo! Courriel