oracleclientoracle-autonomous-dbtnsping

Connect to Oracle Autonomous Database without a wallet not working

I can't connect to Oracle Autonomous Database using Oracle Client without a wallet.

I am following the instructions as per the documentation. I have configured the network by disabling mTLS. Also, added my IP in Access Control List.

Oracle Autonomous Database configuration with mTLS disabled

I also configured my TNSNAMES.ora file with the data provided by the portal (port 1521).

print of TNSNAMES.ora file with Oracle configurations

When testing the connection with the TNSPING command, it fails.

CMD image with TNSPING error output

If I add the wallet to TNSNAMES, the connection occurs successfully.

CMD image with TNSPING success output

But Oracle's documentation says that the wallet should not be necessary in this configuration.

Image from Oracle page stating that wallet is not required

What am I missing here?

Solution

  • Apparently, it is a bug, or incompatibility, of the Oracle Client version, despite having installed the latest version available.

    I applied a database patch to the client (patch p37500148_210000_WINNT), which is not recommended by Oracle, and the connection started working correctly.