I have the same bug (Bug 8510187 ) I read in metalink about this bug, but where is written it solution?
Where can I find solution?
Hdr: 8510187 188.8.131.52 RDBMS 184.108.40.206 SECURITY PRODID-5 PORTID-23
Abstract: ORA-28374: TYPED MASTER KEY NOT FOUND IN WALLET ON 220.127.116.11 DATABASE
*** 05/12/09 06:28 am ***
After upgrading database from 10.2.0.3 to 18.104.22.168 some apps got the
ORA-28374: typed master key not found in wallet error message.
We implemented TDE and use column encryption and we are not encrypted on
tablespace level (I believe to encrypt on tablespace is 11g feature). when i
start the 11g database open wallet did not get any error and i am be able to
select encrypt column like national identifier.
The customer is using eBusiness Suite. When the customer has a narrow
conditional query there is no issue. When the query is a larger results set,
the error appears.
Hi Yally ,
please rekey the master key, in 11g we also encrypt sort space needing the tablespace encryption key,
it will be added to the wallet the first time you rekey the master key in the new verssion:
alter system set encryption key identified by "<current wallet password>";
See MOS note 1260584.1 also , Bug 8510187 is 'not a bug' , it was probably the same issue,
Harm ten Napel