Deleting and Recreating the Wallet in 11.2 Results in ORA-28374
(Doc ID 988022.1)
Last updated on MAY 16, 2018
Applies to:Advanced Networking Option - Version 184.108.40.206 to 220.127.116.11 [Release 11.2]
Information in this document applies to any platform.
Checked for relevance on 08-MAR-2013
In 18.104.22.168, 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!