| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Oracle SQLNET through DSL connection
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
 |
 |