Sentinel: Index EVENTS_IX1 ERROR: ORA-20000: Unable to analyze INDEX "ESECDBA"."EVENTS_IX1", insufficient privileges or does not exist

  • Document ID:3642544
  • Creation Date:02-Nov-2006
  • Modified Date:26-Apr-2012
    • Micro Focus Products:
      Sentinel

Environment

Solaris 9
Oracle 9i
Sentinel 5.1.x

Situation

An error occured when AnalyzePartions.sh is run after the SDM dropped partitions for the first time.
Table ESECDBA.EVENTS Partition P_MIN: Index EVENTS_IX1 ERROR: ORA-20000
Unable to analyze INDEX "ESECDBA"."EVENTS_IX1", insufficient privileges or does not exist
ORA-20000

Resolution

To fix this problem, run the following script below.

Setting up the below listed sql scripts to run in Oracle's crontab BEFORE the AnalyzePartion.sh script and after the cron script that archive data, add, and drops partitons.

##############################################################################

alter index EVENTS_IX3 rename partitionP_TEMP to P_MIN ;

alter index EVENTS_IX2 rename partition P_TEMP to P_MIN;

alter index EVENTS_IX1 rename partition P_TEMP to P_MIN;

alter index EVENTS_UK1 rename partition P_TEMP to P_MIN;

alter index CORRELATED_EVENTS_UK1 rename partition P_TEMP to P_MIN;

alter index EVT_DEST_EVT_NAME_SMRY_1_UK1 rename partition P_TEMP to P_MIN;

alter index EVT_PORT_SMRY_1_UK1 rename partition P_TEMP to P_MIN;

alter index EVT_DEST_SMRY_1_UK1 rename partition P_TEMP to P_MIN;

alter index EVT_DEST_TXNMY_SMRY_1_UK1 rename partition P_TEMP to P_MIN;

alter index EVT_SRC_SMRY_1_UK1 rename partition P_TEMP to P_MIN;

alter index EVT_SEV_SMRY_1_UK1 rename partition P_TEMP to P_MIN;


######################################################################################

Additional Information

------------------------------
Error Example:

Tue Nov 1 09:44:12 MST 2005 AnalyzePartitions started ...
Connected.
2005-11-01 09:11:12 Table ESECDBA.EVENTS Partition P_MIN: table analyzed
2005-11-01 09:11:13 Table ESECDBA.EVENTS Partition P_MIN: Index EVENTS_IX1 ERROR: ORA-20000: Unable to analyze INDEX"ESECDBA"."EVENTS_IX1", insufficient privileges or does not exist
ORA-20000: Unable to analyze INDEX "ESECDBA"."EVENTS_IX1", insufficient privileges or does not exist
ERROR: ORA-20002: Index ESECDBA.EVENTS_IX1 Partition P_MIN: analyze failed ORA-20000: Unable to analyze INDEX "ESECDBA"."EVENTS_IX1", insufficient privileges or does not exist
ORA-20002: Index ESECDBA.EVENTS_IX1 Partition P_MIN: analyze failed ORA-20000: Unable to analyze INDEX "ESECDBA"."EVENTS_IX1", insufficient privileges or does not exist
BEGIN esec_dba_utl.analyze_partitions('ESECDBA', 'EVENTS'); END;

*
ERROR at line 1:
ORA-20001: Table ESECDBA.EVENTS Partition P_MIN: analyze failed ORA-20002: Index ESECDBA.EVENTS_IX1 Partition P_MIN: analyze failed ORA-20000: Unable to analyze INDEX "ESECDBA"."EVENTS_IX1", insufficient privileges or does not exist
ORA-06512: at "ESECDBA.ESEC_DBA_UTL", line 105
ORA-06512: at line 1


Tue Nov 1 09:44:14 MST 2005 AnalyzePartitions failed.