问题描述:
Error 1017 received logging on to the standby
------------------------------------------------------------Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
PING[ARC2]: Heartbeat failed to connect to standby 'pandb_dg'. Error is 16191.
解决方法:
1.把RAC1,及RAC2节点,都执行一次修改密码。
SQL>alter user sys identified by sys;
2.并且把rac1 重新生成密码文件:
orapwd file=/u01/app/oracle/product/11.2.0/db_1/dbs/orapwpandb password=sys force=y ignorecase=y
并把密码文件拷贝到standby 服务器端,及rac2.
问题解决。