本来想模拟ORA-01031: 权限不足,Error 1031 received logging on to the standby,这个问题是主备密码文件不一致导致的。于是把备库的密码文件备份一下,然后重新创建一份,重启数据库生效,结果报的错和预料的不一样。
cp orapworcldg orapworcldg.bak
orapwd file=orapworcldg password=aaaaaa
主库做完一些dml操作之后,查看告警日志:
Mon Sep 26 09:16:22 2016
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 'ORCLDG'. Error is 16191.
把密码文件改回去就可以了。