My Oracle Support Banner

TDE Operations Are Failing With Ora-28367 / Ora-28367 After Manipulating The Wallet With OWM or orapki (Doc ID 1302664.1)

Last updated on FEBRUARY 04, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.  

 

After modifying the password of a TDE wallet in OWM or with orapki it is impossible to open the wallet from the database:


D:\wallets\XXXXX> orapki wallet change_pwd -wallet . -oldpwd welcome1 -newpwd welcome0
Oracle PKI Tool : Version 11.2.0.2.0 - Production
Copyright (c) 2004, 2010, Oracle and/or its affiliates. All rights reserved.



SQL> alter system set wallet open identified by "welcome0";
alter system set wallet open identified by "welcome0"
*ERROR at line 1:
ORA-28367: wallet does not exist




Also it is not possible to change the master key :


SQL> alter system set encryption key identified by "welcome0";
alter system set encryption key identified by "welcome0"
*
ERROR at line 1:
ORA-28368: cannot auto-create wallet



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.