RE: Question about db links and tnsnames.ora
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'Paul.Vincent@xxxxxxxxx'" <Paul.Vincent@xxxxxxxxx>, Oracle-L@xxxxxxxxxxxxx
- Date: Fri, 25 Feb 2005 07:56:19 -0500
Paul,
You do not need to bounce the database. Check your sqlnet.ora file to make
sure that you are using tnsnames, and not anything else.
On the db server, do a 'tnsping tnsentry' to make sure that it works at the
operating system level. If that works, then start sqlplus on your server
and try 'select 1 from dual@dblinkname'.
That should get you started.
Good Luck!
Tom
-----Original Message-----
From: Paul Vincent [mailto:Paul.Vincent@xxxxxxxxx]
Sent: Friday, February 25, 2005 7:46 AM
To: Oracle-L@xxxxxxxxxxxxx
Subject: Question about db links and tnsnames.ora
(Reposted - previous post had wrong subject line. Sorry!)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
