Oracle Tips : How to rename oracle database name (DBNAME) and SID

by cryst · Published March 18, 2011 · Updated March 1, 2011

Oracle Tips : How to rename oracle database name (DBNAME) and SID

Rename SID and DBNAME (Not change DBID)
Example case — > I want to rename sid from OLD to NEW

1. Shutdown database and startup on mount mode
SQL> shutdown immediate
SQL> startup mount

2. If use spfile should create pfile from spfile
SQL> create pfile from spfile;

3. Use DBNEWID Utility for set new database name (Use on OS prompt)
% nid target=sys/ dbname= setname=Y

4. Edit parameter db_name and add parameter instance_name in pfile
*.db_name=’NEW’
*.instance_name=’NEW’

5. Rename on prameter file from “initOLD.ora” to “initNEW.ora”

6. Create new password file
% orapwd file=orapw password=password entries=5

7. Set ORACLE_SID = NEW
% export ORACLE_SID= –> Unix
> set ORACLE_SID= –> Windows

8. Edit database name in oratab file
oratab file on solaris in /var/opt/oracle/oratab
on AIX and Linux /etc/oratab
:/oracle/product/10.2.0:N

9. Startup database in open mode (No resetlogs)
SQL> startup pfile=init.ora

10. Create spfile from pfile
SQL> create spfile from pfile;

11. Verify dbname and instance name
SQL> select name from v$database;
SQL> select instance_name from v$instance;