Change Database Name or SID

Since 9i dbnewid utility (nid) can be used to change database name

(and DBID if required).

If database name being changed only then resetlogs is not required:

1. startup database in mount mode

shutdown immediate

startup mount

2. run nid to change database name:

nid target=sys/syspassword@dbtns dbname=newname setname=YES

3. shutdown and start database in mount mode:

shutdown immediate

startup mount

4. change db_name in spfile (or in pfile editing the file):

alter system set db_name=newname scope=spfile;

5. recreate password file:

orapwd file=orapwnewname password=syspassword

6. startup the database

startup

7. post rename steps:

change SID in listener.ora

correct tnsnames.ora

remove old trace directories

change /etc/oratab (UNIX) or rename windows service using oradim

Enjoyy :)