My Oracle Support Banner

RILMAINT_POST_JOB Failure Due to RIB Sessions Running in the Background (Doc ID 2963705.1)

Last updated on AUGUST 01, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.



For a previous batch failure the AMS team executed a script "DUMMY_START_NIGHT_BATCH_JOB" before the batch which will bring down all the rib subscribers."

But RILMAINT_POST_JOB failed in the nightly cycle and the reason given was RIB sessions running in background.

RILMAINT_POST_JOB was failing due to below resource busy issue:
prepost~20230718120107~modify_indexes~~-54~ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired~EXECUTE DYNAMIC STATEMENT ALTER INDEX RMS01.REPL_ITEM_LOC_UPDATES_I3 UNUSABLE

On investigating further they could see that some of the RIB sessions which were running in the background, was causing this resource busy issue.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.