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!

REASON="Job slave process was terminated"

Nimish GargFeb 17 2011 — edited Feb 17 2011

Hi all,

My last night scheduler failed, i saw the trace file which say this

/u01/app/oracle/admin/main/bdump/main_j001_31400.trc
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name:    Linux
Node name:      mydb.abc.net
Release:        2.6.18-194.26.1.el5
Version:        #1 SMP Tue Nov 9 12:54:20 EST 2010
Machine:        x86_64
Instance name: mydb
Redo thread mounted by this instance: 1
Oracle process number: 32
Unix process pid: 31400, image: oracle@mydb.abc.net (J001)

*** 2011-02-16 19:27:19.732
*** ACTION NAME:(JOBS_TOTAL_MAIN) 2011-02-16 19:27:19.713
*** MODULE NAME:(DBMS_SCHEDULER) 2011-02-16 19:27:19.713
*** SERVICE NAME:(SYS$USERS) 2011-02-16 19:27:19.713
*** SESSION ID:(57.60456) 2011-02-16 19:27:19.713
error 28 in job queue process
ORA-00028: your session has been killed
OPIRIP: Uncaught error 28. Error stack:
ORA-00028: your session has been killed
ORA-00028: your session has been killed

plz guide me, wht happened and how to avoid it further.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 17 2011

Added on Feb 17 2011

#general-database-discussions

8 comments

12,150 views