ORA-02289: sequence does not exist

Document ID : KB000089526
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
ORA-02289: sequence does not exist
Resolution:
Detailed Description and Symptoms

After a new install of Operations Manager using an Oracle database, the CPs will start; however, the WPs will not start...... getting this error message in log:

U0003590 DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-02289: sequence does not exist'
?


Investigation

Log into the Oracle database using the Automic database user and use this command to determine if the Automic user has the right to create a SEQUENCE:

CREATE SEQUENCE SQ_UCDUMMY
INCREMENT BY 1 START WITH 1 MAXVALUE 999999999
MINVALUE 1 CYCLE CACHE 1000 NOORDER;

If the command fails, see solution below.

If the command is successful, use this command to delete the test data that was created:

DROP SEQUENCE SQ_UCDUMMY;?
 
?


Solution

Solution/Information: If the command fails, the database user for Automic does not have CREATE SEQUENCE authorization.

The Automic database user needs to be granted the right to create a SEQUENCE (i.e.: CREATE SEQUENCE).

If the sequence are still not getting created and the error message is received after the authorization has been granted, it may be necessary to perform one or both of these additional steps:

1. Truncate the MQSRV table

2. Reload the InitialData?