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 [EMAIL PROTECTED] instead of just username. I had no problems connecting then. Hope this helps, N. :->-----Original Message----- :->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] :->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. :->[EMAIL PROTECTED] :-> :->-----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: [EMAIL PROTECTED] :-> :->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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).