RE: ok for the last 18 yrs in using oracle I must have been asleep, "implied database link"
- From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
- To: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>, "bertrand.guillaumin@xxxxxxxxxx" <bertrand.guillaumin@xxxxxxxxxx>, "robertgfreeman@xxxxxxxxx" <robertgfreeman@xxxxxxxxx>, "TESTAJ3@xxxxxxxxxxxxxx" <TESTAJ3@xxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 18 Feb 2010 09:57:07 -0500
A developer pointed this out to me recently and I had no idea that this could
be done. It works when global_name are set to FALSE and (of course) the
passwords must be the same in both databases.
Jeremy
-----Original Message-----
From: D'Hooge Freek [mailto:Freek.DHooge@xxxxxxxxx]
Sent: Thursday, February 18, 2010 9:25 AM
To: bertrand.guillaumin@xxxxxxxxxx; robertgfreeman@xxxxxxxxx;
TESTAJ3@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: ok for the last 18 yrs in using oracle I must have been asleep,
"implied database link"
I can't test it for the moment, but could it be that the parameter global_names
has to be set to TRUE?
X-archive-position: 25774
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@xxxxxxxxxxxxx
Errors-to: oracle-l-bounce@xxxxxxxxxxxxx
X-original-sender: Freek.DHooge@xxxxxxxxx
Precedence: normal
Reply-to: Freek.DHooge@xxxxxxxxx
List-help: <mailto:ecartis@xxxxxxxxxxxxx?Subject=help>
List-unsubscribe: <oracle-l-request@xxxxxxxxxxxxx?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@xxxxxxxxxxxxx?Subject=subscribe>
List-owner: <mailto:steve.adams@xxxxxxxxxxxx>
List-post: <mailto:oracle-l@xxxxxxxxxxxxx>
List-archive: <//www.freelists.org/archives/oracle-l>
X-list: oracle-l
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bertrand Guillaumin
Sent: donderdag 18 februari 2010 15:20
To: robertgfreeman@xxxxxxxxx; TESTAJ3@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE : ok for the last 18 yrs in using oracle I must have been asleep,
"implied database link"
Hi,
Are you sure it exists ? I've made tests and it does not work at least in
10.2.0.3.
sqlplus system/pass@db1
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 18 15:16:38 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> SELECT * FROM DBA_USERS@db2;
SELECT * FROM DBA_USERS@db2
*
ERROR at line 1:
ORA-02019: connection description for remote database not found
sqlplus system/pass@db2
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 18 15:16:38 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
I've even verified in the documentation and I haven't found trace of it.
Best regards,
________________________________________
De : oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] de la part
de Robert Freeman [robertgfreeman@xxxxxxxxx]
Date d'envoi : jeudi 18 février 2010 00:54
À : TESTAJ3@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Objet : Re: ok for the last 18 yrs in using oracle I must have been asleep,
"implied database link"
In my mind, if someone is doing such things in code, this is probably a bad
practice. Also I'm not sure it's a great idea from a security point-of-view to
allow such things. Anyone else have any thoughts here?
RF
Robert G. Freeman
Master Principle Consultant, Oracle Corporation
Oracle ACE
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com
________________________________
From: "TESTAJ3@xxxxxxxxxxxxxx" <TESTAJ3@xxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Wed, February 17, 2010 1:15:18 PM
Subject: ok for the last 18 yrs in using oracle I must have been asleep,
"implied database link"
Ok so a co-worker asks a question about an implied database link, i'm like
"huh".
so a database link is NOT created in the source database but the
userid/password are the same in both source and destination.
take for example
system on db1 and db2 has a password of x12345.
I do a select count(*) from dba_users@db2 while connected on db1 and it
connects and returns a result set w/o a db link being created.
I've been enlightened again of something new about oracle.
so the question posed is, for a named db link you do "close" it, how do you
close an implied link?
joe
_______________________________________
Joe Testa, Oracle Certified Professional
Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715
Interested in helping out your marriage?
Ask me about "Weekend to Remember"
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
