ORA-01161: database name string in file header does not
match given name of string
- 2 Answers
- 16571 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-03222: average row size and row count must be greater than zero
PLS-00399: different types of columns in UNION, INTERSECT, or MINUS expression
RMAN-05510: Duplicate finished
NZE-29022: Operation is being attempted on the wrong side of the client/server connection.
ORA-24422: error occurred while trying to destroy the Session Pool
ORA-13617: The specified task string already executing
ORA-28606: block too fragmented to build bitmap index (string,string)
DRG-10205: server deregister failed
ORA-30756: cannot create column or table of type that contains a supertype attribute
NNL-00037: Error number while sequencing through parameter table.
DRG-11006: invalid alter index parameter string
ORA-31110: Action failed as resource string is locked by name
Oracle Errors 
