ORA-01503: CREATE CONTROLFILE failed

Oracle Database

While creating a new control file if you are facing any of below errors then please follow below steps to fix the issues.

ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name %s in file header does not match given name of %s
ORA-01110: data file %s: ‘%s’

Example Error:

SYS>CREATE CONTROLFILE REUSE SET DATABASE "NEWDBNAME" RESETLOGS

*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/home/oracle/database/NEWDBNAME/system01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

To create the new controlfile for the new database you must use the word ‘SET’
in the CREATE CONTROLFILE COMMAND. The SET DATABASE command is what enables the
changes to the name of the database.

The correct syntax is:

CREATE CONTROLFILE SET DATABASE "newdbname" RESETLOGS NOARCHIVELOG

In case of any ┬ęCopyright or missing credits issue please check CopyRights page for faster resolutions.

Leave a Reply