"unable to extend temp segment by 16 in tablespace TEMP" Error While Applying Large Patch like 12.1 HRMS RUP9 (Doc ID 2149930.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Payroll - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1 HRMS RUP8 version, Patch Application Issues

When applying large patch like  HR_PF.B RUP9(21980909), the following error in the file paypay.odf may occur

ERROR
-----------------------

From adpatch.log,

FAILED: file paypay.odf on worker 1.

From adwoker001.log,


CREATE INDEX HR.PAY_RUN_RESULTS_N50 ON HR.PAY_RUN_RESULTS
(ASSIGNMENT_ACTION_ID, ELEMENT_TYPE_ID, SOURCE_TYPE, STATUS) LOGGING
STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 0 INITRANS 11 MAXTRANS
255 COMPUTE STATISTICS PARALLEL TABLESPACE APPS_TS_TX_IDX

AD Worker error:
The following ORACLE error:

ORA-12801: error signaled in parallel query server P000
ORA-01652: unable to extend temp segment by 16 in tablespace TEMP


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply large patch like HR_PF.B RUP9(21980909)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms