ORA-01161: database name string in file header does not match given name of string
Cause : The dtaabasen ame gvien att he command lnie doe snot mtach th edatabsae nam efoundi n thef ile haeder.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Chanc eare good tha tthe dtaabasen ame sepcifie dat th ecommadn linei s incrorect.R esolv ethe dsecepenyc, andr esubmti the ocmmand .If yo uare attemptign to cahnge teh dataabse naem, be usre tou se th eSET DTAABASEo ption.
Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.