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!

change of DB_NAME using DBNEWID utility did not work

560369May 18 2007 — edited May 25 2007
Hi,

I have Oracle10g installed on RHEL4.0.
after installation i tried to change the DB_NAME from "orcl" to "msdbbk" following the document below
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/dbnewid.htm#i1005317
but i am getting error as follows:
ORA-01103: database name 'MSDBBK' in control file is not 'ORCL'

this are the steps i followed in order according to the document and changing only DB_NAME:
1. SHUTDOWN IMMEDIATE
STARTUP MOUNT

% nid TARGET=SYS/oracle@test_db DBNAME=test_db SETNAME=YES
DBNEWID - Completed successfully.

then i had to follow the instructions in this
Note:
The DBNEWID utility does not change the server parameter file (SPFILE). Therefore, if you use SPFILE to start your Oracle database, you must re-create the initialization parameter file from the server parameter file, remove the server parameter file, change the DB_NAME in the initialization parameter file, and then re-create the server parameter file.

so this is what i did. i logged in sqlplus as sys. i first created pfile as follows:
sqlplus> create pfile=initmsdbbk.ora from spfile=spfileorcl.ora;

i opened pfile.ora and modified only the following:
'db_name=msdbbk'
leaving every othe value the same as it was before
then i deleted the spfile and created a new one from the pfile i modified as follows:
SQL> create spfile='spfilemsdbbk.ora' from pfile='initmsdbbk.ora';

then i shutdown the database and then tried to start again
sqlplus> startup

but i was getting this error message as follows:
SQL> startup
ORACLE instance started.

Total System Global Area 1224736768 bytes
Fixed Size 2020384 bytes
Variable Size 318770144 bytes
Database Buffers 889192448 bytes
Redo Buffers 14753792 bytes
ORA-01103: database name 'MSDBBK' in control file is not 'ORCL'

How can i fix this control file issue. Am i supposed to creat a control file at some point of time during this entire process.

Can someone help me fix this please.

Thanks,
Philip.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2007
Added on May 18 2007
33 comments
2,957 views