sqlplus not working with VPN

From: barneytoe <barneytoe_at_gmail.com>
Date: 13 May 2005 09:34:53 -0700
Message-ID: <1116002093.778182.74810@z14g2000cwz.googlegroups.com>

Hello,

I'm using Oracle 10 XP client with oracle 9 server.

Listener is up, according to tnsping.

But I keep seeing 12505 or 12514 errors when I try sqlplus via VPN.

tnsnames.ora:
mydev.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = TCP)

          (Host = 1.2.3.4)

          (Port = 1521)

        )

    )
    (CONNECT_DATA =

       (SID = mydev)
       (SRVR=DEDICATED)

    )
)

sql.net:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) I'm reading about Oracle Connection Manager. Is this something that can help me establish the connection over vpn? If so, I can't find it in Oracle 10 client. Maybe it's now called Net Configuration Assistant?

Any other ideas? Thanks.

chris Received on Fri May 13 2005 - 11:34:53 CDT