Scheduler often shutdown

Document ID : KB000046900
Last Modified Date : 14/02/2018
Show Technical Document Details

ISSUE:

 

After the restore of their database environment, the scheduler starts failing very often. 

The even_demon log shows the following error message :

09/23/2016 12:02:09] CAUAJM_E_18416 Event Server: <AWA_P> Failed Query: <BEGIN :RetVal := ujo_batch_move_event (:I_time, :B_count); END; <<1474624923>>> 

[09/23/2016 12:02:09] CAUAJM_E_18402 ORA-08102: cle d'index introuvable : obj# 16279, fichier 6, bloc 54718 (2) 

[09/23/2016 12:02:09] ORA-06512: a "AEDBADMIN.UJO_BATCH_MOVE_EVENT", ligne 53 

[09/23/2016 12:02:09] ORA-06512: a ligne 1 

[09/23/2016 12:02:09] CAUAJM_I_18403 Processing OCI function ODEFIN(34) 

[09/23/2016 12:02:09] CAUAJM_E_18400 An error has occurred while interfacing with ORACLE. 

[09/23/2016 12:02:09] CAUAJM_E_18401 Function <doExecute> invoked from <nextRow> failed <860> 

[09/23/2016 12:02:17] CAUAJM_E_18416 Event Server: <AWA_P> Failed Query: <BEGIN :RetVal := ujo_batch_move_event (:I_time, :B_count); END; <<1474624934>>> 

[09/23/2016 12:02:17] CAUAJM_E_18402 ORA-08102: cle d'index introuvable : obj# 16279, fichier 6, bloc 54718 (2) 

[09/23/2016 12:02:17] ORA-06512: a "AEDBADMIN.UJO_BATCH_MOVE_EVENT", ligne 53 

 

 

 

ENVIRONMENT:

 

$ -> autoflags -a 

147 LINUX ANY 11.3 SP1 

 

 

 

 

SOLUTION:

 

From the error message seen in the event_demon log file , please go through the following steps :

 

1 - Stop the scheduler 

 

2 - select substr(object_name,1,30),object_type from user_objects where object_id =16279; 

 

Broken index is: XAK1UJO_EVENT 

 

 

3 - The following query displays all the indexes created on table ujo_event: 

 

select b.uniqueness, a.index_name, a.table_name, a.column_name from all_ind_columns a, all_indexes b where a.index_name=b.index_name and a.table_name = upper('ujo_event') order by a.table_name, a.index_name, a.column_position; 

 

4 - Use the following query to drop the corrupt index: 

 

drop index aedbadmin.xak1ujo_event; 

 

5 - Use the following query to recreate index XAK1UJO_EVENT 

 

create index AEDBADMIN.xak1ujo_event on AEDBADMIN.UJO_event(event_time_gmt); 

 

Check again that the index is back. 

 

6 - Start the scheduler