Re: Change domain name in global name

one correction, change sid2.blah.com to
sid2.blah2.com.

Alan

On Sat, 13 Apr 2002 04:59:40 GMT, bzhang_at_sohar.com (Alan) wrote:

>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 Sat Apr 13 2002 - 00:07:19 CDT