Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: GLOBAL_NAME change

RE: GLOBAL_NAME change

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Wed, 21 Jul 2004 15:17:18 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA650146C553@25exch1.vicorpower.vicr.com>


Donald,

        You got that right. I'm sure that is someone wanted to accumulate the = total list of things in Oracle that get used in "undocumented ways" = they'd fill up an encyclopedia.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Freeman, Donald [mailto:dofreeman_at_state.pa.us] Sent: Wednesday, July 21, 2004 3:05 PM
To: oracle-l_at_freelists.org
Subject: RE: GLOBAL_NAME change

Sometimes it is not clear to me exactly what the benefit of a feature =
=3D

is. I work in a pretty small shop. When I first began in Oracle I was =
=3D

told global_names was where to seek the name of the database because I =
=3D

didn't have access to any of the v$ views. It was the one place you =3D could go as a non-dba and find the database name. It is populated =3D whether or not global_names is enabled. My first login script, which I =
=3D

still use, selects from global_names. I can see why Oracle might =3D indicate that the .domain might be expected behavior but I'm guessing =
=3D

that their analysts have not determined all the scenarios that a =3D feature, function, or value is being used by their customers. It has =
=3D

always amazed me how many undocumented uses for things in Oracle exist. =
=3D

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Goulet, Dick Sent: Wednesday, July 21, 2004 1:57 PM
To: oracle-l_at_freelists.org
Subject: RE: GLOBAL_NAME change

Actually you have two back out plans. 1) do the update, which I don't =
=3D
=3D3D

know the side effects might be. and 2) disable global_names. BTW: I =
=3D
=3D3D

don't use global_names. And in 9i when you create a database the =3D3D global_name has the domain name attached by default.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM] Sent: Wednesday, July 21, 2004 1:46 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: GLOBAL_NAME change

Dick - You are correct. The problem is that I have an existing database =
=3D
=3D3D

that
does not have the domain as a part of the GLOBAL_NAME. Near as I can =
=3D3D

tell,
the ALTER DATABASE RENAME command always tacks the domain on. That is =
=3D
=3D3D

what I
want and I intend to use that to change it.=3D3D20

   However, part of making a change is to have a backout plan. I don't =
=3D
=3D3D

like
the idea of making a change without a possibility of undoing that =3D3D change.
Thanks to Juan and Scott I have that backout method (UPDATE) in case I =
=3D
=3D3D

need
it, and I hope that I don't.

Dennis Williams
DBA
Lifetouch, Inc.

"We all want progress, but if you're on the wrong road, progress means doing an about-turn and walking back to the right road; in that case, the man who turns back soonest is the most progressive."=3D3D20 -- C.S. Lewis

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Goulet, Dick Sent: Wednesday, July 21, 2004 12:44 PM
To: oracle-l_at_freelists.org
Subject: RE: GLOBAL_NAME change

The "proper" command is: Alter database rename global_name to =3D3D3D <whatever>;

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Scott Canaan [mailto:srcdco_at_rit.edu] Sent: Wednesday, July 21, 2004 11:16 AM
To: oracle-l_at_freelists.org
Subject: RE: GLOBAL_NAME change

I usually just go in and update it. Then you can set it to whatever you want.=3D3D3D3D20

Update global_name
Set global_name =3D3D3D3D3D 'sid';
Commit;

Scott Canaan (srcdco_at_rit.edu)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DENNIS WILLIAMS Sent: Wednesday, July 21, 2004 10:08 AM
To: 'oracle-l_at_freelists.org'
Subject: GLOBAL_NAME change

I am trying to switch to GLOBAL_NAMES=3D3D3D3D3DTRUE. If I have two =
=3D3D

databases =3D3D3D
=3D3D3D3D

and
set
global_names=3D3D3D3D3Dtrue on database A, on database B I need to ALTER =
=3D
=3D3D
=3D3D3D3D

DATABASE
RENAME GLOBAL_NAME TO sid.domain. Currently this database just has GLOBAL_NAME as sid.=3D3D3D3D20

     Now my question. If something goes wrong, does anyone know a way to change the GLOBAL_NAME back to just plain sid? It seems that the ALTER DATABASE RENAME GLOBAL_NAME command always helpfully slaps the domain on the
sid. In theory since I'm not changing GLOBAL_NAMES=3D3D3D3D3DTRUE on =
=3D3D

database =3D3D3D
B,
nothing should be affected (like its existing links). But it bothers me to
make an irrevocable change.

Dennis Williams
DBA
Lifetouch, Inc.

Does believing you're the last sane man on the planet make you crazy?

       Del Spooner in I Robot, played by Will Smith



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Jul 21 2004 - 14:14:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US