ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Banner job fails with ORA-01652 message

book

Article ID: 88311

calendar_today

Updated On:

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.