Re: SQL*Net from one server to another

Check to see if there is a
NAMES.DEFAULT_DOMAIN = world
entry in your sqlNet.ora ( on the server) . If your tnsnames.ora alias is actually server2.world and you do not have that line in sqlNet.ora you need to specify the domain...so : create database link my_other_one connect to user identified by pass using  'other_server.world';

( If your domain is other than .world, substitute as needed)

"Harry Boswell" <staryeti_at_bellsouth.net> wrote:

>
>"TurkBear" <noone_at_nowhere.com> wrote in message
>news:a44fjtov2mt2600ni0nqu136b0imt7sgid_at_4ax.com...
>>
>> 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';
>>
>
>What role does sqlnet.ora play in this?
>
>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 - 15:05:02 CDT