本文详细探讨了在数据库复制过程中遇到的密码文件配置错误导致的ORA-01031错误，并通过重建密码文件后仍存在的新问题进行深入分析。包括主库和备库的日志记录提示，涉及到密码文件的正确配置、远程登录密码文件设置以及SYS密码一致性检查等关键步骤。此外，还提供了备库重启后的故障依旧存在的现象和具体的测试验证过程。最终，文章针对数据库复制中的常见错误和解决策略进行了总结。
因为主库上的密码文件是错误的（名称中多了个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
扫一扫
评论
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
查看更多评论
添加红包
