Yes. the tnsnames are correct on the db01 server. I am aware that
dblink's are between server to server. I am able to connect to DB02
from the DB01 server through sqlplus. So, i know that tnsnames names
are right. The only problem comes with the dblink. Can anybody else
please
Frank van Bortel wrote:
> ryerras wrote:
> > 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
> >
> Still... no platform.
> If windows, and multiple installs, you may have your path
> setting off: sql used is from another setup than the database.
>
> Remember, database links are server/server connections, that is,
> DB01 is the *client* to DB02. Hence, the tnsnames.ora on the DB01
> side must be OK.
> Still assuming you used sql*plus on the DB01 machine.
> If not - you missed the point made earlier.
>
> --
> Regards,
> Frank van Bortel
Received on Thu Apr 21 2005 - 07:27:42 CDT
