Unanswered: Configuring Oracle iSQLPlus for public access
First year touching the Oracle10g Database and I'm having fun but also a few issues:
Here's the problem, I have created a database for a course and now I have these 3 friends of mine who are helping me do this job and a teacher that i want to be able to help me with minor problems, here's the catch we are all far away from eachother and neither of us have static ip's (besides my teacher) so we find a way around, we created a VPN with Hamachi and now we can work as if we were on a LAN (my home pc being the server and everyone else connecting as a client), problem is, I can't seem to find a way for them to connect to my database or even see the the iSQLPlus webpage that i'm using for testing scripts.
Have you tried configuring iSQLPlus to run on the 220.127.116.11 address? I am not a network guy, so this is a stretch without testing. However, when we set up IBM HACMP clusters, we configure Oracle to listen on the virtual address. It seems that you want to listen on the VPN address and not the 10.10.10.10 address.
Hey there! Thanks for the quick reply buckeye234, I am indeed trying to make oracle listen on the base ip instead of listening in an inner network (10.10.10.10), four questions has come to stage when i saw your post (sorry if i'm being annoying)
1st - How can I change the Oracle default listening network/port ?
2nd - Is it a web server problem? If so where are the options for the apache server or config files ?
Beyond this point is just curiosity...
3rd - Why is Oracle installed by default in the sub-network ?
4th - Why is it needed to create a loop-back network when installing the db ?
By the way i forgot to say that '18.104.22.168' is the virtual address given by Hamachi for my machine (so my real ip is mapped into this one)
Thanks 2 everyone that spent time reading this posts ...