Auto-login Isn't Working for OKV / HSM Wallet (Doc ID 2708178.1)

Last updated on JANUARY 10, 2023

Applies to:

Symptoms

I have 18.4 OKV that is integrated with 12.1.0.2 RAC 2-node DB.
The auto-login isn't working with Database instance restart but I can open the OKV wallet manually by executing 'ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY <endpoint password>'

SELECT * FROM gv$encryption_wallet;

INST_ID WRL_TYPE WRL_PARAMETER STATUS WALLET_TYP WALLET_OR FULLY_BAC CON_ID
------- -------- ---------------------------------------------------------------------- -------------------- ---------- --------- --------- ----------
1 FILE /DATA/WALLET/tde_seps/ NOT_AVAILABLE UNKNOWN SECONDARY UNDEFINED 0
1 HSM CLOSED UNKNOWN PRIMARY UNDEFINED 0
2 FILE /DATA/WALLET/tde_seps/ NOT_AVAILABLE UNKNOWN SECONDARY UNDEFINED 0
2 HSM CLOSED UNKNOWN PRIMARY UNDEFINED 0

SQL> administer key management set keystore open identified by "endpoint_pwd";

keystore altered.

SQL> SELECT * FROM gv$encryption_wallet;

INST_ID WRL_TYPE WRL_PARAMETER STATUS WALLET_TYP WALLET_OR FULLY_BAC CON_ID
------- -------- ---------------------------------------------------------------------- -------------------- ---------- --------- --------- ----------
1 FILE /DATA/WALLET/tde_seps/ OPEN_NO_MASTER_KEY AUTOLOGIN SECONDARY UNDEFINED 0
1 HSM OPEN HSM PRIMARY UNDEFINED 0
2 FILE  /DATA/WALLET/tde_seps/ OPEN_NO_MASTER_KEY AUTOLOGIN SECONDARY UNDEFINED 0
2 HSM OPEN HSM PRIMARY UNDEFINED 0

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.