Automation Engine stops working due to ORA-01653.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The Automation Engine stops working due to the Oracle database running out of space.

U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-01653: unable to extend table <TABLE_NAME> by 128 in tablespace UC4_DATA'

Environment

Release : 12.n

Component : AUTOMATION ENGINE

Cause

Missing space in the Oracle database.

Resolution

To resolve this issue, increase the size of the tablespace in the Oracle database by doing the following:

Add one or more files to the table space using the following command in Oracle:
ALTER TABLESPACE '< Tablespace name >' ADD DATAFILE '<path>' SIZE < size of the file >

Add one or more files to the table space using the following command in Oracle:
ALTER DATABASE DATAFILE '< Datafile name >' RESIZE < size of the file >