RE: ORA-24314 -- Solution Found

Hi All,

The network engineer at the site confirmed that all the ports were open. He played around with it and came up with the following solution.

type in username_at_databasename instead of just username.

I had no problems connecting then.

Hope this helps,

N.

:->-----Original Message-----
:->From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On
:->Behalf Of
:->DENNIS WILLIAMS
:->Sent: 04 November 2003 19:19
:->To: Multiple recipients of list ORACLE-L
:->Subject: RE: ORA-24314
:->
:->
:->Nuala
:-> This was discussed recently on this list, but not to a definite
:->conclusion. The speculation is that is probably a firewall
:->issue. Your VPN
:->probably has to go through a firewall, which is probably
:->open for normal
:->"telnet" type activities like a terminal connection. But
:->connecting to
:->Oracle remotely requires, at a minimum port 1521 to be open
:->(or whatever
:->your listener is listening for). Maybe more if you are
:->running MTS. Some
:->firewalls are reputed to be more "Oracle aware" than others.
:->I would talk to
:->your network engineer. And if you get it working, let us
:->know what you had
:->to do.
:->
:->Dennis Williams
:->DBA
:->Lifetouch, Inc.
:->dwilliams_at_lifetouch.com
:->
:->-----Original Message-----
:->Sent: Tuesday, November 04, 2003 10:49 AM
:->To: Multiple recipients of list ORACLE-L
:->
:->
:->
:->Hello All,
:->
:->I've been connecting to a customers server via VPN.
:->
:->I've been able to connect to the database on the server via
:->SQLPLUS & Toad
:->but when I try to do an import or connect via SQLPLUS /NOLOG I get an
:->ORA-24314 error (no service handler).
:->
:->I've tried looking for an answer on the web but no joy.
:->
:->I rang the dba at the site and got him to connect to the
:->machine (not via
:->VPN) and he had no problems doing the import and connecting
:->via SQLPLUS
:->/NOLOG.
:->I also connected to another box via pcanywhere and had no
:->problems with the
:->SQLPLUS /NOLOG option.
:->
:->What I would like to know is how come some oracle operations are not
:->possible via VPN?
:->
:->Thanks in advance,
:->
:->N.
:->
:->ps oracle version 8.1.7.4 running on Windows 2000 server
:->
:->
:->--
:->Please see the official ORACLE-L FAQ: http://www.orafaq.net
:->--
:->Author: DENNIS WILLIAMS
:-> INET: DWILLIAMS_at_LIFETOUCH.COM
:->
:->Fat City Network Services -- 858-538-5051 http://www.fatcity.com
:->San Diego, California -- Mailing list and web hosting services
:->---------------------------------------------------------------------
:->To REMOVE yourself from this mailing list, send an E-Mail message
:->to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
:->the message BODY, include a line containing: UNSUB ORACLE-L
:->(or the name of mailing list you want to be removed from). You may
:->also send the HELP command for other information (like subscribing).
:->

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nuala Cullen
  INET: ncullen_at_catlogic.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).