Database Security Products (MOSC)

MOSC Banner

Will auto open wallet open the wallet even after "alter system" to close the wallet?

edited Feb 1, 2017 1:18PM in Database Security Products (MOSC) 1 commentAnswered ✓

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center