?
Solved

Remote Access to Oracle database over vpn through cable internet

Posted on 2001-09-14
4
Medium Priority
?
565 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
For many of us, the  holiday season kindles the natural urge to give back to our friends, family members and communities. While it's easy for friends to notice the impact of such deeds, understanding the contributions of businesses and enterprises i…
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…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Suggested Courses

777 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