Deleting and Recreating the Wallet in 11.2 Results in ORA-28374
(Doc ID 988022.1)
Last updated on MARCH 03, 2019
Applies to:Advanced Networking Option - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
Information in this document applies to any platform.
In 126.96.36.199, 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
#2. delete the generated wallet, without creating any encrypted object beforehand.
#3. try to create a new master encryption key using again:
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