I am running an development Oracle DB on a computer in my network on port 1521. Our production environment is running on a different server in a different network. I want to copy my database via SQLDeveloper, so I have to connect to my development DB from the production server.
As our customer is very strict with network regulations, only ports 80 and 443 are open for outgoing connections in this network. Opening another port is not an option. Connecting via VPN from our development network to the production network is as well not an option, as the VPN network cannot access the database server directly (we are only able to connect to a machine in the network, which is able to connect to the database).
Now, I have tried the following: I enabled port forwarding on our Cisco Meraki firewall from our public development network IP on port 80 to my development machine port 1521. Test-NetConnection does work, however, the tnsping does fail.
Is there any option to connect to my database?
As the comments suggested, I have talked to the security guys and we found a solution which satisfied all needs.