Transparent Data Encryption does not seem to be working in 12c RAC environment.
These are the steps i followed.
Step 1:
Created a ASM directory
ASMCMD> pwd
+DATA/SOTST/WALLET
Step 2:
Edited sqlnet.ora with the following lines
ENCRYPTION_WALLET_LOCATION=
(SOURCE=
(METHOD=FILE)
(METHOD_DATA=
(DIRECTORY=+DATA/SOTST/WALLET)
)
)
Step 3:
ADMINISTER KEY MANAGEMENT CREATE KEYSTORE '+DATA/SOTST/WALLET1' IDENTIFIED BY encWallet;
Step 4:
ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY encWallet;
Step 5:
SQL> ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE FROM KEYSTORE '+DATA/SOTST/WALLET1' IDENTIFIED BY encWallet;
keystore altered.
SQL> select * from V_$ENCRYPTION_WALLET;
WRL_TYPE
--------------------
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS WALLET_TYPE WALLET_OR FULLY_BAC
------------------------------ -------------------- --------- ---------
CON_ID
----------
ASM
+DATA/SOTST/WALLET1/
OPEN_NO_MASTER_KEY PASSWORD SINGLE UNDEFINED
0
Issue 1: WALLET_TYPE does not change to AUTO_LOGIN
Step 6:
SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY encWallet WITH BACKUP;
ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY encWallet WITH BACKUP
*
ERROR at line 1:
ORA-28374: typed master key not found in wallet
Issue 2: ORA-28374: typed master key not found in wallet
SQL> select CDB from v$database;
CDB
---
NO
Could some one help me to debug this issue please?