cancel
Showing results for 
Search instead for 
Did you mean: 

change database name

daniesh
Occasional Contributor

change database name

Hi ,
I want to change the database name.
please let me know the procedure .
9 REPLIES
Murat SULUHAN
Honored Contributor

Re: change database name

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
Murat Suluhan
Fred Ruffet
Honored Contributor

Re: change database name

What is your database ? Oracle ? DB2 ? MySQL ?
--

"Reality is just a point of view." (P. K. D.)
daniesh
Occasional Contributor

Re: change database name

Oracle
Carlos Zoller
Frequent Advisor

Re: change database name

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
Honored Contributor

Re: change database name

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.
We are the people our parents warned us about --Jimmy Buffett
Carlos Zoller
Frequent Advisor

Re: change database name

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
Frequent Advisor

Re: change database name

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
Occasional Contributor

Re: change database name

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

Re: change database name

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

All it ever took was to rebuild the control file...
We are the people our parents warned us about --Jimmy Buffett