Re: Change domain name in global name

What I mean is that I have to change the domain part of global name. i.e change sid1.blah.com to sid1.blah2.com and sid2.blah.com to sid2.blah.com, since we just changed our company's domain name.

This means I have to change init.ora, tnsname.ora, listener.ora. But I am not sure any other file I have to change. Also I am not sure whether I have to use Alter command to change domain name which maybe be stored in control files too.

Thanks,

Alan

On Sat, 13 Apr 2002 04:07:52 GMT, "Trifon Anguelov" <trifona_at_pacbell.net> wrote:

>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:59:40 CDT