Re: What are the ports involved with DB Link

From: ryerras <kumarreddi_at_gmail.com>
Date: 20 Apr 2005 10:59:00 -0700
Message-ID: <1114019940.165091.274130@g14g2000cwa.googlegroups.com>

Yes I am able to connect to the server DB02 from DB01 through sqlplus successfully and do the operations. As others have suggested dblink is the only issue. I create the dblink with the following syntax

create database link XXXEXT_XXX
connect to XXXX
identified by XXXX
using 'tnsentry';

After the link is created, I do test the link as follows select 1 from dual_at_XXXEXT_XXX;

And I get a tns timeout error.

I am sure there is no syntax error with the db link. Its so puzzling for me why I am able to do regular select operations connecting directly to the DB02, but not through dblink between DB01 and DB02. I really appreciate you guys trying to help me solve the issue Received on Wed Apr 20 2005 - 12:59:00 CDT