Will auto open wallet open the wallet even after "alter system" to close the wallet?
Our DB is POCing an HSM encryption wallet along with auto open wallet. When I "alter system set encryption wallet close..." and then query v$encryption wallet it shows the wallet is open:
SQL> select wrl_type wallet,status,wrl_parameter wallet_location from v$encryption_wallet;
WALLET STATUS WALLET_LOCATION
-------------------- ------------------ --------------------------------------------------
file CLOSED $ORACLE_BASE/admin/$ORACLE_SID/wallet.hsm
HSM CLOSED
The HSM vendor says "...behaviour is expected in case of auto-login wallet any query fired after closing the wallet will automatically open the wallet."
So my question is, if some query trys to access data from a table in an encrypted tablespace will the auto-open wallet cause the HSM wallet to be automatically opened. And could there be some difference in how a local wallet vs a HSM wallet handle this?