1. create you pfile
2. put a link in your $ORACLE_HOME/dbs to that pfile in the form of initSID.ora
3. shutdown your db
4. rm your spfile using an os command
5. startup
The startup procedure looks for an spfile first and then looks in ?/dbs for initSID.ora.




Reply With Quote