文档解释
ORA-16193: Primary and standby network encryption mismatch
Cause: Standby wants sqlnet network encryption for redo shipment which is not configured properly at the primary.
Action: Check sqlnet.ora documentation regarding how to setup network encryption and set it up identically on both primary and standby. Restart primary and/or standby.
ORA-16193 错误提示主站和备份站网络加密不匹配。
官方解释
常见案例
正常处理:
步骤1:使用Oracle数据库管理员(DBA),查看当前备份站网络帧加密类型:
SQL> SELECT type,rpa_encryption FROM v$configured_encryption_types order by type;
步骤2:确认主站网络帧加密类型与步骤1提示一致:
SQL> SELECT type,rpa_encryption FROM v$primary_configured_encryption_types order by type;
步骤3:如果值不一致,请调整备份站或主站网络帧加密类型,使其一致:
SQL> ALTER SYSTEM SET rpa_encryption=” SCOPE=BOTH;