My Oracle Support Banner

Deleting and Recreating the Wallet in 11.2 Results in ORA-28374 (Doc ID 988022.1)

Last updated on OCTOBER 10, 2022

Applies to:

Advanced Networking Option - Version to [Release 11.2]
Information in this document applies to any platform.


In, if performing the following sequence of commands, on a database where TDE has never been actually used results in a ORA-28374 error:

#1. create a new master encryption key, using

From here on, any attempt to do something related to TDE, eg, create an encrypted tablespace or rekey the master key, fails with the same error. In a RAC environment, the situation is even worse, because the wallets on the 2 or more nodes cannot be opened on all nodes simultanously, hence the system becomes unusable from TDE perspective.


The wallet file ewallet.p12 was inadvertently deleted.


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

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