07/17/21 07:40 Error: Unexpected Oracle error: ORA-08004: sequence sequence_name.NEXTVAL goes below MINVALUE and cannot be instantiated. (object name: "SCHEMA"."sequence_name") [sp_opst/5381]
07/17/21 07:40 Process exited sp_opst (for o.prd1-o.prd1 queue prod1) [pid = 5381] - exit(1)
This occurs if the INCREMENT_BY value is different,1 on the source and -114460 on the Target.
On the Source you may have done some DDL on sequences.
Check the output on Source and Target database for this sequence.
sql> select * from dba_sequences where SEQUENCE_NAME= '<sequence_name>';
If it is different values for the INCREMENT_BY column then try this workaround.
WORKAROUND:
Use the SP_OPO_DISABLE_OBJECT_NUM parameter to disable the sequence on Target.
sp_ctrl> stop post
sp_ctrl> set param SP_OPO_DISABLE_OBJECT_NUM <OBJECT_ID>
sp_ctrl> start post
Once Post backlog drains reset the parameter:
sp_ctrl> reset param SP_OPO_DISABLE_OBJECT_NUM
You will need to recreate the sequence on Target to match what's on Source.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center