Can't login - "unexpected error has occurred" ORA-01502: index 'PROTECT.SYS_C00XXXX' (where the XXXX is a specific number for the index).

Products

• Data Loss Prevention Enforce
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

The error indicates that the particular index mentioned needs to be rebuilt.

Cause

To identify other indexes that need to be rebuilt, run the following as SYS (as SYSDBA):

SELECT INDEX_NAME, STATUS FROM DBA_INDEXES WHERE STATUS != 'VALID' AND lower(Owner) = 'protect';

Resolution

Caution: 

You should always have a DB backup when working with the DB.

Indexes can be rebuilt using the following command. Run this as the user which owns the index (typically PROTECT):

ALTER INDEX <index_name> REBUILD;