Re: What are the ports involved with DB Link

From: Chet Justice <chet.justice_at_pfsf.org>
Date: 19 Apr 2005 19:41:20 -0700
Message-ID: <1113964880.422603.320460@f14g2000cwb.googlegroups.com>

ryerras wrote:
> Hi All,
> We have an interesting problem. One of our database is trying to talk
a
> database on another network. The other networks security is very
> stringent, so they just opened the port 1521 for us to be able to
> connect. We are able to connect to the "Other" database successfully
in
> sqlplus. But when we try to do some operation with dblink, its not
> working. It says the tns operation timed out. So, my question is, are
> there any other ports involved with db link communication. Does db
link
> use other ports than 1521 to do a successful operation like select
from
> a table on the remote database. If anybody knows anything about it,
> please let me know.
>
> Thank you

If you can connect via SQL*Plus then perhaps your db link is incorrect. Could you post the CREATE DATABASE LINK statement and the referenced tnsnames entry?

chet Received on Tue Apr 19 2005 - 21:41:20 CDT