注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

常在心

淡泊明志,人生自在

 
 
 

日志

 
 

opiodr aborting process unknown ospid (28342) as a result of ORA-28  

2011-12-01 17:29:33|  分类: oracle问题 |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.2 - Release: 11.1 to 11.2
Information in this document applies to any platform.

Goal


What is the meaning of "opiodr aborting process" messages in the database alert log?
For example:

Wed Jul 21 13:30:36 2010
opiodr aborting process unknown ospid (28342) as a result of ORA-28





Solution


This is an informational message only.  The intention of the message is to ensure that the alert captures information about processes that exit unusually.  The message was added in 11g.

The sample message above, with the ORA-28, is normally reported when a privileged user has killed the session.

Here is a breakdown of the sample message: "opiodr aborting process unknown ospid (28342) as a result of ORA-28"

"unknown" => means it is not a background or shadow process that is killed
"ospid (28342)" => this is the OS pid of the process which opiodr is aborting
"as a result of" => this precedes the error message which is the reason for opiodr to kill the process
"ORA-28" => this is the reason that opiodr killed the process. In this case, it is ora-28.

Here is the error text for ORA-28:
Error: ORA 28 
Text: your session has been killed 
-------------------------------------------------------------------------------
Cause: A privileged user killed the session and it is no longer logged in to the database.
Action: Contact the database administrator.
The administrator may be attempting to perform an operation that requires users to be logged out.
When the database administrator announces that the database is available, log in and resume work.

The "opiodr aborting process" message can occur with different causes than ORA-28. In that case the "opiodr aborting process" message will have the relevant error instead of the ORA-28
说明:这个错误是ORACLE 11G以后添加进去的,以前版本中不存在这样的错误,没有更好的解决办法,但不影响业务
  评论这张
 
阅读(1933)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017