RE: Question about db links and tnsnames.ora
- From: "Paul Vincent" <Paul.Vincent@xxxxxxxxx>
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 25 Feb 2005 13:07:07 -0000
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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Paul Vincent
> Sent: 25 February 2005 12:46
> To: Oracle-L@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
> =20
> =20
--
//www.freelists.org/webpage/oracle-l
Other related posts:
