OraFAQ Forum: Networking and Gateways » Oracle ssh remote tunnel

Home » RDBMS Server » Networking and Gateways » Oracle ssh remote tunnel - Access database objects via TOAD (Oracle 9i, Windows XP, Unix, Toad 9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle ssh remote tunnel - Access database objects via TOAD [message #422798]

Sat, 19 September 2009 08:02

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?

Report message to a moderator

Re: Oracle ssh remote tunnel - Access database objects via TOAD [message #422803 is a reply to message #422798]

Sat, 19 September 2009 09:35

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Oracle ssh remote tunnel - Access database objects via TOAD [message #422804 is a reply to message #422798]

Sat, 19 September 2009 09:45

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 21 07:42:49 CST 2025