ORA-01161: database name string in file header does not
match given name of string
- 2 Answers
- 16677 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 |
TNS-00015: INTCTL: error while closing terminal input channel
ORA-21503: program terminated by fatal error
ORA-31033: Requested number of XML children string exceeds maximum string
ORA-23372: type string in table string is unsupported
NZE-29194: no CRL found in cache
TNS-00013: INTCTL: error while performing NS disconnect command
ORA-14604: During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified
NID-00505: REVERT Revert failed change NO
ORA-24335: cannot support more than 1000 columns
PLS-00351: Not logged onto database 'string'
DRG-10852: Invalid scoring type string specified for query template
NNF-00002: Invalid value passed to function call
Oracle Errors 
