Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Remote Access to Oracle database over vpn through cable internet

Posted on 2001-09-14
4
Medium Priority
?
572 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 150 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

This article is a collection of issues that people face from time to time and possible solutions to those issues. I hope you enjoy reading it.
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
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…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Suggested Courses

610 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