Best practice

Originally Posted by
Rikesh_p
Blah, blah, blah...
I also have 2 init......ora files (initSQLSERV.ora & initNEW.ora)
Can there be 2 init.....ora files?
Only if you start the database with the CORRECT one, for example: STARTUP PFILE=init????.ora
It is best practice to start the database using either the default init{SID}.ora or spfile{SID}.ora files.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb