RE: Renaming GLOBAL_NAME

Yes, i too tried.... still am getting the same result, meaning that, i'm not able to remove the db_domain name in GLOBAL_NAME.

Any one have any solutions for this.

Nirmal,

> -----Original Message-----
> From: Mario Alberto Ramos Arellano [SMTP:alramos_at_capufe.gob.mx]
> Sent: Wednesday, September 19, 2001 5:25 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Renaming GLOBAL_NAME
>
> I tried all the suggestions and the only one that worked was updating the
> global name directly to the table.
>
> Mario Alberto Ramos
> >>> Prasada.Gunda1_at_hartfordlife.com 17/09/01 16:35 >>>
>
> Thank you all for your replies. I bounced the database and still it has
> the same problem.
>
> Regards,
> Prasad
>
>
>
>
>
> "Rachel
>
> Carmichael" To: Multiple recipients of
> list ORACLE-L <ORACLE-L_at_fatcity.com>
> <carmichr_at_hot cc:
>
> mail.com> Subject: Re: Renaming
> GLOBAL_NAME
> Sent by:
>
> root_at_fatcity.
>
> com
>
>
>
>
>
> 09/17/2001
>
> 03:30 PM
>
> Please
>
> respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
> you need to reboot your database, changing the init.ora parameter to
> global_name to false:
>
> SQL> select value from v$parameter where name like 'global_name%';
>
> VALUE
> ----------------------------------------------------------------------
> FALSE
>
> SQL> select * from global_name;
>
> GLOBAL_NAME
> ----------------------------------------------------------------------
> UREGPROD
>
>
>
> >From: Paul Baumgartel <treegarden_at_yahoo.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: Renaming GLOBAL_NAME
> >Date: Mon, 17 Sep 2001 10:05:20 -0800
> >
> >I don't think you can do this. GLOBAL_NAME by definition consists of
> >the database name and database domain, which defaults to WORLD.
> >
> >Paul Baumgartel
> >
> >--- Prasada.Gunda1_at_hartfordlife.com wrote:
> > >
> > > Hi All,
> > >
> > > I am trying to rename the global_name from SIMSNT7B.WORLD to
> > > SIMSNT7B.
> > >
> > > I issued the following command to change the global_name.
> > >
> > > ALTER DATABASE RENAME GLOBAL_NAME TO SIMSNT7B;
> > >
> > > Still it is showing SIMSNT7B.WORLD when I query the global_name view.
> > > SQL> select * from global_name;
> > >
> > > GLOBAL_NAME
> > > ----------------------------------
> > > SIMSNT7B.WORLD
> > >
> > > Values for the following parameters in v$parameter view,
> > > GLOBAL_NAMES parameter value is FALSE and DB_DOMAIN parameter value
> > > is
> > > NULL.
> > > We are not using Oracle Names server. I renamed SQLNET.ORA file in
> > > network\admin location.
> > > Init.ora file has global_names set to false.
> > >
> > > How do I change to SIMSNT7B? This database is on Windows NT and it
> > > is
> > > 8.1.6.
> > >
> > > Thanks in advance for your help.
> > >
> > > Best regards
> > > Prasad
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > > INET: Prasada.Gunda1_at_hartfordlife.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing
> > > Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> >
> >
> >__________________________________________________
> >Terrorist Attacks on U.S. - How can you help?
> >Donate cash, emergency relief information
> >http://dailynews.yahoo.com/fc/US/Emergency_Information/
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Paul Baumgartel
> > INET: treegarden_at_yahoo.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Prasada.Gunda1_at_hartfordlife.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mario Alberto Ramos Arellano
> INET: alramos_at_capufe.gob.mx
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nirmal Kumar  Muthu Kumaran
  INET: NIRMALK_at_qtel.com.qa

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).