This forum is currently locked. You can't register or post questions at this time. (read more)

Scheduled jobs are not running

All posts relating to Oracle database administration.

Moderator: Tim...

Rijo Roy
Member
Posts: 35
Joined: Wed Apr 17, 2013 5:39 am

Scheduled jobs are not running

Postby Rijo Roy » Wed Jul 31, 2013 11:23 am

Hi Tim

I am in serious trouble with jobs scheduled in my report generation DB as the jobs are not at all running and because of this I need to manually run(that too many should run at midnight :shock: )...

Please tell me what could be the possible reason for this and how can i resolve it.

There are no logs at all as it is not at all executing.

But I checked my alert log there i find these:

Mon Jul 29 20:30:49 2013
Error 2068 trapped in 2PC on transaction 3.24.5722. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 3.24.5722 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from REPORTDB2CSCDB
ORA-03113: end-of-file on communication channel


Kindly help. I am in serious trouble.

Thanking you in advance.

Regards

Rijo

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Scheduled jobs are not running

Postby Tim... » Wed Jul 31, 2013 1:35 pm

Hi.

So it looks like your jobs are running, but failing. Normally, if jobs aren't running I would suggest checking the JOB_QUEUE_PROCESSES parameter is set >0 and check the jobs are marked as enabled. I don;t think that is the case here.

Looking at the errors, it seems you've had a failure during a 2 phase commit (2PC), which means the two databases are in different states and either knows what to do to correct the issue.

There is an example of the cleanup method here:

http://oracleexamples.wordpress.com/200 ... nsactions/

Once you've cleaned up your in-doubt transaction(s), your jobs should start running fine again.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

Rijo Roy
Member
Posts: 35
Joined: Wed Apr 17, 2013 5:39 am

Re: Scheduled jobs are not running

Postby Rijo Roy » Wed Jul 31, 2013 2:09 pm

Hi Tim

The problem got solved after restarting the DB once(after a long fight with various teams for a sudden downtime :lol: )..

Now every job is running fine. But regarding that error in alert log, I am studying the link that you shared.

Anyways thanks a lot in helping me.

Regards

Rijo

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Scheduled jobs are not running

Postby Tim... » Wed Jul 31, 2013 2:21 pm

Hi.

Well, a shutdown will always resolve transaction problems. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 8 guests

cron