Connecting to Oracle Cloud Database ORA-28759: failure to open file

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