What happens when you don't have parameter file?
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/oracle/11.1.0/dbs/initebsofdp.ora'
SQL
When you give startup command it will search for spfile<sid>.ora file from $ORACLE_HOME/dbs location .If it is not found then it will search for spfile.ora file.if not found then it will search for init<sid>.ora file and then init.ora .if it is not found you will get below error .
if you have backup parameter file just copy to $ORACLE_HOME/dbs location and give startup .
it will start your database.
No comments:
Post a Comment