My Oracle Support Banner

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

Last updated on SEPTEMBER 08, 2020

Applies to:

Advanced Networking Option - Version 12.1.0.2 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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