hi experts,
I have 12c R2 installed on my windows 10 laptop, and I have this setting in my sqlnet.ora:
ENCRYPTION_WALLET_LOCATION =
(SOURCE = (METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = C:\oracle\admin\jsu12c\wallet)
)
)
When I try to run the below command I always get an error:
sys@JSU12C> alter system set encryption key identified by "password123";
alter system set encryption key identified by "password123"
*
ERROR at line 1:
ORA-28368: cannot auto-create wallet
However I do see a file ewallet.p12 created in the above folder.
I tried other commands like:
sys@JSU12C> ADMINISTER KEY MANAGEMENT CREATE KEYSTORE 'C:\oracle\admin\jsu12c\wallet\' IDENTIFIED BY "password123";
ADMINISTER KEY MANAGEMENT CREATE KEYSTORE 'C:\oracle\admin\jsu12c\wallet\' IDENTIFIED BY "password123"
*
ERROR at line 1:
ORA-46630: keystore cannot be created at the specified location
sys@JSU12C> ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY "password123";
ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY "password123"
*
ERROR at line 1:
ORA-28367: wallet does not exist
sys@JSU12C> select * from V$ENCRYPTION_WALLET;
WRL_TYPE
--------------------
WRL_PARAMETER
----------------------------------------------------------------------------------------------
STATUS WALLET_TYPE WALLET_OR FULLY_BAC CON_ID
------------------------------ -------------------- --------- --------- ----------
FILE
C:\ORACLE\ADMIN\JSU12C\WALLET\
CLOSED UNKNOWN SINGLE UNDEFINED 1
Could you please let me know what's wrong here? Thanks!