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:
1 | WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="?/network/admin"))) |
to:
1 | WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="$TNS_ADMIN"))) |
Reminder: You need to set your TNS_ADMIN string
Thanks to Adrian Png for the help on this and related Github Issue