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-09353: Windows 32-bit Two-Task driver unable to open event semaphore
ORA-00025: failed to allocate string
ORA-33313: (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.
ORA-00263: there are no logs that need archiving for thread string
ORA-21520: database server driver not installed
ORA-09809: Unable to get user's group ID from connection
ORA-06116: NETTCP: unable to create ORASRV process
ORA-08177: can't serialize access for this transaction
PLS-00326: IN clause must contain same number of expressions as subquery
ORA-26696: no streams data dictionary for object with number string and version number string from source database string
ORA-31686: error creating worker processes
ORA-30394: source statement identical to the destination statement