datapatch Failed with Error:"ORA-25153: Temporary Tablespace is Empty" and also there are Junk Characters.

(Doc ID 2285159.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

datapatch execution failed tempfile in temporary tablespace is empty in PDB$SEED and also it shows junk characters :

DBD::Oracle::st bind_param failed: ORA-25153: Temporary Tablespace is Empty (DBD ERROR: OCILobCreateTemporary) [for Statement "BEGIN
               dbms_sqlpatch.set_patch_metadata(
                 p_patch_id => 25397136,
                 p_patch_uid => 21203239,
                 p_superseding => FALSE,
                 p_patch_descriptor => :descriptor,
                 p_patch_directory => :directory);
             END;" with ParamValues: :descriptor=OCIXMLTypePtr=SCALAR(0x1019fd6c0), :directory='PK........Mv.J4նƴ...ͣ......25397136_apply.sqlͮ[sÈ..཮}Ѯ3Uٮ..lj׆q.ʕ.J͌ϞP.Lٰ. ӵ?~ۮV4ɮҴ}ڂ֦..ަ...����ࠎ&׳2.5.S}Hۉ.����qJ.+wȮ*˭+I..Y.ֆ.��.׫.쇮yKτ..ŷs?��ɮO..םǒd.b/"7ퟰ��иǕh��ᯤ߮ôԚ..ꠌНmގ".xrđ0��.発ئ��9ةҽ2Yb..KЫ饋;"虮ʹ⩷.��QݨҹA..k...zͷů.ҭ`��..̍~Юʮ诙jAP.IR/    ,Ȼ٤8ˊ®~in.C��.ژힴȬ#ٮzYn.    ��.ø��ٮZ汯..E^૆ҼĮ.ū<��q:..ȟ\+ج+��ʸ< g..>.让.aƟȭ4��پذ!4\ꯃ��Cݮu...ÝXµfAÐhݗ?��׮3.å٣~姾.��ʙ%ڥ    o._Q\<즫⹮ծX����.篮.Iͮ��.߮իV,Ț
». ߮..W޺NՂa؍lֲ֮ͤ毫.β쇕˶��ZӖͧGܬ%Ѻ߮ʹ)=..F.<",Xzؓɾ..FƮv깮F׵..ۣ.ѸMY0]Yn鈗��:j[.:暣..ʣu��靈Ү4.Oܯ.:ѧԱո͌ƣ}uǚ 㺮.7..˖qZ.미
..޽;;ʭ8Ю˫..s.h..خ��פʜ.ՖզI.m'y/0.JY��eծI.ۮkͮB.=O.ጱ.8��C��᧡ͮ..N.ம3%٣h® g...>抳.\&.}j=u..7Yb٨n8...ȊԈ:Jïɮ��..A.Ω¦Ȯ ˦"ڋ-׻.*AS.}ςϱ.hĘ.Ӫk`.୨.[4瞯.hM.㥯,..A̬X.ܰքծՔP.̰.��)Js߮AуV.8<t.࠷ᰮ.7~.¨ʐP͜[ɭe_ͦ.��^ʪ...'] at /u01/app/oracle/product/12.1.0.2/dbhome_1/sqlpatch/sqlpatch.pm line 3192.

You may also get error when tempfile is corrupt, then error will be shown like below:

DBD::Oracle::st bind_param failed: ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: '+DATA/ABCDQA1415/FD9AC20F64D244D7E203B6A9E80A2B2B/DATAFILE/pdbseed_temp010017-02-16_12-21-19-pm.dbf' (DBD ERROR: OCILobCreateTemporary) [for Statement "BEGIN
dbms_sqlpatch.set_patch_metadata(
p_patch_id => 24917972,
p_patch_uid => 20791781,
p_superseding => FALSE, .Ãë+àºkÆó©X."(C×(.û.±¡.¾¤l.G.ø.õñV5"¢.>.¼
L2XÅ.Hx¶|.ñÙÅéùÅùx4>9W¿¾.¢)¹1l..(ÏÊ8.Kèíñ0~\ÉP.r.Ãã.^.ü1Í.o5²ØFA(X*6R._Î.

Changes

 

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