Wednesday, February 19, 2014

ORA-29902 DRG-10502 Utilizing Text Indexes on Standby in Read Only Mode (Active DataGuard)

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

No comments:

Post a Comment