change database name

[daniesh]

Hi ,
I want to change the database name.
please let me know the procedure .

[Murat SULUHAN]

Hi

If your database software is Oracle, Tom will help you

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:318216852435

Best Regards
Murat

[Fred Ruffet]

What is your database ? Oracle ? DB2 ? MySQL ?

[daniesh]

Oracle

[Carlos Zoller]

Hi, it would be nice to know which Oracle version you are running: 9i, 10g, 11i?

But anyway, no matter what your Oracle version is, the NAME of the database can not be changed. That's the DB_NAME initialization parameter. Now, if you want to change the name of the instance, that may be possible but first please clarify exactly what are you trying to do, that would be the best to give you a better response.

RGs,

[TwoProc]

You can change the name by rebuilding the controlfile. Look around for the procedure, it's well known and well documented.

If you just want to change what it looks like externally for sqlnet connections, you can just change it on all of the clients that connect if you like, or you can change it for the name of the listener as well. There's a lot of ways to do this, without fully changing the name of the database itself.

But, if you really want to change the name of the database, just rebuild the controlfile.

[Carlos Zoller]

My apologies, I guess Twoproc is right. Now there's a utility to change database name, it wasn't possible in the past.

Check this, for sure this will solve your issue.

http://dba.ipbhost.com/index.php?showtopic=7771

You always learn new things.

Rgs,

[Carlos Zoller]

And so much better explained.

http://www.oracle-base.com/articles/9i/DBNEWID.php

Beware that this for sure will need to be done on a maintenance window, and you'll need to check that your client connections are not affected so you can roll it back.

[daniesh]

I have found the solutin in the first thread using ASKTOM URL.

[TwoProc]

Actually, I've been changing database names since I started administering Oracle 7.x...

All it ever took was to rebuild the control file...