Hello All -
I am trying to create TDE example .
I was able to create a keystore ; but when I open the key store , I am
getting ORA-28367.
What am I missing here ? Thanks very much in advance.
SQL> select * from v$version ;
BANNER
CON_ID
--------------------------------------------------------------------------------
----------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit
Production 0
PL/SQL Release 12.2.0.1.0 - Production
0
CORE 12.2.0.1.0 Production
0
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
0
NLSRTL Version 12.2.0.1.0 - Production
0
SQL> administer key management create keystore
'C:\app\oracle\virtual\admin\db1cdb\encryption_keystore' identified by
Ora12cR2PasswdEncryption;
keystore altered.
C:\app\oracle\virtual\admin\db1cdb\encryption_keystore>dir
Directory of C:\app\oracle\virtual\admin\db1cdb\encryption_keystore
11/22/2017 10:15 AM <DIR> .
11/22/2017 10:15 AM <DIR> ..
11/22/2017 10:15 AM 2,408 ewallet.p12
1 File(s) 2,408 bytes
2 Dir(s) 8,378,060,800 bytes free
Contents of SQLNET.ORA
----------------------
SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.ENCRYPTION_SERVER = requested
SQLNET.CRYPTO_SEED = 'Pas$W0rdO'
SQLNET.ENCRYPTION_TYPES_SERVER= (AES256)
ADR_BASE = C:\app\oracle\virtual\product\12.2.0\dbhome_1\log
ENCRYPTION_WALLET_LOCATION =
(SOURCE =(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = C:\app\oracle\virtual\admin\db1cdb\encryption_keystore)))
SQL> administer key management set keystore open identified by
Ora12cR2PasswdEncryption container=ALL;
administer key management set keystore open identified by
Ora12cR2PasswdEncryption container=ALL
*
ERROR at line 1:
ORA-28367: wallet does not exist