ORA-01161: database name string in file header does not
match given name of string
- 2 Answers
- 16633 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / scavenger
CREATE CONTROLFILE SET DATABASE "TARGET" RESETLOGS NOARCHIVELOG
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name SOURCE in file header does not
match given name of TARGET
ORA-01110: data file 19:
'/apps/oracledata/TARGET/osys3/stat0001.dbf'
=> no solution, the datafile is corrupt
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / guest
Cause: The database name given at the command line does not
match the database name found in the file header.
Action: Chance are good that the database name specified at
the command line is incorrect. Resolve the descepency, and
resubmit the command. If you are attempting to change the
database name, be sure to use the SET DATABASE option.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 1 No |
ORA-06754: TLI Driver: unable to get local host address
SQL-02152: Invalid numeric variable for use in an array GET/SET statement
ORA-16788: Unable to set one or more database configuration property values
NNL-00017: cannot start server, program "string" does not exist
LPX-00220: the string "]]>" cannot occur in character data
ORA-07702: unrecognized device type in archive text
SQL-02123: Context referenced in EXEC TOOLS GET CONTEXT statement not found
PCC-02433: Invalid host variable and attribute pairing
ORA-32033: unsupported column aliasing
ORA-27081: unable to close the file
ORA-30182: invalid precision specifier
ORA-23542: dependent object "string"."string" already registered
Oracle Errors 
