ORA-01161: database name string in file header does not
match given name of string
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-29555: Java source, class or resource is not allowed here
TNS-12660: Encryption or crypto-checksumming parameters incompatible
ORA-01111: name for data file string is unknown - rename to correct file
TNS-12552: TNS:operation was interrupted
DRG-10759: invalid role
RMAN-08111: some blocks not recovered: See trace file for details
RMAN-00556: could not open CMDFILE "string"
ORA-27011: skgfrd: cannot read from file opened for write
LPX-00403: unmatched quote in the XSL file
ORA-24126: invalid CASCADE_FLAG passed to DBMS_REPAIR.string procedure
ORA-07701: sksatln: internal exception: output buffer too small
ORA-28654: table and partition not overflow compatible