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
Received on Tue Dec 03 2002 - 15:42:44 CST
