Re: Change domain name in global name

Alan,

I am a bit confused what do you mean under global name: sid.blah.com

Is that DB_NAME, DB_DOMAIN or GLOBAL_NAMES parameter in init.ora?

For GLOBAL_NAMES parameter (TRUE|FALSE) use: ALTER SYSTEM | ALTER SESSION syntax.

For DB_DOMAN you have to edit init.ora file and restart the database.

For DB_NAME check the procedure on:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi?s=3cb72b672158ffff;act=ST; f=14;t=161

For GLOBAL_NAME parameter use:
alter database rename global_name to <newdb_name>.<domain>;

If you are reffering to GLOBAL_DBNAME in listener.ora file, then change the value of this parameter, stop/start the listener.

Hope that helps,

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com

Check the latest Oracle DBA forums for answers to your questions: http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

"bing" <bzhang_at_sohar.com> wrote in message news:3cb7431f.66977819_at_news.telocity.com...
> I have two databases:
>
> 1. Linux 6.2
> Oracle EE 8.1.7.3
> global name: sid1.blah.com
>
> 2. Solaris 8
> Oracle EE 8.1.6
> global name: sid2.blah.com
>
> Now I need to change blah.com to blah2.com, how should I do it? Should
> I shut down the instance while I am doing this? I think I need to
> modify init.ora, listener.ora and tnsname.ora, any other files I need
> to take care of?
>
> I remember that the domain name is also recorded in control files, so
> how should I do it? some Alter commands?
>
> Thanks,
>
> Alan
Received on Fri Apr 12 2002 - 23:07:52 CDT