在Oracle 11.2.0.1环境下测试,加密表空间的使用,大致操作步骤如下:
正常创建wallet后,然后删除wallet在系统中对应的文件,然后再想重新创建wallet,此时遇到了如下错误:
SYS@orcl>ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "qxy12345";
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "qxy12345"
*
ERROR at line 1:
ORA-28374: typed master key not found in wallet
从网上各种搜索,没找到答案,偶然发现11.2.0.3 Bug Fixes列表中有如下记录:
9215461 | TDE wallet master rekey fails with ORA-28362 or creation of encrypted tablespace fails with ORA-28374 |
推测该问题由于bug引发,将数据库升级到11.2.0.4后,问题解决。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9430546/viewspace-1260385/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9430546/viewspace-1260385/