Friday, November 23, 2012

ORACLE ALERT ORA-28

The alert is new alert  in Oracle Database version 11g . This is an information alert signifying that a process has been killed by a privileged user .The alert may occur like the below sample 

========================================================= 

           ORA-28 : opiodr aborting process unknown ospid (12041_1)

=========================================================

Here is a breakdown of the sample message: "opiodr aborting process unknown ospid (12041_1) 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.