I'm using SSH secure tunneling in order to connect to Oracle. The SSH agent is running on Linux Red Hat 9.2 and...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
forwards local TCP/IP port to the remote Oracle listener. When the SSH agent is started (ssh -p ... -L port:remote_ip:port) the connection is ok. But I have to start the SSH in the background! Yep, that's the way SSH works. If you need to have encryption for your SQL*Net connection, I'd take a look at the Advanced Security Option (ASO -- or whatever Oracle may have renamed it to lately) and configure encryption for your client and server. I've seen SQL*Net encryption with the ASO option work very well and it is relatively easy to configure.
If that option doesn't suit you, you might fish around for an SSH guru on a mailing list or newsgroup to give you some tips on starting an SSH tunnel at boot time via some scripting or some such thing.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.