I tried all the suggestions and the only one that worked was updating the global name
directly to the table.
Mario Alberto Ramos
>>> [EMAIL PROTECTED] 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
<[EMAIL PROTECTED]>
<carmichr@hot cc:
mail.com> Subject: Re: Renaming GLOBAL_NAME
Sent by:
root@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 <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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
>
>--- [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).