Configuring the secure external password store through sqlnet.ora, entry seen in v$encryption_wallet
We have a system that detects whether the TDE wallet is configured or not by querying v$encryption_wallet. However, when we configure a secure external password store using sqlnet.ora, we observe that v$encryption_wallet is still being populated.
We configured the secure wallet location in sqlnet.ora using the following steps:
cat $ORACLE_HOME/network/admin/sqlnet.ora
SQLNET.ALLOWED_LOGON_VERSION_SERVER=11
WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = /work/sqlnet/wallet)))
We created the wallet using the command:
orapki wallet create -wallet /work/sqlnet/wallet/ -auto_login
Upon querying v$encryption_wallet, we see the following entry: