Ops Center (MOSC)

MOSC Banner

Is there a easy solution for ORA-08004: sequence SEQ_1HOUR_USAGE_ID.NEXTVAL exceeds MAXVALUE and can

edited Mar 14, 2016 2:10PM in Ops Center (MOSC) 2 commentsAnswered ✓

We're running Ops Center 12.3.0 with a remote DB. Rollups have been failing for months and at first it was thought (via the SR that's still open) that the issue was with the tablespace growth. However, after a truncate, the rollups still fail. After a recent test (using the cli to run a rollup manually), we uncovered these errors:

cacao.0:Caused by: java.sql.SQLException: ORA-08004: sequence SEQ_1HOUR_USAGE_ID.NEXTVAL exceeds MAXVALUE and cannot be instantiated

cacao.0:ORA-06512: at "OC12CSCHEMA.RM_RESOURCE_1HOUR_TREND_BR", line 3

cacao.0:ORA-04088: error during execution of trigger 'OC12CSCHEMA.RM_RESOURCE_1HOUR_TREND_BR'

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