Home » RDBMS Server » Server Administration » Why oracle scheduler is not running (Oracle 10g)
Why oracle scheduler is not running [message #584414] Tue, 14 May 2013 03:29 Go to next message
sss111ind
Messages: 634
Registered: April 2012
Location: India
Senior Member

Hi All,

Why Oracle shceduler is not running.What could be the cause.Please help me.


CREATE TABLE dept1 AS SELECT * FROM dept;

CREATE OR REPLACE
procedure update_record(p_deptno number)is
BEGIN
insert into dept1 values(p_deptno,'xxx','xxx');
end;


BEGIN
 DBMS_SCHEDULER.CREATE_PROGRAM (
    program_name        => 'all_record_program1',
    PROGRAM_TYPE        => 'STORED_PROCEDURE',
    program_action      => 'UPDATE_RECORD',
    number_of_arguments => 1,
    ENABLED             => FALSE,
    comments            => 'Program to insert records.');

  DBMS_SCHEDULER.define_program_argument (
    PROGRAM_NAME      => 'all_record_program1',
    argument_name     => 'p_deptno',
    argument_position => 1,
    ARGUMENT_TYPE     => 'NUMBER',
    default_value     => '90');
    
 DBMS_SCHEDULER.ENABLE (NAME => 'all_record_program1');

    DBMS_SCHEDULER.CREATE_SCHEDULE (
    schedule_name   => 'all_record_schedule1',
    start_date      => SYSTIMESTAMP,
    repeat_interval => 'FREQ=MINUTELY; INTERVAL=5; BYSECOND=00;',
    END_DATE        => NULL,
    comments        => 'Repeats every 5 minutes.');

 DBMS_SCHEDULER.CREATE_JOB (
    job_name      => 'all_record_job1',
    program_name  => 'all_record_program1',
    schedule_name => 'all_record_schedule1',
    ENABLED       => TRUE,
    comments      => 'Job defined to insert records into the dept table.');
END;



Regards,
Nathan
Re: Why oracle scheduler is not running [message #584418 is a reply to message #584414] Tue, 14 May 2013 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First check your job_queue_processes parameter.

Regards
Michel
Re: Why oracle scheduler is not running [message #584423 is a reply to message #584418] Tue, 14 May 2013 05:07 Go to previous messageGo to next message
sss111ind
Messages: 634
Registered: April 2012
Location: India
Senior Member

Hi Michel,

I just checked like
select value from v$parameter where name='job_queue_processes';

 alter system set job_queue_processes=1000;


Previously it was 25 I changed it to 1000.So anything apart from that.

Regards,
Nathan

[Updated on: Tue, 14 May 2013 05:07]

Report message to a moderator

Re: Why oracle scheduler is not running [message #584430 is a reply to message #584423] Tue, 14 May 2013 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check your alert.log file.

Regards
Michel
Re: Why oracle scheduler is not running [message #584433 is a reply to message #584414] Tue, 14 May 2013 05:51 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Are you hittoing the unique constraint on dept.deptno ? What is in the dba_scheduler_job_log and dba_scheduler_job_run_details views?
Re: Why oracle scheduler is not running [message #584436 is a reply to message #584433] Tue, 14 May 2013 06:02 Go to previous messageGo to next message
sss111ind
Messages: 634
Registered: April 2012
Location: India
Senior Member

Hi Michel,

How can I check the alert.log file and what to check there.I don't have the permission also to do that.

Hi John,

I created dept1 table from dept so there is no issue with primary key constraint.

Regards,
Nathan
Re: Why oracle scheduler is not running [message #584437 is a reply to message #584436] Tue, 14 May 2013 06:24 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
I created dept1 table from dept so there is no issue with primary key constraint.
Sorry, I missed that. But you should still look at the log views.
Re: Why oracle scheduler is not running [message #584443 is a reply to message #584436] Tue, 14 May 2013 06:55 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
sss111ind wrote on Tue, 14 May 2013 12:02
Hi Michel,

How can I check the alert.log file and what to check there.I don't have the permission also to do that.

You look for errors relating to the scheduler. If you don't have permission ask someone who does.
And how the heck do you have permission to alter system parameters but don't have access to the alert.log?
Re: Why oracle scheduler is not running [message #584455 is a reply to message #584443] Tue, 14 May 2013 08:39 Go to previous messageGo to next message
sss111ind
Messages: 634
Registered: April 2012
Location: India
Senior Member

Hi CookieMonster,

I dont know that whether I have access or not.But please specify whate should be there to look into.

Or else can we check the alert file with some query if there.

[Updated on: Tue, 14 May 2013 08:39]

Report message to a moderator

Re: Why oracle scheduler is not running [message #584459 is a reply to message #584455] Tue, 14 May 2013 08:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can check if there are errors in alert.log, is this not obvious?

Regards
Michel
Re: Why oracle scheduler is not running [message #584546 is a reply to message #584459] Wed, 15 May 2013 05:09 Go to previous messageGo to next message
sss111ind
Messages: 634
Registered: April 2012
Location: India
Senior Member

Hi Michel,

Till day before yesterday scheudlers were running smoothly.Every week the oracle restarted .So is there some issue if it is not properly restarted.But in production other scheduler are running fine .only the issue is with quality and development dbs.

I cannot check alert log file in locally because oracle is running on server.
Please help me to resolve this issue.

REgards,
nathan
Re: Why oracle scheduler is not running [message #584547 is a reply to message #584546] Wed, 15 May 2013 05:45 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
This is really a DBA issue. If you're acting as the DBA then you must have access to the alert.log and other trace files on the server.
If someone else has that job ask them to fix it and stop messing about with system parameters.
Re: Why oracle scheduler is not running [message #584551 is a reply to message #584546] Wed, 15 May 2013 05:59 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You still haven't looked at the views I told you to look at, have you? They are where you will see what happened. Or what didn't.
Re: Why oracle scheduler is not running [message #584553 is a reply to message #584551] Wed, 15 May 2013 06:08 Go to previous messageGo to next message
sss111ind
Messages: 634
Registered: April 2012
Location: India
Senior Member

Ok that must be the DBA's part as I dont have access to any of those things.

I would probably think from the developer side that nothing went wrong,so they are having a fix for this.After that I'll check from my end.

But one good link for this I want to share as follows.

https://forums.oracle.com/forums/thread.jspa?threadID=646581

Thanks to All .
Re: Why oracle scheduler is not running [message #584829 is a reply to message #584546] Sat, 18 May 2013 12:58 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
sss111ind wrote on Wed, 15 May 2013 03:09

...
Till day before yesterday scheudlers were running smoothly.Every week the oracle restarted .So is there some issue if it is not properly restarted.But in production other scheduler are running fine .only the issue is with quality and development dbs.
...


Has your OracleJobScheduler... service been started from the operating system of the server? Given what you have described, I would suspect that might be the problem.

[Updated on: Sat, 18 May 2013 13:19]

Report message to a moderator

Re: Why oracle scheduler is not running [message #584893 is a reply to message #584829] Mon, 20 May 2013 06:39 Go to previous message
sss111ind
Messages: 634
Registered: April 2012
Location: India
Senior Member

I have to check with DBAs' for your suggestion.Thanks for the response.
Previous Topic: Migrate from 8.1.7.0.0 to 9.2
Next Topic: Encountering ORA-20011, ORA-29400, ORA-12012 after upgrade to 11.2.0.3
Goto Forum:
  


Current Time: Fri Mar 29 08:37:22 CDT 2024