Solved

Remote Access to Oracle database over vpn through cable internet

Posted on 2001-09-14
4
561 Views
Last Modified: 2011-10-03
I have installed safenet vpn and connected to my office from home over cable internet. After setting up the DSN and WINS IP addresses I am connected to the office network. But when I configure oracle alias it does not see the listener. What could be the problem.

TIA
0
Comment
Question by:PingPong
  • 2
  • 2
4 Comments
 
LVL 16

Expert Comment

by:SteveJ
ID: 6484312
First check to make sure that safenet passes port 1521, the SQLnet port . . . verify your tnsnames.ora if you use that to resolve the oracle instance name.

I guess I should first ask what error message are you getting? Listener not found? Unable to connect?

Good luck.
Steve
0
 

Author Comment

by:PingPong
ID: 6484690
Tnsping gives error:
TNS-12541: TNS:no listener
TNSNAMES.ORA shows correct IP address and port 1521.
I am able to ping the IP address of server.
How can I make sure that safenet passes port 1521.
0
 
LVL 16

Accepted Solution

by:
SteveJ earned 50 total points
ID: 6485237
If you are certain about the configuration, and it sounds as though you are, then my GUESS is that port 1521 is being filtered.

To verify this, get a shareware or freeware port scanner from the internet (try http://www.dataset.fr) and scan the open ports on your Oracle server. If port 1521 fails, then it is being blocked and you may need to go to your VPN provider to unblock it.

Is safenet a provider or a piece of software? If it's software is it configurable at the port level?

Good luck.
Steve
0
 

Author Comment

by:PingPong
ID: 6497744
The suggestion helped me work towards the right answer. I figured that the problem was because ping hostname was giving me wrong ip address of my office intranet host. I should have used hostname.company.com as host. Because of wrong IP address obtained via the hostname without suffixing it with company.com, the tnslistener was not found.

However I did use the scanport software to see that the port was not listening on the wrong IP address that was obtained by translating the hostname.

Thanks again for you help.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
I had an issue with InstallShield not being able to use Computer Browser service on Windows Server 2012. Here is the solution I found.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question