oracle透明加密不可用

事情的经过：

一套12c的rac数据库搭建了adg同步。

1、将主备切换。

2、将切换后的新主库升级到19c。

升级后检查发现TDE不可用，影响部分业务的正常使用。

将sqlnet.ora和wallet文件重新拷贝到目标主机。

administer key management set keystore close;
administer key management set keystore open identified by <wallet_password> ;
administer key management set key identified by <wallet_password> with backup;
administer key management set keystore open identified by <wallet_password> ;
administer key management create AUTO_LOGIN keystore from keystore '<wallet directory>' identified by  <wallet_password> ;
1节点恢复正常，但是2节点仍然不可用，查看2节点的key_id为空，

select * from v$encryprion_wallet;

在2节点设置key_id：

ADMINISTER KEY MANAGEMENT USE KEY <key_id> force keystore IDENTIFIED BY <wallet_password> WITH BACKUP;