change of DB_NAME using DBNEWID utility did not work
560369May 18 2007 — edited May 25 2007Hi,
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.