issues with DGMGRL switchover and wallets
Yesterday, we saw some odd behavior in a database after performing DG switchover testing. In one case the wallet for the standby appeared correct and open via v$encryption_wallet, but MRP was quitting with this error:
kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet
Slave exiting with ORA-28365 exception
Errors in file /u01/app/oracle/diag/rdbms/orp578z/orp578z1/trace/orp578z1_pr09_120954.trc:
ORA-28365: wallet is not open
Wed Mar 16 14:01:53 2016
Recovery Slave PR09 previously exited with exception 28365
Wed Mar 16 14:01:53 2016
MRP0: Background Media Recovery terminated with error 448
In the other case on the primary, v$encryption_wallet was showing open on node 1, but node 2 was closed and not using the location from sqlnet.ora. Node 1 operated correctly, but on node 2 the error was: