If you want to connect to a Autonomous Transaction Processing (ATP) database in the Oracle Cloud (OCI) using SQL*Plus, SQLcl, or SQL Developer you need to download a Credentials Wallet. If you’re unaware of this process please read this blog before continuing.
When connecting to to the database you may get the following error:
ORA-28759: failure to open file. I got this error when connecting using a Docker container for SQLcl. Note here are some docker images for both SQLcl and sql*plus
To resolve this issue you just need to modify the
sqlnet.ora file (in the downloaded zip file) and change:
WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="?/network/admin")))
WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="$TNS_ADMIN")))
Reminder: You need to set your