Oracle-L: RE: ORA-24314

From: DENNIS WILLIAMS <DWILLIAMS_at_lifetouch.com>
Date: Tue, 04 Nov 2003 11:19:26 -0800
Message-ID: <F001.005D590D.20031104111926@fatcity.com>

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,

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). Received on Tue Nov 04 2003 - 13:19:26 CST