LoveUnix » ORACLE等数据库 » AIX5.1+HACMP+RAC数据库宕机
2008-9-19 17:42
testhelp1
AIX5.1+HACMP+RAC数据库宕机
错误发生多了.就发生地址漂移和ORACLE停掉的错误.发生好几次了请高手看下什么原因怎么去具体查!
alert_ora91.log中的一些错误:
Fri Sep 19 13:28:31 2008
Error 2068 trapped in 2PC on transaction 21.30.1916845. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 21.30.1916845 rolled back, some remote DBs may be in-doub
t
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
Fri Sep 19 13:28:31 2008
Errors in file /ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_19980.trc:
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 21.30.1916845 rolled back, some remote DBs may be in-doub
t
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
Fri Sep 19 13:28:31 2008
DISTRIB TRAN L3IRONBE.8f5254b6.21.30.1916845
is local tran 21.30.1916845 (hex=15.1e.1d3fad)
insert pending collecting tran, scn=883572199899 (hex=cd.b901d1db)
Fri Sep 19 13:28:32 2008
DISTRIB TRAN L3IRONBE.8f5254b6.21.30.1916845
is local tran 21.30.1916845 (hex=15.1e.1d3fad))
delete pending collecting tran, scn=883572199899 (hex=cd.b901d1db)
Fri Sep 19 14:58:22 2008
Error 2068 trapped in 2PC on transaction 2.26.3576501. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 2.26.3576501 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
Fri Sep 19 14:58:22 2008
Errors in file /ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_32534.trc:
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 2.26.3576501 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
Fri Sep 19 14:58:22 2008
DISTRIB TRAN L3IRONBE.8f5254b6.2.26.3576501
is local tran 2.26.3576501 (hex=02.1a.3692b5)
insert pending collecting tran, scn=883572499868 (hex=cd.b906659c)
Fri Sep 19 14:58:22 2008
DISTRIB TRAN L3IRONBE.8f5254b6.2.26.3576501
is local tran 2.26.3576501 (hex=02.1a.3692b5))
delete pending collecting tran, scn=883572499868 (hex=cd.b906659c)
Fri Sep 19 15:01:23 2008
Thread 1 advanced to log sequence 19286
Current log# 1 seq# 19286 mem# 0: /dev/rlog1_1lv
Current log# 1 seq# 19286 mem# 1: /dev/rlog1_2lv
Fri Sep 19 16:20:17 2008
Errors in file /ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_32434.trc:
ORA-12012: error on auto execute of job 2132
ORA-12560: TNS:protocol adapter error
ORA-06512: at "COMMUNICATION.FROM_TO_TTABLE2", line 570
ORA-06512: at line 1
Fri Sep 19 16:20:37 2008
Errors in file /ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_46532.trc:
ORA-12012: error on auto execute of job 2233
ORA-12547: TNS:lost contact
ORA-06512: at "COMMUNICATION.FROM_SJL22", line 529
ORA-06512: at line 1
Fri Sep 19 16:29:15 2008
Error 2068 trapped in 2PC on transaction 41.26.191664. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 41.26.191664 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
Fri Sep 19 16:29:15 2008
Errors in file /ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_19980.trc:
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 41.26.191664 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
Fri Sep 19 16:29:19 2008
DISTRIB TRAN L3IRONBE.8f5254b6.41.26.191664
is local tran 41.26.191664 (hex=29.1a.2ecb0)
insert pending collecting tran, scn=883572877673 (hex=cd.b90c2969)
Fri Sep 19 16:29:19 2008
DISTRIB TRAN L3IRONBE.8f5254b6.41.26.191664
is local tran 41.26.191664 (hex=29.1a.2ecb0))
delete pending collecting tran, scn=883572877673 (hex=cd.b90c2969)
----------------------------------------------------------------------------------------------------------------
/ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_19980.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining op
tions
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /ora/app/oracle/product/9.2.0
System name: AIX
Node name: l3ironbe1
Release: 1
Version: 5
Machine: 005DAA2F4C00
Instance name: ora91
Redo thread mounted by this instance: 1
Oracle process number: 0
19980
Number of Serviceable Networks detected is less than 2
Disabling Transparent Network Failover Feature.
/ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_19980.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining op
tions
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /ora/app/oracle/product/9.2.0
System name: AIX
Node name: l3ironbe1
Release: 1
Version: 5
Machine: 005DAA2F4C00
Instance name: ora91
Redo thread mounted by this instance: 1
Oracle process number: 0
19980
Number of Serviceable Networks detected is less than 2
Disabling Transparent Network Failover Feature.
*** SESSION ID:(24.385) 2008-09-18 10:27:33.955
*** 2008-09-18 10:27:33.955
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 27.1.1843036 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
*** SESSION ID:(24.4043) 2008-09-19 08:27:08.380
*** 2008-09-19 08:27:08.380
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 4.11.2543738 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
*** SESSION ID:(66.6455) 2008-09-19 13:28:31.765
*** 2008-09-19 13:28:31.765
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 21.30.1916845 rolled back, some remote DBs may be in-doub
t
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
*** SESSION ID:(66.6993) 2008-09-19 16:29:15.722
*** 2008-09-19 16:29:15.722
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 41.26.191664 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
错误发生多了.就发生地址漂移和ORACLE停掉的错误.发生好几次了请高手看下什么原因怎么去具体查!
alert_ora91.log中的一些错误:
Fri Sep 19 13:28:31 2008
Error 2068 trapped in 2PC on transaction 21.30.1916845. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 21.30.1916845 rolled back, some remote DBs may be in-doub
t
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
Fri Sep 19 13:28:31 2008
Errors in file /ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_19980.trc:
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 21.30.1916845 rolled back, some remote DBs may be in-doub
t
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
Fri Sep 19 13:28:31 2008
DISTRIB TRAN L3IRONBE.8f5254b6.21.30.1916845
is local tran 21.30.1916845 (hex=15.1e.1d3fad)
insert pending collecting tran, scn=883572199899 (hex=cd.b901d1db)
Fri Sep 19 13:28:32 2008
DISTRIB TRAN L3IRONBE.8f5254b6.21.30.1916845
is local tran 21.30.1916845 (hex=15.1e.1d3fad))
delete pending collecting tran, scn=883572199899 (hex=cd.b901d1db)
Fri Sep 19 14:58:22 2008
Error 2068 trapped in 2PC on transaction 2.26.3576501. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 2.26.3576501 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
Fri Sep 19 14:58:22 2008
Errors in file /ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_32534.trc:
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 2.26.3576501 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
Fri Sep 19 14:58:22 2008
DISTRIB TRAN L3IRONBE.8f5254b6.2.26.3576501
is local tran 2.26.3576501 (hex=02.1a.3692b5)
insert pending collecting tran, scn=883572499868 (hex=cd.b906659c)
Fri Sep 19 14:58:22 2008
DISTRIB TRAN L3IRONBE.8f5254b6.2.26.3576501
is local tran 2.26.3576501 (hex=02.1a.3692b5))
delete pending collecting tran, scn=883572499868 (hex=cd.b906659c)
Fri Sep 19 15:01:23 2008
Thread 1 advanced to log sequence 19286
Current log# 1 seq# 19286 mem# 0: /dev/rlog1_1lv
Current log# 1 seq# 19286 mem# 1: /dev/rlog1_2lv
Fri Sep 19 16:20:17 2008
Errors in file /ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_32434.trc:
ORA-12012: error on auto execute of job 2132
ORA-12560: TNS:protocol adapter error
ORA-06512: at "COMMUNICATION.FROM_TO_TTABLE2", line 570
ORA-06512: at line 1
Fri Sep 19 16:20:37 2008
Errors in file /ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_46532.trc:
ORA-12012: error on auto execute of job 2233
ORA-12547: TNS:lost contact
ORA-06512: at "COMMUNICATION.FROM_SJL22", line 529
ORA-06512: at line 1
Fri Sep 19 16:29:15 2008
Error 2068 trapped in 2PC on transaction 41.26.191664. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 41.26.191664 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
Fri Sep 19 16:29:15 2008
Errors in file /ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_19980.trc:
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 41.26.191664 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
Fri Sep 19 16:29:19 2008
DISTRIB TRAN L3IRONBE.8f5254b6.41.26.191664
is local tran 41.26.191664 (hex=29.1a.2ecb0)
insert pending collecting tran, scn=883572877673 (hex=cd.b90c2969)
Fri Sep 19 16:29:19 2008
DISTRIB TRAN L3IRONBE.8f5254b6.41.26.191664
is local tran 41.26.191664 (hex=29.1a.2ecb0))
delete pending collecting tran, scn=883572877673 (hex=cd.b90c2969)
----------------------------------------------------------------------------------------------------------------
/ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_19980.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining op
tions
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /ora/app/oracle/product/9.2.0
System name: AIX
Node name: l3ironbe1
Release: 1
Version: 5
Machine: 005DAA2F4C00
Instance name: ora91
Redo thread mounted by this instance: 1
Oracle process number: 0
19980
Number of Serviceable Networks detected is less than 2
Disabling Transparent Network Failover Feature.
/ora/app/oracle/admin/l3ironbe/bdump/ora91_ora_19980.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining op
tions
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /ora/app/oracle/product/9.2.0
System name: AIX
Node name: l3ironbe1
Release: 1
Version: 5
Machine: 005DAA2F4C00
Instance name: ora91
Redo thread mounted by this instance: 1
Oracle process number: 0
19980
Number of Serviceable Networks detected is less than 2
Disabling Transparent Network Failover Feature.
*** SESSION ID:(24.385) 2008-09-18 10:27:33.955
*** 2008-09-18 10:27:33.955
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 27.1.1843036 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
*** SESSION ID:(24.4043) 2008-09-19 08:27:08.380
*** 2008-09-19 08:27:08.380
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 4.11.2543738 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
*** SESSION ID:(66.6455) 2008-09-19 13:28:31.765
*** 2008-09-19 13:28:31.765
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 21.30.1916845 rolled back, some remote DBs may be in-doub
t
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
*** SESSION ID:(66.6993) 2008-09-19 16:29:15.722
*** 2008-09-19 16:29:15.722
ORA-12012: error on auto execute of job 2232
ORA-02050: transaction 41.26.191664 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from DBLINK_JHL2
ORA-03113: end-of-file on communication channel
ORA-06512: at "COMMUNICATION.FROM_JHL22", line 64
ORA-06512: at line 1
2008-9-22 11:56
boypoo
把上一次重启后的alert放上来看看
2008-10-7 00:03
yaya5339
.
支持楼上观点
[img]http://www.duofu.com.cn/bbs/images/default/sigline.gif[/img]
[color=black]白天很傻很天真。晚上很黄很暴力!![/color][url=http://www.microsoftoffices.cn/][color=black]office下载[/color][/url][url=http://www.360marry.com.cn/][color=black]江西婚庆[/color][/url][url=http://www.offices2007.cn/][color=black]office2007[/color][/url][url=http://www.dubu2009.cn/][color=black]金山毒霸2009[/color][/url][url=http://www.iciba2008.net.cn/][color=black]金山词霸下载[/color][/url]
支持楼上观点
[img]http://www.duofu.com.cn/bbs/images/default/sigline.gif[/img]
[color=black]白天很傻很天真。晚上很黄很暴力!![/color][url=http://www.microsoftoffices.cn/][color=black]office下载[/color][/url][url=http://www.360marry.com.cn/][color=black]江西婚庆[/color][/url][url=http://www.offices2007.cn/][color=black]office2007[/color][/url][url=http://www.dubu2009.cn/][color=black]金山毒霸2009[/color][/url][url=http://www.iciba2008.net.cn/][color=black]金山词霸下载[/color][/url]
页: [1]
查看完整版本: AIX5.1+HACMP+RAC数据库宕机
Powered by Discuz! Archiver 5.5.0 © 2001-2006 Comsenz Inc.