Solved

Remote Access to Oracle database over vpn through cable internet

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Some time ago I was asked to set up a web portal PC to put at our entrance. When customers arrive, they could see a webpage 'promoting' our company. So I tried to set up a windows 7 PC as a kiosk PC.......... I will spare you all the annoyances I…
Don’t let your business fall victim to the coming apocalypse – use our Survival Guide for the Fax Apocalypse to identify the risks and signs of zombie fax activities at your business.
Viewers will learn how to connect to a wireless network using the network security key. They will also learn how to access the IP address and DNS server for connections that must be done manually. After setting up a router, find the network security…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

759 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

21 Experts available now in Live!

Get 1:1 Help Now