ORA-28374: typed master key not found in wallet (TDE)
Hi ALL,
i have installed the new Oracle Database 11g release 2 on a Windows XP machine.
-- Fresh installation --
When i try to configure TDE by generating the master key with:
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY 'ver2felt';
The Database throws the error message:
ERROR at line 1:
ORA-28374: typed master key not found in wallet
BUT: The wallet file is created in the directory $ORACLE_BASE\admin\$ORACLE_SID\wallet and i can open it with the Oracle Wallet Manager. The secret store contains the DB-Encryption Key and the Masterkey.
When i restart the Database i can open the wallet with
ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "ver2felt";
I am able to encrypt columns (have not yet tested a tablespace) but i am not able to close the wallet:
SQL> ALTER SYSTEM SET ENCRYPTION WALLET CLOSE IDENTIFIED BY "ver2felt";
ALTER SYSTEM SET ENCRYPTION WALLET CLOSE IDENTIFIED BY "ver2felt"
*
ERROR at line 1:
ORA-28374: typed master key not found in wallet
SQL> ALTER SYSTEM SET ENCRYPTION WALLET CLOSE;
ALTER SYSTEM SET ENCRYPTION WALLET CLOSE
*
ERROR at line 1:
ORA-28390: auto login wallet not open
It can't be, that i have to bounce the Database to close the wallet, can it? - After i start the Database, the wallet is closed.
Any ideas? - Thank you very much in advance for your help!
Best regards from the city of Industry,
Frank/2