Re: Renaming GLOBAL

From: Mario Alberto Ramos Arellano <alramos_at_capufe.gob.mx>
Date: Tue, 18 Sep 2001 18:29:38 -0700
Message-ID: <F001.003921E0.20010918182518@fatcity.com>

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).

Received on Tue Sep 18 2001 - 20:29:38 CDT