- 论坛徽章:
- 0
|
操作系统AIX6.1,双机共享裸设备RAC模式,现在日志不能归档,日志报用户名密码错误,是不是两台服务器的不一致,昨天晚上一台机器的文件丢失了,从另一台拷贝过来,启动后就变成这样了,详细的两台机器的alert日志如下
关于RAC模式下,日志不能归档,心跳消息发送失败的求助
一、RAC模式节点1的alert日志如下
------------------------------------------------------------
Tue Jul 12 04:52:05 2011
Errors in file /opt/u01/oracle/admin/sitech/bdump/sitech1_arc1_1507452.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC1]: Heartbeat failed to connect to standby 'sitech2'. Error is 16191.
Tue Jul 12 04:57:05 2011
Errors in file /opt/u01/oracle/admin/sitech/bdump/sitech1_arc1_1507452.trc:
ORA-01017: invalid username/password; logon denied
Tue Jul 12 04:57:05 2011
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
It may be necessary to define the DB_ALLOWED_LOGON_VERSION
initialization parameter to the value "10". Check the
manual for information on this initialization parameter.
------------------------------------------------------------
Tue Jul 12 04:57:05 2011
Errors in file /opt/u01/oracle/admin/sitech/bdump/sitech1_arc1_1507452.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC1]: Heartbeat failed to connect to standby 'sitech2'. Error is 16191.
Tue Jul 12 05:02:06 2011
Errors in file /opt/u01/oracle/admin/sitech/bdump/sitech1_arc1_1507452.trc:
ORA-01017: invalid username/password; logon denied
Tue Jul 12 05:02:06 2011
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
It may be necessary to define the DB_ALLOWED_LOGON_VERSION
initialization parameter to the value "10". Check the
manual for information on this initialization parameter.
------------------------------------------------------------
Tue Jul 12 05:02:06 2011
Errors in file /opt/u01/oracle/admin/sitech/bdump/sitech1_arc1_1507452.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC1]: Heartbeat failed to connect to standby 'sitech2'. Error is 16191.
Tue Jul 12 05:07:06 2011
Errors in file /opt/u01/oracle/admin/sitech/bdump/sitech1_arc1_1507452.trc:
ORA-01017: invalid username/password; logon denied
Tue Jul 12 05:07:06 2011
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
It may be necessary to define the DB_ALLOWED_LOGON_VERSION
initialization parameter to the value "10". Check the
manual for information on this initialization parameter.
------------------------------------------------------------
二、RAC模式节点2的alert日志如下
PING[ARC1]: Heartbeat failed to connect to standby 'sitech1'. Error is 1031.
Tue Jul 12 10:29:34 2011
Error 1031 received logging on to the standby
Tue Jul 12 10:29:34 2011
Errors in file /opt/u01/oracle/admin/sitech/bdump/sitech2_arc1_2425350.trc:
ORA-01031: insufficient privileges
PING[ARC1]: Heartbeat failed to connect to standby 'sitech1'. Error is 1031.
Tue Jul 12 10:34:34 2011
Error 1031 received logging on to the standby
Tue Jul 12 10:34:34 2011
Errors in file /opt/u01/oracle/admin/sitech/bdump/sitech2_arc1_2425350.trc:
ORA-01031: insufficient privileges
PING[ARC1]: Heartbeat failed to connect to standby 'sitech1'. Error is 1031.
Tue Jul 12 10:39:34 2011
Error 1031 received logging on to the standby
Tue Jul 12 10:39:34 2011
Errors in file /opt/u01/oracle/admin/sitech/bdump/sitech2_arc1_2425350.trc:
ORA-01031: insufficient privileges
PING[ARC1]: Heartbeat failed to connect to standby 'sitech1'. Error is 1031.
Tue Jul 12 10:44:34 2011
Error 1031 received logging on to the standby
Tue Jul 12 10:44:34 2011
Errors in file /opt/u01/oracle/admin/sitech/bdump/sitech2_arc1_2425350.trc:
ORA-01031: insufficient privileges
PING[ARC1]: Heartbeat failed to connect to standby 'sitech1'. Error is 1031.
Tue Jul 12 10:49:34 2011
Error 1031 received logging on to the standby
Tue Jul 12 10:49:34 2011
Errors in file /opt/u01/oracle/admin/sitech/bdump/sitech2_arc1_2425350.trc:
ORA-01031: insufficient privileges
PING[ARC1]: Heartbeat failed to connect to standby 'sitech1'. Error is 1031.
Tue Jul 12 10:54:34 2011
Error 1031 received logging on to the standby
Tue Jul 12 10:54:34 2011
Errors in file /opt/u01/oracle/admin/sitech/bdump/sitech2_arc1_2425350.trc:
ORA-01031: insufficient privileges
PING[ARC1]: Heartbeat failed to connect to standby 'sitech1'. Error is 1031.
在网上搜了一下,说是两边密码不一致,需要更改密码。不晓得各位大拿有什么好的解决方案
与解决步骤吗,请赐教 |
|