Also, use global links whenever possible... i.e. do NOT use the "connect to .... identified by...." syntax. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still Sent: Friday, February 25, 2005 1:32 PM To: Paul.Vincent@xxxxxxxxx Cc: Oracle-L@xxxxxxxxxxxxx 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@xxxxxxxxx> 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 > -- > //www.freelists.org/webpage/oracle-l >=20 --=20 Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l