Re: sql developer, jump box, rsa

Hi Andy,

Have you tried tunneling? Something like:

ssh mgogala_at_jump.box.net -L 1521:localhost:1521

After that, you can try sqlplus scott/tiger_at_localhost:1521/service_name

The problem with that strategy is that you will have to log in manually from a terminal window before you can use the connection. Also, admins sometimes disable ssh tunneling. If that is the case, you  will not be able to connect.

So, this one is kind of out there.  I am trying to figure out how to connect sql developer to an oracle database through a jump box, when the jump box uses and RSA key (rotating key).  I figured out how to do it using both a private key file, and a static password.  But I cant figure out any way to do it using a rotating key.  The jump box receives the username, then prompts for a PASSCODE (in caps) when I log in manually, so I suspect that is part of the issue if sql developer is waiting for a password prompt instead of PASSCODE.

--

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com