vorax ssh tunnel

[krzysztof cierpisz]

Is it possible to connect to Oracle using vorax when SSH Tunnel is mandatory for my connection?

currently for one of our databases we have to use SSH Tunnel. 

In SQL Developer it is under "Connection Type" => "SSH"  --> SSH Connection is first established in "SSH Hosts" (SQLdeveloper: View -> SSH)

thanks,

Chris

[Alexandru Tică]

Hi Chris,

It's possible as long as you setup the SSH tunnel yourself. For example:

ssh -N -L1522:db_host:1521 oracle@host

ORADB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oradb) ) )

Alec.

--
You received this message because you are subscribed to the Google Groups "vorax-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vorax-discus...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

talek

[talek]

Hi Chris,

It's possible as long as you setup the SSH tunnel yourself. For example:

ssh -N -L1522:db_host:1521 oracle@host

ORADB =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))

    (LOAD_BALANCE = yes)

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = oradb)

    )

  )

Alec.

[chris]

hi,

that's good news although I am having issue with connection.

in SQLdev I have following settings:
SSH name: 'prd'
host: 'db_prod.domain'
port: '22'
username: 'userA'

Connection name: 'prd_userA'
username: 'userA' (user in SSH host and db
instance are the same)
password: 'pass'
connection_type: 'SSH'
port_forward: 'prd'
service_name: 'service.domain'

the connection in SQL developer works.


Now this is what I tried so far to manually create tunnel and use vim:
1. entry in tnsnames.ora
PRD =

(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)

(SERVICE_NAME = service.domain)
)
)

$ ssh -N -L1522:service.domain:1521 userA@db_prod.domain
it asks for password and I think the connection is established

then I go to Vim with Vorax:
I create connection profile:
userA@PRD
(when connecting providing db password)
immediately I get:
ERROR:
ORA-12537: TNS:connection closed

And in terminal window with opened ssh connection:
channel 2: open failed: administratively prohibited: open failed


I am not sure if I missed something (ssh command?) or somehow it's
prohibited to connect like that?

Would you be able to help me please to try something more?

thanks,
Chris

> --
> You received this message because you are subscribed to the Google Groups
> "vorax-discuss" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to vorax-discus...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.



--

Krzysztof Cierpisz

..........................
gg: 2349371 ..............
mobile: (+49 160) 90891892
phone: (+49 89) 97605686

[talek]

How about:

ssh -N -L1522:db_prod.domain:1521 userA@db_prod.domain 

Alec.

> email to vorax-discuss+unsubscribe@googlegroups.com.

[chris]

that worked,

many thanks,
Chris

>> > email to vorax-discus...@googlegroups.com.

>> > For more options, visit https://groups.google.com/d/optout.
>>
>>
>>
>> --
>> Krzysztof Cierpisz
>>
>> ..........................
>> gg: 2349371 ..............
>> mobile: (+49 160) 90891892
>> phone: (+49 89) 97605686
>

> --
> You received this message because you are subscribed to the Google Groups
> "vorax-discuss" group.
> To unsubscribe from this group and stop receiving emails from it, send an

> email to vorax-discus...@googlegroups.com.