how to change the name of oracle database

[hare jjj]

hi all

 

i need to change my oracle database name.

 

as per my googling i have got 2 points , i need to change DBID ans DBNAME .

 

I just want to know what will happen if i change only DBNAME . i didnt had any operations going and no backups .

 

Please let me know the procedure also if u have .

http://www.oracle.com/technology/obe/paa/obe-mdb/html/Chg_DB_Name.htm

 

Thanks

hari

[Arju]

Have a look at http://arjudba.blogspot.com/2008/04/how-to-change-database-name-and-dbid.html

 

Mohammad Abdul Momin Arju,
Head of Database Department,
Maestro (Pvt) Ltd.
+8801710282272
http://arjudba.blogspot.com

---

From: hare jjj <hare...@gmail.com>
To: oracle-...@googlegroups.com
Sent: Thursday, 16 April, 2009 19:44:49
Subject: how to change the name of oracle database

[Anurag Mishra]

Hi,
 Use DBNEWID utility to change the database name.

 DBNEWID: DBNEWID is a database utility that can change the internal database identifier(DBID) and the database name(DBNAME) for an operational database.
The DBID is an internal unique identifier for a database. Because RMAN distinguishes databse by DBID. The DBNEWID utility allowing you to change any of the following:

• only the DBID of a database
• only the DBNAME of a database
• both the DBNAME and DBID of a database

In your case you only want database name change right.
Changing only the Database Name:

Steps as follow:

• SHUTDOWN IMMEDIATE
• STARTUP MOUNT
• open one more terminal and run nid TARGET=sys/change_on_install DBNAME=NEWNAME SETNAME=YES
• modify parameter file (change database new name) and generate a new password file before restarting the database.
• STARTUP
  

If facing any problems contact me.

Regds
Anurag Mishra
anuragm...@gmail.com