Several Oracle Text indexexes were dropped and re-created in the Primary DB.
The BO Reports that utilize the indexes on the Standby in an Active Data Guard configuration reported the follwoing error when the SQL uses CONTAINS :
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:DRG-50857: oracle error in drdmdcntORA-20000: Oracle Text error:DRG-10502: index 1174 does not existORA-06512: at "CTXSYS.DRUE", line 160ORA-06512: at "CTXSYS.DRVXMD", line 148ORA-06512: at line 1
The problem arises beacuse the SQL uses cached execution plan is used in the Standby DB.
The only workaround is to fulsh the shared pool in the Standby DB.
SQL>alter system flush shared_pool;
References : Oracle Spport Doc ID 1570093.1