Banner job fails with ORA-01652 message

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Banner job fails with ORA-01652 message

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Detailed Description and Symptoms

 

Any Banner Jobs running are failing with the error message below:

 

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

 

Solution

 

When a new segment is created, Oracle uses temporary extents to initially build it before it converts the extent to a permanent value. If there is not enough tablespace, it results in the Oracle error which in turn causes the job to fail.

 

The DBA needs to increase/add space to the TEMP tablespace of the Oracle database.