Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Net from one server to another
"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