Remote Oracle access over the Internet

Posted on 2007-07-20
Medium Priority
Last Modified: 2013-12-18
Hello guys,

I've been extremely busy these last two months at work, so I don't have time to come here to help others or research for information. Today I received a call from one of my former instructors who is trying to setup an Oracle database to be accessed over the internet by his students. I have pretty much work with databases connected over a local network, but never over a global one.
All I need is a quick link or steps on how to conduct this setup, including: necessary hardware, software, firewall settings, etc., so my instructor can get his setup up-and-running without calling me...

Thanks a bunch!

Question by:paquicuba
  • 5
  • 2
LVL 13

Expert Comment

ID: 19538072
This will be a strange thing if i say but it works well in my setup over internet.
First your Instructer should download :
*.Please ask your instructor to have internet connection in the server before installatiing the below things.

*.This is a free ware available for both windows and linux.
*So once download this.He should install it in his machine.
*.Once installation in done.He will get a messenger kind of stuff.There will be a power button kind of stuff in the left bottom.
*.when we click that it will ask you for name ( i.e Server ) naming we can giv .then click next i will assign a public ip in that system.Then you can click the create new network option and create a network name as like you wish.
*.Now open net manager in your servers oracle database and add this ip address ( something with 5........ ) and restart the listener.now you will find the listener status with this hamachi ip address
*.once you create you network,ask all your students to download the same software and install it on their machines
*.Once they install ask them to join into your network,you should provide them the network name and password.so that they can join the network.
*.They should have oracle client and configure the tns names with the server hamachi ip address.
*.Then if they try connecting with the user names they will find connected and using this hamachin we can do file sharing also chat.

If you want i can provide a snapshots how to configure.
LVL 13

Expert Comment

ID: 19538080
Ask everyone to select Basic free while installating
LVL 13

Expert Comment

ID: 19538296
You can find the installation snapshot in


password for downloading : oracle
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 23

Author Comment

ID: 19548943
Thanks a bunch anand. I really appreciate your input. I'll look into this and I'll let you know...
LVL 13

Expert Comment

ID: 19554168
you are welcome paq
LVL 13

Accepted Solution

anand_2000v earned 2000 total points
ID: 19554172
only if you had put the question in Oracle TA......Waiting to become a Wizard soon.
LVL 23

Author Comment

ID: 19762037
Thanks a bunch anand 2000v!

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses
Course of the Month14 days, 17 hours left to enroll

839 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