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

ORA-29555: Java source, class or resource is not allowed here

1 Answers  


TNS-12660: Encryption or crypto-checksumming parameters incompatible

1 Answers  


ORA-01111: name for data file string is unknown - rename to correct file

1 Answers  


TNS-12552: TNS:operation was interrupted

1 Answers  


DRG-10759: invalid role

1 Answers  


RMAN-08111: some blocks not recovered: See trace file for details

1 Answers  


RMAN-00556: could not open CMDFILE "string"

2 Answers  


ORA-27011: skgfrd: cannot read from file opened for write

1 Answers  


LPX-00403: unmatched quote in the XSL file

1 Answers  


ORA-24126: invalid CASCADE_FLAG passed to DBMS_REPAIR.string procedure

1 Answers  


ORA-07701: sksatln: internal exception: output buffer too small

1 Answers  


ORA-28654: table and partition not overflow compatible

1 Answers  


Categories