Paul, I'm trying to remember what OS you run oracle on. If its win32, download the utility filemon from Sysinternals and filter to just the %ORACLE_HOME%\network\admin directory ... and you'll have your answer. procviewer will list files currently open, but doesn't have the logging features that filemon does. Paul On Fri, 25 Feb 2005 12:24:49 -0000, Paul Vincent <Paul.Vincent@xxxxxxxxx> wrote: > 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? > > Thanks, > > Paul Vincent > DBA > University of Central England > -- > //www.freelists.org/webpage/oracle-l > -- #/etc/init.d/init.cssd stop # f=ma, divide by 1, convert to moles. -- //www.freelists.org/webpage/oracle-l