-
Title
Post stopped due to sequence error "Oracle error: ORA-08004" -
Description
07/17/06 07:40 Error: Unexpected Oracle error: ORA-08004: sequence ARS_ASYNC_JOB_SEQ.NEXTVAL goes below MINVALUE and cannot be instantiated. (object name: "ARS"."ARS_ASYNC_JOB_SEQ") [sp_opst/5381]
07/17/06 07:40 Process exited sp_opst (for o.prd1-o.prd1 queue omhtp1) [pid = 5381] - exit(1) -
Cause
This occurs if the INCREMENT_BY value is different,1 on the source and -114460 on the target.
-
Resolution
On the source you may have done some DDL on sequences.Check the output on source and target database for this sequence.
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 SP_OPO_DISABLE_OBJECT_NUM parameter to disable the sequence on target.
sp_ctrl > set param SP_OPO_DISABLE_OBJECT_NUM <OBJECT_ID>
Restart post
Once past these messages set this parameter back to default.
sp_ctrl > reset param SP_OPO_DISABLE_OBJECT_NUM
You will need to recreate the sequence on target to match what's on source.