Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle SQLNET through DSL connection
Not a silly question; I tried both, as that can be problematic. I
can ping the host by both name and ip. I used ip in tnsnames.ora just
to eliminate that. Also not mentioned is the fact that I've verified
that I'm using the correct tnsnames.ora file, since I have multiple
ora homes on the problem machine.
Time to be more specific - I just tested dialup on private network (our RAS dialin), dialup on public network (using vpn), and DSL (public network, using vpn). Both VPN flavors fail, while dialin over RAS (private network, no vpn involved) works. So VPN is clearly the common factor in the problem, not DSL (as I first thought).
I turned on trace and log in my sqlnet.ora file. Here's the log of a failed sqlplus connect: (took out ip and userid for security):
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows:Version 8.1.7.0.0 - Production
nncpldf_load_addrfile: NOTE: FILE CONTAINS ERRORS, SOME NAMES MAY BE
MISSING
ntt2err: soc 284 error - operation=1, ntresnt[0]=505, ntresnt[1]=60,
ntresnt[2]=0
nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60,
nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
nioqper: error from nscall nioqper: nr err code: 0 nioqper: ns main err code: 12535 nioqper: ns (2) err code: 12560 nioqper: nt main err code: 505 nioqper: nt (2) err code: 60 nioqper: nt OS err code: 0
The relevant error, I think, is the 'nsopen: unable to open transport'. My guess is that, while I can ping, and access all my corporate network resources on the target network (i.e., vpn is working fine), somehow sqlnet is not getting a connection.
This could indicate (maybe) that our firewall/vpn host is blocking this traffic, but ... as mentioned, I can fire up an adjacent laptop here at home and repeat the test with success - so this is definitely a client side problem. The two laptops are very similarly configured; both have local forms and local databases; both use same version of vpn; use same uerid/pwd to get into vpn (and into private network).
I did a 'rebind adapters' command in the vpn software; no change.
Any thoughts? Thanks, Chris
On Tue, 3 Dec 2002 21:42:44 -0000, "David Sharples" <david.sharples3_at_ntlworld.com> wrote:
>silly question, but are you using hostnames in your tnsnames.ora file or ip
>addresses
>if you are using hostnames do you have dns set up?
>
>
>"Chris S" <seebelow_at_nowhere.com> wrote in message
>news:p9f8sugpcdvh1qh65lhf4m9f2dg577vr2p_at_4ax.com...
>> I install and config all our oracle databases at work, and have become
>> pretty adept at solving sqlnet connectivity issues. I also personally
>> have 3 computers at home which connect to our work network, via vpn,
>> and which run SQLNET connections successfully (oracle forms, sql*plus,
>> etc).
>>
>> I've recently built a new laptop 'image' for use by all our sales
>> guys, which has loaded on it Oracle 8.1.7 db, and 6i forms. Works
>> great. But ... if I take this particular laptop home, and configure
>> it to work over my DSL modem, it won't work. Neither SQL*Plus,
>> TNSPING, nor ODBC will work. I can 'ping' the remote server, and I
>> can run various other 'stuff' like outlook/exchange connections, etc -
>> so the network is clearly visible.
>>
>> I even took an older laptop (different image but similar config with
>> 8.1.7, forms, etc) and tested it, and it works. I then loaded 'oracle
>> client' on a home machine, one that had never seen Oracle software
>> before, and got it to talk sqlnet to my work servers via DSL no
>> problem (sql plus, odbc, etc).
>>
>> This new, problematic image can connect to any office-network database
>> when directly connected to the network via ethernet. And it can
>> connect to the local database at all times.
>>
>> I've read posts where users can get 'simple' queries to work but not
>> complex ones, and it was due to MTU settings; but in my case,
>> 'nothing' is working. There's no firewall on this laptop. We use
>> Checkpoint VPN (but that's common to all environments, working and
>> non-working). My DSL is from PacBell, using Enternet 300 software
>> v1.5.
>>
>> Any ideas where to start looking? Thanks, Chris
>> ===========
>> Reply to cschofie at domain dot com
>> Change domain to attbi - Thanks
>