| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] sqlplus through VPN not work, but tnsping work
Dear Dba1
Many of us have SQL*Plus working through the VPN. Unfortunately I don't
think anyone on the list is a network engineer that understands the details
of VPN configuration. My understanding is that the problem is usually which
firewall ports are open, and that more than 1521 are required. Here is a
link to a discussion that occurred on this forum.
http://www.orafaq.net/maillist/oracle-l/2003/10/24/2077.htm
Another thing to consider is that port 1521 is very well known to hackers. Ask your network administrator if that port is truly open to the Internet, because if it is, you'll want to verify your Oracle security.
Dennis Williams
DBA
Lifetouch, Inc.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of dba1 mcc
Sent: Wednesday, December 15, 2004 7:55 PM
To: oracle-l_at_freelists.org
Subject: [Q] sqlplus through VPN not work, but tnsping work
I tried to access our ORACLE server through VPN. The problem I have is "sqlplus" not work, but tnsping work. Network engineer told me he did open port 1521 for me.
if I use ORACLE "tnsping" on PC side, it will response back. Server side have message "15-DEC-2004 20:36:38 * ping * 0" on listener.ora file.
If I use "sqlplus" on PC, there is message pop-up:
ORA-12535: TNS: Operation time out
there is NO message on ORACLE server side listener.ora file.
Anyone know why?
Thanks.
 |
 |