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.
Component : Autosys Workload Automation
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
Oracle database administrator should be able to address the issue by adding more capacity/extending the tablespace TEMPORARY_DATA.
Contact Oracle Database Administrator
Oracle reference -
https://support.oracle.com/knowledge/Oracle%20Cloud/2383721_1.html