RE: Question about db links and tnsnames.ora

From: Hollis, Les <Les.Hollis_at_ps.net>
Date: Fri, 25 Feb 2005 13:45:03 -0600
Message-ID: <FCC960FDB92F5E469A02464FF72872F4043D648E@pscdalpexch50.perotsystems.net>

Also, use global links whenever possible...

i.e. do NOT use the "connect to .... identified by...." syntax.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Friday, February 25, 2005 1:32 PM
To: Paul.Vincent_at_uce.ac.uk
Cc: Oracle-L_at_freelists.org
Subject: Re: Question about db links and tnsnames.ora

You could also create a db link that doesn't require tnsnames.ora.

create database link dbtest connect to scott identified by tiger using
'(description=3D(address=3D(protocol=3Dtcp)(host=3Ddcutil)(port=3D1521))(= connect_d
ata=3D(sid=3Ddv08)))'

Possible, but not normally recommended as it is somewhat inflexible.

Jared

On Fri, 25 Feb 2005 12:45:59 -0000, Paul Vincent <Paul.Vincent_at_uce.ac.uk> wrote:
> (Reposted - previous post had wrong subject line. Sorry!)

>=20

> I'm trying to create a db link from a 9i database to an 8i database on
> another server. I've edited the tnsnames.ora file for the 9i database,
> adding an entry for the 8i database, and created the link on the 9i
> database, using OEM. But when I test the link in OEM (by clicking
> "Test"), the alert box tells me the link is not active. Do I need to
> bounce the 9i database so that it picks up the altered tnsnames.ora
> file? That is, does Oracle only scan the tnsnames.ora file at startup,
> or should it look afresh at the tnsnames.ora file each time name
> resolution is required?

>=20

> Thanks,

>=20

> Paul Vincent
> DBA
> University of Central England
> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

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

Received on Fri Feb 25 2005 - 14:47:34 CST