RE: GLOBAL_NAME change
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Jul 2004 13:06:45 -0500
Dick - Actually I am beginning to implement GLOBAL_NAMES. Based on some good
advice on this list I have always set GLOBAL_NAMES=FALSE. However my new
manager has quite a bit of replication experience, thinks we may end up
using replication at some point, and would like to begin the shift toward
GLOBAL_NAMES=TRUE.
I have always had trouble creating database links with
GLOBAL_NAMES=TRUE. A neat trick which I understand is taught in the
replication class is to create two links:
1. As SYSTEM, CREATE PUBLIC DATABASE LINK db.domain USING "db.domain";
2. As the schema owner, CREATE DATABASE LINK db.domain CONNECT TO user
IDENTIFIED BY
Has anyone else used this idea or ever seen it documented (or even given a
name)?
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."
-- C.S. Lewis
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Goulet, Dick
Sent: Wednesday, July 21, 2004 12:57 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: GLOBAL_NAME change
Actually you have two back out plans. 1) do the update, which I don't =
know the side effects might be. and 2) disable global_names. BTW: I =
don't use global_names. And in 9i when you create a database the =
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@xxxxxxxxxxxxx]
Sent: Wednesday, July 21, 2004 1:46 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: GLOBAL_NAME change
Dick - You are correct. The problem is that I have an existing database =
that
does not have the domain as a part of the GLOBAL_NAME. Near as I can =
tell,
the ALTER DATABASE RENAME command always tacks the domain on. That is =
what I
want and I intend to use that to change it.=20
However, part of making a change is to have a backout plan. I don't =
like
the idea of making a change without a possibility of undoing that =
change.
Thanks to Juan and Scott I have that backout method (UPDATE) in case I =
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."=20
-- C.S. Lewis
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Goulet, Dick
Sent: Wednesday, July 21, 2004 12:44 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: GLOBAL_NAME change
The "proper" command is: Alter database rename global_name to =3D
<whatever>;
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Scott Canaan [mailto:srcdco@xxxxxxx]
Sent: Wednesday, July 21, 2004 11:16 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: GLOBAL_NAME change
I usually just go in and update it. Then you can set it to whatever you
want.=3D3D20
Update global_name
Set global_name =3D3D3D 'sid';
Commit;
Scott Canaan (srcdco@xxxxxxx)
(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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DENNIS WILLIAMS
Sent: Wednesday, July 21, 2004 10:08 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: GLOBAL_NAME change
I am trying to switch to GLOBAL_NAMES=3D3D3DTRUE. If I have two =
databases =3D
=3D3D
and
set
global_names=3D3D3Dtrue on database A, on database B I need to ALTER =
=3D3D
DATABASE
RENAME GLOBAL_NAME TO sid.domain. Currently this database just has
GLOBAL_NAME as sid.=3D3D20
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=3D3D3DTRUE on =
database =3D
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
