Re: DBLink Name has to be the same as SID name?

From: Allan Nelson <anelson77388_at_gmail.com>
Date: Thu, 12 Mar 2009 14:01:11 -0500
Message-ID: <ffb96860903121201x2e10c680ob4508c5a5be6a41d_at_mail.gmail.com>

No, the db link creation statement points to a tns alias in tnsnames.ora. Suppose you had a database sid TST1 and a tnsnames.ora alias named TEST that provided the hostname and listener port for the TST1 sid. You could execute the following:

create database link fred
connect to your_id identified by your_password using 'TEST';

and your link would work. The link fred wants to use the tns alias TEST which points to the hostname, port., sid combination that tns networking needs to get to the listener for the other instance.

select sydate from dual_at_fred;
would verify your link.

Allan

On Thu, Mar 12, 2009 at 1:51 PM, Lyndon Tiu <ltiu_at_alumni.sfu.ca> wrote:

>
> Does the dblink name have to be the same as the SID name?
>
> --
> Lyndon Tiu
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 12 2009 - 14:01:11 CDT