search cancel

ORA-02289: sequence does not exist

book

Article ID: 89526

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

ORA-02289: sequence does not exist

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

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?