Home » RDBMS Server » Networking and Gateways » Oracle ssh remote tunnel - Access database objects via TOAD (Oracle 9i, Windows XP, Unix, Toad 9)
Oracle ssh remote tunnel - Access database objects via TOAD [message #422798] Sat, 19 September 2009 08:02 Go to next message
barnarp
Messages: 1
Registered: September 2009
Junior Member

Hi all,

I want to connect TOAD to Oracle through a firewall (on Unix server behind firewall) using SSH.

I have Oracle 9i client on local windows XP pc.
I am using SSH Tectia client (latest commercial version).

I created a remote tunnel of type TCP with local and destination port to 1521.

I can connect ssh on port 22 through Tectia client to the Unix box, but in the log it fails to create the tunnel.

Do I need a oracle server on my local pc to make this work?

Which port should I run locally, as I think 1521 local might be wrong.

Any help please?
Re: Oracle ssh remote tunnel - Access database objects via TOAD [message #422803 is a reply to message #422798] Sat, 19 September 2009 09:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First to be able to connect to Oracle through SSL you must have purchased the ASO (Advanced Security Option).
Then read:
Oracle Advanced Security Administrator's Guide
Chapter 7 Configuring Secure Sockets Layer Authentication
Chapter 8 Configuring Entrust-Enabled SSL Authentication

But if your purpose is to pass a firewall, the easiest way is to configure Connection Manager.

Regards
Michel
Re: Oracle ssh remote tunnel - Access database objects via TOAD [message #422804 is a reply to message #422798] Sat, 19 September 2009 09:45 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You will take to read the following links:
How to connect 2 ... n SSH Tunnels ?
OTN Thread: ssh tunnel for Oracle client?
Usenet thread: Accessing an Oracle 10g instance through an SSH tunnel using Oracle 10g Connection Manager on Windows

Regards
Michel

Previous Topic: Access oracle through router (merged)
Next Topic: Error: ORA-12541: TNS:no listener while loging in to DB
Goto Forum:
  


Current Time: Thu Mar 28 09:26:24 CDT 2024