How to change database name and DBID for existing database

Subject : How to change database name and DBID for existing database.Version ; Oracle 10.2.0.3

SQL> select name from v$database;

NAME
---------
TESTDB1

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
testdb1

So the aim is to change DATABASE name to TESTDB So the magical statement is

nid target=sys/change_on_install dbname=testdb logfile=convert_db

DBNEWID: Release 10.2.0.3.0 - Production on Mon Apr 14 13:14:25 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to database TESTDB1 (DBID=403517258)

Connected to server version 10.2.0

Control Files in database:
/u99/oradata/testdb1/data/testdb1ctrl001.ctl
/u99/oradata/testdb1/data/testdb1ctrl002.ctl
/u99/oradata/testdb1/data/testdb1ctrl003.ctl

Changing database ID from 403517258 to 2435353265
Changing database name from TESTDB1 to TESTDB
Control File /u99/oradata/testdb1/data/testdb1ctrl001.ctl - modified
Control File /u99/oradata/testdb1/data/testdb1ctrl002.ctl - modified
Control File /u99/oradata/testdb1/data/testdb1ctrl003.ctl - modified
Datafile /u99/oradata/testdb1/data/system01.dbf - dbid changed, wrote new name
Datafile /u99/oradata/testdb1/data/undotbs01.dbf - dbid changed, wrote new name
Datafile /u99/oradata/testdb1/data/sysaux01.dbf - dbid changed, wrote new name
Datafile /u99/oradata/testdb1/data/tab01.dbf - dbid changed, wrote new name
Datafile /u99/oradata/testdb1/data/tab02.dbf - dbid changed, wrote new name
Datafile /u99/oradata/testdb1/data/tab01_02.dbf - dbid changed, wrote new name
Datafile /u99/oradata/testdb1/data/undotbs02.dbf - dbid changed, wrote new name
Datafile /u99/oradata/testdb1/data/temp01.dbf - dbid changed, wrote new name
Control File /u99/oradata/testdb1/data/testdb1ctrl001.ctl - dbid changed, wrote new name
Control File /u99/oradata/testdb1/data/testdb1ctrl002.ctl - dbid changed, wrote new name
Control File /u99/oradata/testdb1/data/testdb1ctrl003.ctl - dbid changed, wrote new name
Instance shut down

Database name changed to TESTDB.
Modify parameter file and generate a new password file before restarting.
Database ID for database TESTDB changed to 2435353265.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.


It will shutdown the running instance.if you will try to start without changing the database name in initfile.

ORA-01103: database name 'TESTDB' in control file is not 'TESTDB1'

So , change back the cluster_database to true and change the database name as well.

then

alter database open resetlogs;