Oracle jdbc drivers 19.3.0.0 and up connection issue workaround

Since Oracle made significant code changes in the jdbc drivers for 19.3.0.0 and upwards. There is an issue with connecting to Oracle databases with SQLDeveloper or using java code to connect to an Oracle databse.

Older drivers seem to work correctly with ZPA.

Work arounds

For SQLDeveloper on macOS place the following entry in sqldeveloper.conf or product.conf file

AddVMOption -Doracle.net.disableOob=true

For java code or java system properties run the following:

oracle.net.disableOob=true

Alternatively, if you put your code in a Docker container, this also alleviates the issue.