Connecting to ADWC With SQL Developer Using a Proxy
SummaryThis post provides step-by-step instructions for connecting to the AWDC with SQL Developer when a proxy server is required.
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 22.214.171.124 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.