ORA-1652 When Running Datapatch And ORA-00600 [4736] [tempfile_AFN] When Attempting to Resize Tempfile (Doc ID 2267731.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

On 12.1.0.2, during the installation of a patch in a Multitenant environment, the following error occurs when attempting to run the datapatch script:

alter pluggable database pdb$seed OPEN READ WRITE
Thu May 18 06:52:56 2017
This instance was first to open pluggable database PDB$SEED (container=2)
Database Characterset for PDB$SEED is WE8MSWIN1252
Opening pdb PDB$SEED (2) with no Resource Manager plan active
Pluggable database PDB$SEED opened read write
Completed: alter pluggable database pdb$seed OPEN READ WRITE
Thu May 18 06:53:26 2017
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP [PDB$SEED]
statement in resumable session 'User SYS(0), Session 102, Instance 1' was suspended due to
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP


And trying to resize the temp file to fix the error ORA-1652,  the resize operation fails with an ORA-600 [4736] error:

 

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