edit your DB_DOMAIN to be blah2.com in init.ora, then
alter database rename global_name to 'sid.blah2.com'
followed by backup controlfile to trace.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Alan" <bzhang_at_sohar.com> wrote in message news:3cb7bce8.98154608_at_news.telocity.com...
> 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 Mon Apr 15 2002 - 06:40:04 CDT
