因为主库上的密码文件是错误的(名称中多了个d),导致搭建完成之后无法使用导致 ora-01031:insufficient privileges错误 详见:http://blog.youkuaiyun.com/aaaaaaaa2000/article/details/7549901
重建密码文件之后,在主库日志中报:
ed May 09 14:53:26 2012
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
------------------------------------------------------------
Errors in file /disk2/oracle/diag/rdbms/maildata/maildata/trace/maildata_arc2_6852.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC2]: Heartbeat failed to connect to standby 'maildata_std'. Error is 16191.
备库中:
ARC3 started with pid=23, OS id=21610
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
Completed: alter database mount standby database
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
------------------------------------------------------------
FAL[client, ARC2]: Error 16191 connecting to MAILDATA for fetching gap sequence
Errors in file /home/oracle/diag/rdbms/maildata_std/maildata/trace/maildata_arc2_21606.trc:
ORA-16191: Primary log shipping client not logged on standby
Errors in file /home/oracle/diag/rdbms/maildata_std/maildata/trace/maildata_arc2_21606.trc:
ORA-16191: Primary log shipping client not logged on standby
重启备库之后问题依然,
具体的测试----
http://blog.chinaunix.net/uid-66396-id-2688930.html
ORA-16191: Primary log shipping client not logged on standby---待测
最新推荐文章于 2021-12-19 13:09:20 发布