Issue with keystore

From: Zahir Mohideen <zahir.dba_at_gmail.com>
Date: Wed, 22 Nov 2017 11:35:54 -0500
Message-ID: <CAM5KiKoJyU1y9dT48BFO=1=uqQRSiV4b5B1VOcLZV-Fs0aRvpQ_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 22 2017 - 17:35:54 CET

Original text of this message