ORA-28374: typed master key not found in wallet
I'm trying to understand transparent tablespace encryption. I've followed the instructions I've found in various sources, and succeeded in:
- Creating a wallet (location specified in sqlnet.ora)
- Creating an encryption key (alter system set encryption key identified by "secret")
- Creating a tablespace with the "encryption default storage (encrypt)" clause
So what's the problem? I have one database server where this does NOT work. I can create the wallet and create the encryption key, but when I try to do anything else (create an encrypted tablespace, or close the wallet) I get:
ORA-28374: typed master key not found in wallet
The resources I've found for this error message haven't been helpful. Can anyone shed some light on what this error really means, and how I can troubleshoot further? This is 11.1.0.7.0 on Windows, for what it's worth.
Thanks,
--Dan