Deleting and Recreating the Wallet in 11.2 Results in ORA-28374
Last updated on MAY 16, 2018
Applies to:Advanced Networking Option - Version 22.214.171.124 to 126.96.36.199 [Release 11.2]
Information in this document applies to any platform.
Checked for relevance on 08-MAR-2013
In 188.8.131.52, 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms