Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Net from one server to another

Re: SQL*Net from one server to another

From: Harry Boswell <staryeti_at_bellsouth.net>
Date: Mon, 25 Jun 2001 13:26:56 -0500
Message-ID: <9h7vf0$65b$1@nntp.msstate.edu>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tjerf7rci5n675_at_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.
>

It's there. And I can connect using that definition from the Win clients, just not
from the other server. That's why I wondered if there was any further Net80 definition that had to occur on a server to allow it to also be a client.

Thanks,
Harry Received on Mon Jun 25 2001 - 13:26:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US