Friday, September 05, 2008

ORA-00600: internal error code, arguments: [jskarwgw:1]

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.

No comments: