dblink not active

From: Laura Pucci <l.puccica_at_inwind.it>
Date: 20 Aug 2002 02:23:55 -0700
Message-ID: <9e68938c.0208200123.18f20046@posting.google.com>

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 Received on Tue Aug 20 2002 - 04:23:55 CDT