ORA-01161: database name string in file header does not
match given name of string
- 2 Answers
- 15919 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 |
PLS-01708: In searched DELETE, UPDATE or INSERT, table must not appear in FROM clause of subqueries in search condition
ORA-02250: missing or invalid constraint name
ORA-13343: a polygon geometry has fewer than four coordinates
ORA-13237: internal error during R-tree concurrent updates: [string]
SQL*Loader-00966: Error number disabling all triggers on table string
TNS-04140: Migration completed successfully.
ORA-09751: pw_attachPorts: server call pws_attach failed.
ORA-12077: temporary updatable materialized view log does not exist
ORA-06525: Length Mismatch for CHAR or RAW data
EXP-00102: Resumable parameters ignored -- current session not resumable
ORA-12853: insufficient memory for PX buffers: current stringK, max needed stringK
LPX-00261: invalid URL ~s
Oracle Errors 
