My Oracle Support Banner

"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 JULY 17, 2024

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.