Oracle Text (MOSC)

MOSC Banner

Search stops working for Item Object

edited Nov 22, 2009 10:04PM in Oracle Text (MOSC) 1 commentAnswered
Search for Item does not work every evening OR whenever Application server (OAS) is re-started. We have two ctx indexes 'ITEM_CTX_IDX' and 'REV_CTX_IDX'. These index remains Valid when search does not work.

I  following sqls return VALID:

select domidx_status,domidx_opstatus,status from user_indexes where index_name='ITEM_CTX_IDX'
select domidx_status,domidx_opstatus,status from user_indexes where index_name='REV_CTX_IDX'

Searches works fine during day time and stop working after 6:30 PST. These is no database process running at that time. This search problem can be resolve temporarily by updating description of any ITEM. Search for ITEM object starts working If I update description of one of my test item and saves it.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center