17,381
社区成员
发帖
与我相关
我的任务
分享ORACLE进程意外终止,大家帮我看看alert_$SID.log里的东西吧.
rt..
Sun Jun 18 07:04:20 2006
Thread 1 advanced to log sequence 273
Current log# 3 seq# 273 mem# 0: /opt/ora9/oradata/orc9/redo03.log
Sun Jun 18 09:57:06 2006
found dead shared server 'S000', pid = (8, 136)
Sun Jun 18 09:59:59 2006
Created Undo Segment _SYSSMU11$
Sun Jun 18 10:00:06 2006
Undo Segment 11 Onlined
Sun Jun 18 10:07:25 2006
found dead shared server 'S000', pid = (8, 137)
skgpspawn failed:category = 27142, depinfo = 3, op = fork, loc = skgpspawn5
failed to start shared server 'S000', oer=27142
Sun Jun 18 10:08:19 2006
Errors in file /opt/ora9/admin/orc9/bdump/orc9_pmon_1697.trc:
ORA-00476: RECO process terminated with error
PMON: terminating instance due to error 476
Instance terminated by PMON, pid = 1697
然后/opt/ora9/admin/orc9/bdump/orc9_pmon_1697.trc:的内容是
/opt/ora9/admin/orc9/bdump/orc9_pmon_1697.trc
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /opt/ora9/product/9.2
System name: Linux
Node name: localhost.localdomain
Release: 2.4.21-27.ELsmp
Version: #1 SMP Wed Dec 1 21:59:02 EST 2004
Machine: i686
Instance name: orc9
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 1697, image: oracle@localhost.localdomain (PMON)
*** 2006-06-18 10:08:18.225
*** SESSION ID:(1.1) 2006-06-18 10:08:08.111
error 476 detected in background process
ORA-00476: RECO process terminated with error
Sun Jun 18 07:04:20 2006
Thread 1 advanced to log sequence 273
Current log# 3 seq# 273 mem# 0: /opt/ora9/oradata/orc9/redo03.log
Sun Jun 18 09:57:06 2006
found dead shared server 'S000', pid = (8, 136)
Sun Jun 18 09:59:59 2006
Created Undo Segment _SYSSMU11$
Sun Jun 18 10:00:06 2006
Undo Segment 11 Onlined
Sun Jun 18 10:07:25 2006
found dead shared server 'S000', pid = (8, 137)
skgpspawn failed:category = 27142, depinfo = 3, op = fork, loc = skgpspawn5
failed to start shared server 'S000', oer=27142
Sun Jun 18 10:08:19 2006
Errors in file /opt/ora9/admin/orc9/bdump/orc9_pmon_1697.trc:
ORA-00476: RECO process terminated with error
PMON: terminating instance due to error 476
Instance terminated by PMON, pid = 1697
然后/opt/ora9/admin/orc9/bdump/orc9_pmon_1697.trc:的内容是
/opt/ora9/admin/orc9/bdump/orc9_pmon_1697.trc
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /opt/ora9/product/9.2
System name: Linux
Node name: localhost.localdomain
Release: 2.4.21-27.ELsmp
Version: #1 SMP Wed Dec 1 21:59:02 EST 2004
Machine: i686
Instance name: orc9
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 1697, image: oracle@localhost.localdomain (PMON)
*** 2006-06-18 10:08:18.225
*** SESSION ID:(1.1) 2006-06-18 10:08:08.111
error 476 detected in background process
ORA-00476: RECO process terminated with error
...全文
请发表友善的回复…
发表回复
fjmingyang 2006-06-19
- 打赏
- 举报
ORA-00476: RECO process terminated with error
The recoverer process(RECO) is used to resolve distributed transactions that are pending due to a network or system failure in a distributed database. At timed intervals, the local RECO attempts to connect to remote databases and automatically complete the commit or rollback of the local portion of any pending distributed transactions.
try this :
ALTER SYSTEM DISABLE DISTRIBUTED RECOVERY;
The recoverer process(RECO) is used to resolve distributed transactions that are pending due to a network or system failure in a distributed database. At timed intervals, the local RECO attempts to connect to remote databases and automatically complete the commit or rollback of the local portion of any pending distributed transactions.
try this :
ALTER SYSTEM DISABLE DISTRIBUTED RECOVERY;
