At my company we have a strict security policy and to access my server i need to use different jumpboxes like this:
- jump_box_1 (has public access)
- jump_box_2 (has private access)
- my_server (here is my database)
- public_server (has access to my_server)
So far i managed to access my_server starting from jump_box_1 with putty and multiple tunnels like this:
1. start a ssh command to open a port on jump_box_1:
ssh -L 2222:jump_box_2:22 my_user@jump_box_1
2. start putty session configured like this(this 3 pictures are from the same connection):

and now i can access my database with:
host: localhost
port: 1521
What i want is to get rid of putty and use only ssh commands so in the end to automate all of this.
Thank you.