i have already the 'oracle' database.
i want to create new database 'pra'.
after then i run the script 'create database pra................'.
i got the error create database failed.
then i tried and leave that one.
then again i am going to connect my old database 'oracle'
it is giving error.
i given cmds like this
ORA-01103:database name 'PRA' in control file is not 'ORACLE'.
now what i have to do to connect the 'oracle' database and to open it.
please help me anybody?.
1. Did you set your ORACLE_SID before creating your new database ?
2. Did you give connect internal before giving the startup command >
3. Which version or Oracle/OS are you runnng ?
Did you give 'control file reuse' in the create database statement for 'pra'?
In that case, your control file is affected. Since init.ora has a different db name, hence the error.
You can create a new control file from your backed up control file.
Click Here to Expand Forum to Full Width