ssh port forward for TNS

http://database.itags.org/oracle/244072/

Secure Connection
 +-->--[SSH]-->--+
 | |
 | |
 ^ |
 | Insecure Connection v
CLIENT-->--> ORACLE

ssh2 -l oracle -L 1521:192.148.1.251:1521 200.10.11.12
 -- -- --
 | | |
 | | |
A LOCAL | |
B INTERNAL IP ORACLE |
C EXTERNAL IP (GATEWAY)

CB

 | Firewall| . . . . .|INTERNET| . . . . . . |Firewall| . . . . . . . . . . |ORACLE|
 | Gateway | |Gateway | 192.148.1.251:1521
 . 200.10.11.12
 .
 .
A .
 |Oracle Client|
 (TNSNAMES.ORA)
 <
SERVICE> =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SID = <
ORCL>)
  )
  )

めも