Re: dblink not active

Laura Pucci wrote:

> Hallo,
> I have a problem with dblink.I have to "connect" 2 databse through
> dblink.In the past there were no problem because the 2 server was in
> the same domain.Now server2 has been moved and it has anothar domain.
> The old links just exsisting on it, now are NOT ACTIVE on the server2
> that was moved.I try to make them again from sql command that is
> successful but, anyway,the dblink doesn't work.
> I check also the parameter in the init.ora for global_names and it's
> set to false.I check for the connection string on tnsnames and it's
> ok. I have also to do something in sqlnet? Or I have to specify the
> domain name like "db_link.domain.it?" Anyway I can communicate from
> server1 to server2 through sqlplus without any problem because the
> tnsnames is set in the right way ( the connection string on server2
> HAS NOT the suffix "service_name.domanin.it" because with this suffix,
> it didn't work).the same thing for server1, for what, contariwise,it
> is necessary to insert in the tnsnames.ora the suffix
> "service_name.domain.it" for connection with server2. It's a problem
> of domain? anyway it were opened some route of communication (based on
> ip addrees)between server2 and other ip address out of its domain.
>
> I hope You can help me
>
> Thank you so much
> Laura
> Puccica

Post the SQL you used to create the link.

Daniel Morgan Received on Tue Aug 20 2002 - 10:44:46 CDT