Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OPIRIP: Uncaught error 28.

onkar.nathJan 6 2010 — edited Jan 6 2010
Hi,

Today I found below error in one of log file in /bdump directory(log file : oltpa_j003_15827.trc):

*** 2010-01-05 14:37:30.355
*** SESSION ID:(207.18308) 2010-01-05 14:37:30.322
error 28 in job queue process
ORA-00028: your session has been killed
ORA-06512: at "SYS.DBMS_STATS", line 7775
ORA-06512: at "SYS.DBMS_STATS", line 8135
ORA-06512: at "SYS.DBMS_STATS", line 8365
ORA-06512: at "SYS.DBMS_STATS", line 10275
ORA-06512: at "SYS.DBMS_STATS", line 10315
ORA-06512: at "CANOPY.PAK_DDL_EXECUTE", line 276
ORA-06512: at "CANOPY.PAK_ADT_CLEAN", line 378
ORA-06512: at "CANOPY.PAK_ADT_CLEAN", line 480
ORA-06512: at "CANOPY.PAK_JOBS", line 153
ORA-06512: at line 1
OPIRIP: Uncaught error 28. Error stack:
ORA-00028: your session has been killed
ORA-00028: your session has been killed
ORA-06512: at "SYS.DBMS_STATS", line 7775
ORA-06512: at "SYS.DBMS_STATS", line 8135
ORA-06512: at "SYS.DBMS_STATS", line 8365
ORA-06512: at "SYS.DBMS_STATS", line 10275
ORA-06512: at "SYS.DBMS_STATS", line 10315
ORA-06512: at "CANOPY.PAK_DDL_EXECUTE", line 276
ORA-06512: at "CANOPY.PAK_ADT_CLEAN", line 378
ORA-06512: at "CANOPY.PAK_ADT_CLEAN", line 480
ORA-06512: at "CANOPY.PAK_JOBS", line 153
ORA-06512: at line 1
~
I could understand that one of the session was killed but what I could not understand is "OPIRIP: Uncaught error 28. Error stack:". Could anyone please give some information about the error and if this is very critical error?

TIA
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2010
Added on Jan 6 2010
3 comments
868 views