我无法在 oracle 19c 中创建主密钥...我在 sqlnet.ora 中将参数设置为:
WALLET_LOCATION=
(SOURCE=
(METHOD=file)
(METHOD_DATA=
(DIRECTORY=/opt/oracle/product/19c/db_home/admin/ALF/wallet/tde)))
还要设置参数 TDE_CONFIGURATION:
ALTER SYSTEM SET TDE_CONFIGURATION="KEYSTORE_CONFIGURATION=FILE" scope=both;
在我重新启动 oracle 并执行以下命令后:
alter session set container=CDB$ROOT;
administer key management create keystore identified by "mypassword";
administer key management set keystore OPEN identified by "mypassword";
并尝试创建主密钥:
ADMINISTER KEY MANAGEMENT SET KEY USING TAG 'master key' IDENTIFIED BY "mypassword" WITH BACKUP USING 'masterbackup';
而且我总是收到以下错误:
ERROR at line 1:
ORA-28362: master key not found
你知道,我如何解决这个问题吗?虽然,我按照指令执行了命令......谢谢。