西餐冷菜小吃图片:Oracle ORA-00481 错误,一个instance被异常kill
来源:百度文库 编辑:九乡新闻网 时间:2024/04/29 00:16:50
1. 错误现象: - Alert Log 报如下错误: Errors in file /oracle/admin/PEDBDB/bdump/pedbdb2_lmon_637.trc:
ORA-00481: LMON process terminated with error
Fri Apr 1 08:24:37 2011
LMON: terminating instance due to error 481
Fri Apr 1 08:24:37 2011
System state dump is made for local instance
System State dumped to trace file /oracle/admin/PEDBDB/bdump/pedbdb2_diag_633.trc
Fri Apr 1 08:24:39 2011
Starting ORACLE instance (normal)
Fri Apr 1 08:24:40 2011
Shutting down instance (abort)
License high water mark = 14
Fri Apr 1 08:24:43 2011
Instance terminated by LMON, pid = 637
Fri Apr 1 08:24:45 2011
Instance terminated by USER, pid = 16116 - /oracle/admin/PEDBDB/bdump/pedbdb2_lmon_637.trc log报如下错: *** 2011-04-01 08:24:37.656
error 481 detected in background process
ORA-00481: LMON process terminated with error
ksuitm: waiting up to [5] seconds before killing DIAG2. 处理措施 - 查看RAC状态 [pedbsv02:/oracle/admin/PEDBDB/bdump] crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE pedbsv01
ora....B2.inst application ONLINE OFFLINE pedbsv02 <----Instance 2 down..
ora.PEDBDB.db application ONLINE ONLINE pedbsv01
ora....01.lsnr application ONLINE ONLINE pedbsv01
ora....v01.gsd application ONLINE ONLINE pedbsv01
ora....v01.ons application ONLINE ONLINE pedbsv01
ora....v01.vip application ONLINE ONLINE pedbsv01
ora....02.lsnr application ONLINE ONLINE pedbsv02
ora....v02.gsd application ONLINE ONLINE pedbsv02
ora....v02.ons application ONLINE ONLINE pedbsv02
ora....v02.vip application ONLINE ONLINE pedbsv02 以上证明Oracle RAC正常,只是Instance 2 down,所以只要startup instance2 即可。 - startup Instance2 - 启动完成后确认状态 [pedbsv02:/oracle/admin/PEDBDB/bdump] crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE pedbsv01
ora....B2.inst application ONLINE ONLINE pedbsv02
ora.PEDBDB.db application ONLINE ONLINE pedbsv01
ora....01.lsnr application ONLINE ONLINE pedbsv01
ora....v01.gsd application ONLINE ONLINE pedbsv01
ora....v01.ons application ONLINE ONLINE pedbsv01
ora....v01.vip application ONLINE ONLINE pedbsv01
ora....02.lsnr application ONLINE ONLINE pedbsv02
ora. ...v02.gsd application ONLINE ONLINE pedbsv02
ora....v02.ons application ONLINE ONLINE pedbsv02
ora....v02.vip application ONLINE ONLINE pedbsv023. 错误原因: 等分析。。。4. 错误影响 - instance 2 上应用自动切换到 instance 1上,造成instance 1 负荷变大,磁盘IO变高。
ORA-00481: LMON process terminated with error
Fri Apr 1 08:24:37 2011
LMON: terminating instance due to error 481
Fri Apr 1 08:24:37 2011
System state dump is made for local instance
System State dumped to trace file /oracle/admin/PEDBDB/bdump/pedbdb2_diag_633.trc
Fri Apr 1 08:24:39 2011
Starting ORACLE instance (normal)
Fri Apr 1 08:24:40 2011
Shutting down instance (abort)
License high water mark = 14
Fri Apr 1 08:24:43 2011
Instance terminated by LMON, pid = 637
Fri Apr 1 08:24:45 2011
Instance terminated by USER, pid = 16116 - /oracle/admin/PEDBDB/bdump/pedbdb2_lmon_637.trc log报如下错: *** 2011-04-01 08:24:37.656
error 481 detected in background process
ORA-00481: LMON process terminated with error
ksuitm: waiting up to [5] seconds before killing DIAG2. 处理措施 - 查看RAC状态 [pedbsv02:/oracle/admin/PEDBDB/bdump] crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE pedbsv01
ora....B2.inst application ONLINE OFFLINE pedbsv02 <----Instance 2 down..
ora.PEDBDB.db application ONLINE ONLINE pedbsv01
ora....01.lsnr application ONLINE ONLINE pedbsv01
ora....v01.gsd application ONLINE ONLINE pedbsv01
ora....v01.ons application ONLINE ONLINE pedbsv01
ora....v01.vip application ONLINE ONLINE pedbsv01
ora....02.lsnr application ONLINE ONLINE pedbsv02
ora....v02.gsd application ONLINE ONLINE pedbsv02
ora....v02.ons application ONLINE ONLINE pedbsv02
ora....v02.vip application ONLINE ONLINE pedbsv02 以上证明Oracle RAC正常,只是Instance 2 down,所以只要startup instance2 即可。 - startup Instance2 - 启动完成后确认状态 [pedbsv02:/oracle/admin/PEDBDB/bdump] crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE pedbsv01
ora....B2.inst application ONLINE ONLINE pedbsv02
ora.PEDBDB.db application ONLINE ONLINE pedbsv01
ora....01.lsnr application ONLINE ONLINE pedbsv01
ora....v01.gsd application ONLINE ONLINE pedbsv01
ora....v01.ons application ONLINE ONLINE pedbsv01
ora....v01.vip application ONLINE ONLINE pedbsv01
ora....02.lsnr application ONLINE ONLINE pedbsv02
ora. ...v02.gsd application ONLINE ONLINE pedbsv02
ora....v02.ons application ONLINE ONLINE pedbsv02
ora....v02.vip application ONLINE ONLINE pedbsv023. 错误原因: 等分析。。。4. 错误影响 - instance 2 上应用自动切换到 instance 1上,造成instance 1 负荷变大,磁盘IO变高。
Oracle ORA-00481 错误,一个instance被异常kill
navicat连接oracle的错误:ora-12737:instant client l...
如何解决ORA-04031 错误(1) - Oracle指导 - 第九软件网
Oracle 错误集合
Oracle错误一览表1
Oracle报ORA-01078和LRM-00109错解决方法
ORA
ORA
oracle 连接异常 (ERR=12519)(ERROR_STA
错误解决:ORA-01036: 非法的变量名/编号
错误处理和异常处理
ORACLE错误一览表,方便大家查询
Oracle预定义的21个系统异常类型
‘Cannot create resource instance‘ !
C++的错误和异常处理分析
这一个暑假,天气异常
rman备份rman-00554 ,rman-04005错误的解决 - Oracle - ...
ORA-01547 ORA-01194 ORA-01110
一个修改Oracle用户密码的小诀窍
ORACLE 10G 连不上服务器,ERROR - ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
ORA-00604,ORA-12705解决办法
一个美丽的错误
一个错误观念
如何快速的成为一个合格的Oracle DBA?