RE: Question about db links and tnsnames.ora

From: Paul Vincent <Paul.Vincent_at_uce.ac.uk>
Date: Fri, 25 Feb 2005 13:07:07 -0000
Message-ID: <14C5F9616FF43F479F67E41A1DF4D94A050FEC92@exchangeb.staff.uce.ac.uk>

I just looked carefully one more time and found an error in my tnsnames.ora entry. Works fine now. Sorry if anyone wasted their time looking at this one. My stupid blunder - my brain needs the weekend, I think!

Cheers,

Paul Vincent
DBA
University of Central England

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paul Vincent
> Sent: 25 February 2005 12:46
> To: Oracle-L_at_freelists.org
> Subject: Question about db links and tnsnames.ora

> =20
> =20

> (Reposted - previous post had wrong subject line. Sorry!)

> =20

> I'm trying to create a db link from a 9i database to an 8i=20
> database on
> another server. I've edited the tnsnames.ora file for the 9i=20
> 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=20
> 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

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

Received on Fri Feb 25 2005 - 08:10:11 CST