Rebuild Oracle Text indexes for Portal
The job portal.wwv_context.sync stopped working with the following error message: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "PORTAL.WWERR_API_EXCEPTION", line 71 ORA-06512: at "PORTAL.WWV_CONTEXT", line 2530 ORA-20000: Oracle Text error: DRG-10502: index WWSBR_CORNER_CTX_INDX does not exist We opened a Service Request at Oracle support but never figured out how the index disappeared, if that was the case and not a corruption somewhere. Support suggested that we executed the procedure given in Doc ID 340439.1; reinstall Oracle Text, then connect as the portal user from Portal server and execute the three scripts from middle tier home: ...