Re: SQL*Net from one server to another

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 25 Jun 2001 19:01:30 +0200
Message-ID: <tjerf7rci5n675@beta-news.demon.nl>

"Harry Boswell" <staryeti_at_bellsouth.net> wrote in message news:97275eac.0106250857.38b9419_at_posting.google.com...
> I've got two Solaris servers running Oracle8 dbs; WinNT and
> Win98 clients using Net80 to access the servers. All are working
> fine going from Win clients to either server. But if I try to
> connect from one server to another, using a database link
> or just sqlplus llll/pppp_at_other_server, I get "cannot resolve
> service name" errors. Do I need to do something more to get
> outgoing SQL*net running on the servers?
>
> Thanks,
> Harry Boswell

The other_server service definition needs to be in the tnsnames.ora of the server hosting the database. Database links are server to server comms.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Jun 25 2001 - 12:01:30 CDT