Connecting to ADWC With SQL Developer Using a Proxy

Summary

This post provides step-by-step instructions for connecting to the AWDC with SQL Developer when a proxy server is required.

Content

Connections to the ADWC use port 1522, but many organizations have networks where 1552 is not open to the internet.  When this is the case, a proxy server is typically used to connect to the internet (usually using port 80).  That's how browsers typically connect to the internet from a corporate network.

At present, a SQL Developer 'Cloud PDB' connection type does not support the use of a proxy (because proxies are not supported by the 12.2.0.1 JDBD drivers).  A proxy can be used when the TNS connection type is used and SQL Developer is configured to use a 'OCI/Thick' connection type.  Step-by-step instructions for setting up this connection follows.