Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answers were Sorted based on User's Feedback



ORA-01161: database name string in file header does not match given name of string..

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

ORA-01161: database name string in file header does not match given name of string..

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

Post New Answer

More Oracle Errors Interview Questions

PCC-00118: Use of host variable initialization not supported by ANSI SQL

1 Answers  


ORA-22602: pickler TDS handle [string] is not well-formed

1 Answers  


RMAN-08133: channel string: the autobackup does not contain a standby controlfile.

1 Answers  


RMAN-08031: released channel: string

1 Answers  


ORA-28561: unable to set date format on non-Oracle system

1 Answers  


RMAN-08060: unable to find archive log

1 Answers  


ORA-26690: datatype not supported at non-Oracle system

1 Answers  


ORA-16024: parameter string cannot be parsed

1 Answers  


TNS-00203: Unable to start tracing in intlsnr

1 Answers  


ORA-23346: primary key or object ID is undefined for table or materialized view string

1 Answers  


DRG-11810: Partial Update OK

1 Answers  


ORA-23412: master table's primary key columns have changed

1 Answers  


Categories