adspace


  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

How do you switch from an init.ora file to a spfile?

Question Posted / ramakrishnach.dba

Answer Posted / ramakrishnach.dba

oracle searches parameter file in following manner

1) spfile$ORACLE_SID.ora
2) spfile.ora
3) init$ORACLE_SID.ora
4) init.ora

if oracle finds spfile$ORACLE_SID.ora file it ignores rest of the files

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2059

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2717

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2187