Oracle

oracle 19.12.2 datapatch hitting error: PDB$SEED(2):ORA-1652: unable to extend temp segment by 128 in tablespace TEMP [PDB$SEED]

Problem:

    The following interim patches will be applied:
      33561310 (OJVM RELEASE UPDATE: 19.14.0.0.220118 (33561310))

DBD::Oracle::st bind_param failed: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP (DBD ERROR: OCILobWrite in dbd_rebind_ph_lob) [for Statement "BEGIN
           INSERT INTO sys.dba_registry_sqlpatch_ru_info
             (patch_id,
              patch_uid,
              patch_descriptor,
              ru_version,
              ru_build_description,
              ru_build_timestamp,
              patch_directory)
           VALUES
             (:patch_id,
              :patch_uid,
              :patch_descriptor,
              :ru_version,
              :ru_build_description,
              TO_TIMESTAMP(:ru_build_timestamp, 'YYMMDDHH24MISS'),
              :patch_directory);
           COMMIT;
         END;" with ParamValues: :patch_descriptor=OCIXMLTypePtr=SCALAR(0x3c6bae0), :patch_directory='PK.........(2Tې.᤮..¾r......33494256_apply.sqlˮ[oچ.@࠽+񂫮6¼Kڠu.51`ɮ嵛}.(...."C.l5毟!š¨Kº.W....Z±ţ3ޜ9.򯔮.o~.ݜ.¸}.ֻ...
                           ܯ´³,.
?.2¡ݥ¹.y¿լɮئ㼲mg`Y.{񧹫Ĩ¨Ʃꮊ`ʵ.µ.ljʹ򣮫.V|.«ON預Fğ'¿.]~.jw8Vo....ij[񎵿þюӭ'^4)ݼЖ¯󴰐򜰤}_񻲮¥񳏮y8.8}©.𲳷.񲯭b¬>\^þ ©.W¯ܲ䤯l¼;¼.ޜ¾[!T7ֲ0=?򑸽+򷥿l|¡6.½)¿嵺rþﬦ𤟡¼$.¿>󾯒𵭷ru1..O_n~Ʃ簼ysv;.\.ݾ8{;󩷳q~6..ݟ..þ$ۮjgᯫ񺾽¹¾Ю¾
                                                                                            <ǷgW_o߈ϏN~.¾½.U.e,¼\D񭔥ß...εv...ޞ\
¦I1Q.O«?$.G"󣧋󶪟
î°򸆽.
þ.W±ݜ.tĢ箯Odr¿>yuӤ.h..Zþɖ...䢮ʤ¯.]ܮodv../®GZ)齃΍pt;..¿.^.Ǯ%m¾þj".ɮ.i..._yA.̟M.³9鴭Cw'.
                                                                                     ⊩¼­J§§'ϻ󮯵·£鮳_..۰秺f򉺮	ؾ.¿?}..
                       c.½뮪ǝ1񭭮l.{𬮍®G¯󓀡..zþ§,̅u񍆝..§·*.	̮.µiꧭ.p.ٮX.®mۦ
        µi篮񼹑l.ä. פ¡.....».X..Ŵ.걳..jԐu¶౹.µi                         ·¹
ۮݮ¤شMŴ.6ܦ.$֦m𻾣..Ǥ6 ֤ӷ¬#µ?.cr..kеt³w.˨0&·..&+2½¯꼒.r/.Ůaڲ..Ŧ𛳻͡.n.b.񝞁µ½D.ްW¦з.㴸...', :patch_id='33494256', :patch_uid='24593356', :ru_build_description='Release_Update_Revision', :ru_build_timestamp='220113181912', :ru_version='19.12.2.0.0'] at /u01/app/oracle/product/19.12.2/dbhome_1/sqlpatch/sqlpatch.pm line 5830.


Please refer to MOS Note 1609718.1 and/or the invocation log

Solution:

alter database tempfile '+xxx/temp.1724.1033209735' autoextend on next 1g maxsize unlimited;

ORA-1652 When Running Datapatch and ORA-600[4736] when Attempting to Resize Tempfile (Doc ID 2267731.1)

Basically the PDB$SEED default temp size only 64M would cause problems sooner or later.