CA Workload Automation AE Application server service goes down with an error: ORA-01652
search cancel

CA Workload Automation AE Application server service goes down with an error: ORA-01652

book

Article ID: 230803

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

Autosys Application server service goes down frequently with the following message in the as_server.log 

CAUAJM_E_18402 ORA-01652: unable to extend temp segment by 128 in tablespace TEMPORARY_DATA
CAUAJM_I_18403 Processing OCI function not used(4)
CAUAJM_W_10900 The database monitoring system has detected a potential problem with the database.
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <857>
CAUAJM_I_10901 The database monitoring system is beginning validation of database connections.
CAUAJM_E_10656 The database <UDAUTO01> has encountered a critical error. Please contact the database administrator.
CAUAJM_E_40317 Unable to communicate with any database.  Shutting down.
CAUAJM_I_10902 The database monitoring system has completed validation of database connections.
CAUAJM_I_10903 The database monitoring system will resume monitoring for database problems.
CAUAJM_I_10493 CA EEM security session terminated.
CAUAJM_I_30004 CA WAAE Application Server shutdown complete.
CAUAJM_I_30000 CA WAAE Application Server exiting.

Environment

Component : Autosys Workload Automation

Cause

The issue is due to a failure in allocating the extent for the temp segment in the tablespace.

The temp segment refers to a temporary tablespace used internally by the Oracle database

Resolution

Oracle database administrator should be able to address the issue by adding more capacity/extending the tablespace TEMPORARY_DATA.

Additional Information

Contact Oracle Database Administrator

Oracle reference -

Resumable error: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP(Doc ID 2383721.1)

https://support.oracle.com/knowledge/Oracle%20Cloud/2383721_1.html