Re: HELP ---- Changes needed to SQLNET for 2 Oracle Instances (different boxs) to communicate <<=====================================================================

Have you check the tnsnames.ora file in the box A? You have to include the name of the SID in box B in the tnsnames.ora file (if you are not using Oracle Names). You need the name set in order to create the dblink.

also make sure that box A can talk to box B in the /etc/host file. (<- I hope I am right about this.. not very sure)

if you still cannot get it to work. Also check the protocol.ora and sqlnet.ora files for their setting.

In order to check if the sqlnet is working. Try this tnsping <hostname>

Winnie LIu

A Ustby wrote in message <6t40jv$a5h$1_at_newsread1-mx.centuryinter.net>...
>Hi,
>
>
>Help I need to talk to someone about SQLNET.
>
>I have 2 existing boxs that are running Oracle 7.3 instances.
>I would like to get box A communicating with box B Oracle instance
(DBLINK).
>
>These instances are fully functioning.
>
>What changes do I have to make to box A SQLNET files to pull this off ???
>
>If you could help, please EMail: ALU_at_DAIRYNET.COM
>
>Thanks for any and all help........... Art
>
Received on Tue Sep 08 1998 - 22:02:30 CDT