Re: SQL*Net from one server to another

To connect to a remote database the tnsnames.ora file on the Server must have the entry ( in your case other_server) -- So you could then use:
create database link my_other_one connect to user identified by pass using 'other_server';

Also, you could, in SqlPlus on the server, do a connect me_at_other_server

"Harry Boswell" <staryeti_at_bellsouth.net> wrote:

>
>"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
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Mon Jun 25 2001 - 14:29:14 CDT