Found GATHER_STATS_JOB job not run and some jobs not run on scheduler time:
Perhaps some Scheduler Windows running...
and I found WEEKNIGHT_WINDOW running [Global Attribute].
SQL> select * from DBA_SCHEDULER_GLOBAL_ATTRIBUTE where attribute_name='CURRENT_OPEN_WINDOW';
ATTRIBUTE_NAME VALUE
-------------- ---------------
CURRENT_OPEN_WINDOW WEEKNIGHT_WINDOW
I need to close it:
SQL> exec DBMS_SCHEDULER.close_window ('WEEKNIGHT_WINDOW');
BEGIN DBMS_SCHEDULER.close_window ('WEEKNIGHT_WINDOW'); END;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_ISCHED", line 341
ORA-06512: at "SYS.DBMS_SCHEDULER", line 880
ORA-06512: at line 1
SQL> SELECT window_name, resource_plan, enabled, active FROM dba_scheduler_windows;
WINDOW_NAME RESOURCE_PLAN ENABL ACTIV
------------------------------ ------------------------------ ----- -----
WEEKNIGHT_WINDOW TRUE FALSE
WEEKEND_WINDOW TRUE FALSE
And then found it disable now.
Check in alert log =>
Fri Sep 5 14:56:25 2008
Errors in file /.../udump/db2_ora_4774.trc:
ORA-00600: internal error code, arguments: [jskarwgw:1], [8905], [8905], [], [], [], [], []
Fri Sep 5 14:56:28 2008
Trace dumping is performing id=[cdmp_20080905145628]
When I used metalink -> It's a "Bug No.6052802".
Product -> Oracle Server - Enterprise Edition
Product Version -> 10.2.0.3.0
Platform ->Linux x86-64
So, I thought .............. and then
Recreated "WEEKNIGHT_WINDOW" Scheduler Window.
Drop->
BEGIN
DBMS_SCHEDULER.DROP_WINDOW (
window_name=>'"WEEKNIGHT_WINDOW"',
force => TRUE);
END;
/
Create ->
BEGIN
DBMS_SCHEDULER.CREATE_WINDOW(
window_name=>'"WEEKNIGHT_WINDOW"',
resource_plan=>'',
start_date=>systimestamp at time zone '+7:00',
duration=>numtodsinterval(480, 'minute'),
repeat_interval=>'FREQ=WEEKLY;BYDAY=MON,TUE,WED,THU,FRI;BYHOUR=22;BYMINUTE=0;BYSECOND=0',
end_date=>null,
window_priority=>'LOW',
comments=>'Weeknight window for maintenance task');
END;
/
Add to MAINTENANCE_WINDOW_GROUP window group ->
BEGIN
DBMS_SCHEDULER.ADD_WINDOW_GROUP_MEMBER(
group_name=>'"MAINTENANCE_WINDOW_GROUP"',
window_list=>'"WEEKNIGHT_WINDOW"');
END;
/
And then Checked, and no found any scheduler window running:
SQL> select * from DBA_SCHEDULER_GLOBAL_ATTRIBUTE where attribute_name='CURRENT_OPEN_WINDOW';
ATTRIBUTE_NAME VALUE
-------------- ---------------
CURRENT_OPEN_WINDOW
After that, I find every jobs be OK.
This problem is resolved.
Friday, September 05, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment