Create control file failed
When i am recreating the controlfile(when i am trying the d/b name) i am getting the error as follows.
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name DBSONIA in file header does not match given name of TEST
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\DBSONIA\SYSTEM01.DBF'
[Edited by sonia on 03-01-2002 at 07:57 AM]
have u set the oracle_sid before recreating teh contronfiles ?
secondly, can u poste your create controlfile script ?
The error msg says your db name is different. Check out the same.
You have to use SET clause in CREATE CONTROLFILE command for renaming database.
CREATE CONTROLFILE REUSE SET "TEST" ...
Click Here to Expand Forum to Full Width