Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

178210Jun 25 2005 — edited Jun 27 2005
Database: Oracle 10g
os: windows 2000

I want to create a new database as same as of a TEST database.

i have followed the steps below however while create the controlfile i am getting the error ORA-01161


1.i took the full backup of test system(while databse is normal shutdown)
2.Prepare new initsid.ora file and change the parameter DN_NAME=newname
3.prepare new create controlfile script with new database name
4.startup pfile='initsid.ora' nomount
5.while executing the controlfile creation script, it gives the error ORA-01161


how can resolve the problem
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2005
Added on Jun 25 2005
4 comments
578 views