I installed Oracle wallet to access passwordless to the remote databases, so I could do backups without specifying the password on any script.
The sqlnet.ora has the following information concerning the wallet:
WALLET_LOCATION = (SOURCE = (METHOD = reg) (METHOD_DATA = (KEY = DEFAULT))) SQLNET.WALLET_OVERRIDE = TRUE SSL_CLIENT_AUTHENTICATION = FALSE
The other day, I got the need of giving access to remote databases to another windows user, so he could run a refresh schema/database script.
He was getting the following error when trying to access any database:
ORA-12578: TNS:wallet open failed
While I could just have set a different TNS_ADMIN variable pointing to a sqlnet.ora with
SQLNET.WALLET_OVERRIDE = FALSE
this was not the solution for him to use an automatic script.
The solution was to export/import the following branch of the registry from my windows user to the other windows user:
Note that these entries contain the encrypted password to the wallet, allowing the user to add/remove/modify/see the contents, including passwords, of the current wallet.