Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

ORA-28368: cannot auto-create wallet (ewallet.p12 has been created)

James SuJul 29 2019 — edited Aug 6 2019

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!

Comments
Post Details
Added on Jul 29 2019
12 comments
3,523 views