topic Re: change database name in Operating System - HP-UX

change database name

daniesh — Thu, 26 Jun 2008 08:00:06 GMT

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

Re: change database name

Murat SULUHAN — Thu, 26 Jun 2008 08:18:32 GMT

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

Re: change database name

Fred Ruffet — Thu, 26 Jun 2008 09:01:29 GMT

What is your database ? Oracle ? DB2 ? MySQL ?

Re: change database name

daniesh — Thu, 26 Jun 2008 09:18:42 GMT

Oracle

Re: change database name

Carlos Zoller — Fri, 27 Jun 2008 18:35:12 GMT

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,

Re: change database name

TwoProc — Fri, 27 Jun 2008 19:46:29 GMT

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.

Re: change database name

Carlos Zoller — Sat, 28 Jun 2008 03:05:34 GMT

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,

Re: change database name

Carlos Zoller — Sat, 28 Jun 2008 03:11:21 GMT

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.

Re: change database name

daniesh — Sat, 28 Jun 2008 10:02:51 GMT

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

Re: change database name

TwoProc — Mon, 30 Jun 2008 18:45:28 GMT

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

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