Re: Connection to Oracle Database Problems

I'd check the listener.log file for attempted connections from the Internet at large that have already occurred. That database may already be owned by others.

Check out some papers up on Pete Finnigan's site: http://www.petefinnigan.com/orasec.htm

Personally, I'd setup an ssh tunnel at the bare minimum. This would accomplish several objectives:

authentication by more than just an oracle password secure the network traffic
allow for Oracle client dedicated server sessions to be redirected via the ssh tunnel.

This is actually surprising simple of a setup.

1. download Cygwin: http://cygwin.com/
2. configure an OpenSSH dæmon: http://ist.uwaterloo.ca/~kscully/CygwinSSHD_W2K3.html
3. fire up a putty client: http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html
4. configure port forwarding in the putty client (loopback to remote)
5. configure a tnsnames.ora entry to resolve to a port on the loopback interface
6. connect to the remote server via putty
7. connect to the remote oracle database instance with your oracle client software of choice via the ssh tunnel.
8. ?????
9. Profit!!

This can also be configured by spending tens of thousands of dollars on hardware, networking expertise to install a site to site VPN tunnel.

-bdbafh Received on Fri Dec 02 2005 - 13:54:03 CST