Solved

Remote Access to Oracle database over vpn through cable internet

Posted on 2001-09-14
4
560 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Cisco MRA Phones 4 70
Radius Debug Error 16 60
You are currently not connected to any networks windows 10 5 113
Need help with VLAN issue 6 42
Data center, now-a-days, is referred as the home of all the advanced technologies. In-fact, most of the businesses are now establishing their entire organizational structure around the IT capabilities.
Most of the applications these days are on Cloud. Cloud is ubiquitous with many service providers in the market. Since it has many benefits such as cost reduction, software updates, remote access, disaster recovery and much more.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

863 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

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now