Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01161: database name string in file header does not
match given name of string
- 2 Answers
- 17530 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-02402: Bad CLBGNAMES parameter in tnsnames.ora
DRG-12900: Operation:string for index: string has already been started
ORA-24791: invalid transaction start flags
ORA-32321: REFRESH FAST of "string"."string" unsupported after detail table TRUNCATE
DRG-11853: No Host Name Found
CLSR-00521: Event string is rejected by EVM daemon
SQL*Loader-00622: Column not found before end of logical record (use TRAILING NULLCOLS)
TNS-12609: TNS: Receive timeout occurred
ORA-39706: schema 'string' not found
ORA-30505: system triggers should not reference a column in a WHEN clause
ORA-19704: file name exceeds maximum length of string
UDE-00013: internal expdp error.
Oracle Errors 
