免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 3586 | 回复: 6
打印 上一主题 下一主题

关于10G RAC模式下,日志不能归档,心跳消息发送失败的求助 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2011-07-12 12:17 |只看该作者 |倒序浏览
操作系统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.

在网上搜了一下,说是两边密码不一致,需要更改密码。不晓得各位大拿有什么好的解决方案
与解决步骤吗,请赐教

论坛徽章:
0
2 [报告]
发表于 2011-07-12 12:40 |只看该作者
是dataguard环境吗?primary和standby密码不一致会造成归档不成功
输出show parameter dest看看归档去哪里了?

论坛徽章:
59
2015七夕节徽章
日期:2015-08-24 11:17:25ChinaUnix专家徽章
日期:2015-07-20 09:19:30每周论坛发贴之星
日期:2015-07-20 09:19:42ChinaUnix元老
日期:2015-07-20 11:04:38荣誉版主
日期:2015-07-20 11:05:19巳蛇
日期:2015-07-20 11:05:26CU十二周年纪念徽章
日期:2015-07-20 11:05:27IT运维版块每日发帖之星
日期:2015-07-20 11:05:34操作系统版块每日发帖之星
日期:2015-07-20 11:05:36程序设计版块每日发帖之星
日期:2015-07-20 11:05:40数据库技术版块每日发帖之星
日期:2015-07-20 11:05:432015年辞旧岁徽章
日期:2015-07-20 11:05:44
3 [报告]
发表于 2011-07-12 12:48 |只看该作者
RAC可以直接拷贝文件嘛》

论坛徽章:
0
4 [报告]
发表于 2011-07-12 17:43 |只看该作者
可以直接拷贝文件的

论坛徽章:
59
2015七夕节徽章
日期:2015-08-24 11:17:25ChinaUnix专家徽章
日期:2015-07-20 09:19:30每周论坛发贴之星
日期:2015-07-20 09:19:42ChinaUnix元老
日期:2015-07-20 11:04:38荣誉版主
日期:2015-07-20 11:05:19巳蛇
日期:2015-07-20 11:05:26CU十二周年纪念徽章
日期:2015-07-20 11:05:27IT运维版块每日发帖之星
日期:2015-07-20 11:05:34操作系统版块每日发帖之星
日期:2015-07-20 11:05:36程序设计版块每日发帖之星
日期:2015-07-20 11:05:40数据库技术版块每日发帖之星
日期:2015-07-20 11:05:432015年辞旧岁徽章
日期:2015-07-20 11:05:44
5 [报告]
发表于 2011-07-12 18:22 |只看该作者
回复 4# 回族四少


    没有做过。谢谢。

论坛徽章:
0
6 [报告]
发表于 2011-07-12 20:00 |只看该作者
回复 1# 回族四少


    rac怎么会有standby出现,si-tech的?哪个省有这东西啊?哈哈

论坛徽章:
0
7 [报告]
发表于 2011-07-12 20:57 |只看该作者
问题解决,结贴


在一台节点$ORACLE_HOME/dbs 目录下执行orapwd file=orapwtssa1 password=sys123 entries=20
重新生成sys密码,重启两个节点,此问题解决
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP