EBS数据库不定时崩溃,求助各位大神,谢谢

[复制链接]
查看11 | 回复5 | 2015-10-22 13:15:44 | 显示全部楼层 |阅读模式
alert日志中没有任何显示错误的信息,下面是trace文件GROUP26_mmon_17840.trc中DB崩溃的信息。
*** 2015-10-22 13:15:44.963
Unable to schedule a MMON slave at: Auto Flush Main 1
Slave was not permitted to be scheduled
- A slave for this action is already running.
*** 2015-10-22 13:18:45.088
ktte_monitor_ts: unable to schedule MMON Slave, error 100
Unable to schedule a MMON slave at: Auto Flush Main 1
*** 2015-10-22 13:23:45.281
Slave was not permitted to be scheduled
- A slave for this action is already running.
*** 2015-10-22 13:28:45.452
ktte_monitor_ts: unable to schedule MMON Slave, error 100
*** 2015-10-22 13:31:45.543
Unable to schedule a MMON slave at: Auto Flush Main 1
Slave was not permitted to be scheduled
- A slave for this action is already running.
ktte_monitor_ts: unable to schedule MMON Slave, error 100
暂时不容易打补丁,请教各位大神,谢谢。

回复

使用道具 举报

千问 | 2015-10-22 13:15:44 | 显示全部楼层
什么平台什么版本也不说说?
回复

使用道具 举报

千问 | 2015-10-22 13:15:44 | 显示全部楼层
root@szdctest:[/root]lsb_release -a
LSB Version::base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch

rinting-4.0-amd64

rinting-4.0-noarch
Distributor ID: RedHatEnterpriseServer
Description:Red Hat Enterprise Linux Server release 6.5 (Santiago)
Release:6.5
Codename: Santiago
root@szdctest:[/root]uname -a
Linux szdctest 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
root@szdctest:[/root]su - oratest26
oratest26@szdctest:[/home/oratest26]sqlplus /nolog
SQL*Plus: Release 11.1.0.7.0 - Production on Fri Oct 23 14:37:09 2015
Copyright (c) 1982, 2008, Oracle.All rights reserved.
SQL> exit
oratest26@szdctest:[/home/oratest26]exit
logout
root@szdctest:[/root]su - appltest26
appltest26@szdctest:[/home/appltest26]cd $ADMIN_SCRIPTS_HOME
appltest26@szdctest:[/ebstest/GROUP26/inst/apps/GROUP26_szdctest/admin/scripts]adopmnctl.sh status
You are running adopmnctl.sh version 120.6.12010000.5
Checking status of OPMN managed processes...
Processes in Instance: GROUP26_szdctest.szdctest.chinacache.com
---------------------------------+--------------------+---------+---------
ias-component
| process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group
| OC4J:forms-c4ws| 25421 | Alive
OC4JGroup:default_group
| OC4J

afm
| 25272 | Alive
OC4JGroup:default_group
| OC4J:forms | 25121 | Alive
OC4JGroup:default_group
| OC4J:forms | 25120 | Alive
OC4JGroup:default_group
| OC4J:forms | 25119 | Alive
OC4JGroup:default_group
| OC4J

acore| 24978 | Alive
HTTP_Server
| HTTP_Server| 24920 | Alive

adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /ebstest/GROUP26/inst/apps/GROUP26_szdctest/logs/appl/admin/log/adopmnctl.txt for more information ...
小弟是刚刚入EBS,很多事情不清楚,还请老大们给予指点,谢谢。

回复

使用道具 举报

千问 | 2015-10-22 13:15:44 | 显示全部楼层
process 设置的多少
回复

使用道具 举报

千问 | 2015-10-22 13:15:44 | 显示全部楼层
怎么没奖励了~~
回复

使用道具 举报

千问 | 2015-10-22 13:15:44 | 显示全部楼层
SQL> show parameter process;
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes
integer 1
cell_offload_processing
boolean TRUE
db_writer_processes
integer 6
gcs_server_processes
integer 0
global_txn_processes
integer 1
job_queue_processes
integer 2
log_archive_max_processes
integer 4
processes
integer 1000
奖励怎么设置,不太清楚啊,不是一直回复都有奖励吗
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行