Hi Rafael -
Changed the contents of sqlnet.ora per your suggestion. Still the same
issue.
Stephan -
I tried mixed case , upper case , lowercase with and without quotes . Still
the same.
SQL> administer key management set keystore open identified by oracle ;
administer key management set keystore open identified by oracle
*
ERROR at line 1:
ORA-28367: wallet does not exist
Thanks for your inputs. Still reviewing this . Will keep you updated .
Regards
Zahir Mohideen
http://mfzahirdba.blogspot.com/
*Nothing so GREAT was achieved without enthusiasm*
On Wed, Nov 22, 2017 at 1:12 PM, Rafael Montesinos <
rafael.montesinos@xxxxxxxxx> wrote:
Hi Zahir,
Maybe if you put in the SQLNET.ORA file, WALLET_LOCATION instead
ENCRYPTION_WALLET_LOCATION
Contents of SQLNET.ORA
----------------------
WALLET_LOCATION =
(SOURCE = (METHOD = FILE)
(METHOD_DATA =
(DIRECTORY =c:\oracle\product\admin\kendev01\wallet)))
SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0
Kind Regards
Rafael Montesinos Muñoz
On Wed, Nov 22, 2017 at 5:35 PM, Zahir Mohideen <zahir.dba@xxxxxxxxx>
wrote:
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\db
1cdb\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