Datapatch fails with "ORA-08103: object no longer exists" and jumbled/garbage characters
(Doc ID 2928977.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Datapatch fails with highlighted error -
Installation queue:
The following interim patches will be rolled back:
32876380 (OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380))
Patch 34419443 (Database Release Update : 19.17.0.0.221018 (34419443)):
Apply from 19.12.0.0.0 Release_Update 210716141810 to 19.17.0.0.0 Release_Update 220924224051
The following interim patches will be applied:
34411846 (OJVM RELEASE UPDATE: 19.17.0.0.221018 (34411846))
DBD::Oracle::st execute failed: ORA-08103: object no longer exists
ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute) [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(0x39bc5f0), :patch_directory='PK........Í.QU§Ñ·AR...Bá......34419443_apply.sqlÍ.[s.Ⱥ@ßý+xØ5.©ÊL¸Jâ¤æÔö$..T9vÊvö>û¼¨.'‰...dkRóãO.hŒ.ɱ .Ë.)Ù±Äòâë+Ý__Oo.ëéÕ¿¦W..n>~ºQ./NN®¦..³$ .R27 .\¹S%qrw©.¦©Ù¦i¼ÖM{¬«cëäÝô÷÷.S%Œ.·Aè{Aªüªü ..¼½<.ôáBÉîÃò.³ê..‹é¿g.:;.4Un×a(.|rr==.¾½QN.xú¤Såï¿.SyÉ.S ÍŠ..(Û¯·g×Såß.N/..³¿²..¯r...xºÎüÔ_=.¾RN]o>[9..ú.òþZ¹øt~þ."ß^~Ý.o/~cç§ÓsñÉÅOK.ò¢Jê'¡ãú_¿T¼ª.%¾ùÇéO;.¨L/Þ..rs9{ûçÙUñ!y.ùYîD‰øõÙ.Ä×.xõîÝìÏ?usöáýìúúôÕîG.^._ÏÞ.ÝLgçg..|:ûcúëÙ.éÕû·g.âÏûûïÓ_.»SåìúÀºø.߯.?(..ð.Ü.;..F..xyy®ü°..n..â.¯ß.ïTQë»r.;i.¬.Jy.¾..J¼R.÷èú?×7ï?L¯oÎ>|ÜBxk'|³{!M=9ùmúÇû‹ò]Þ<ÊfòOøeû..« ..0øâ..̪.yÛ+üúß5Å.°ã_òýëê.Äû%ü3ß/c¹¾þé.ÅÓ.Þ..ÛýæäõI]...¸ÕâWöÊ.ø+gÛB&~õìüfz%ŠãõõûË^K¥.ôöÓÕÕôâfvýöÏé.3Q².Í7_½IoÅ.Š{..._;^.¬^Ï׋.n.'¦¦.f‰.áÒ©¸¬¼OÏ¿A.Å.}¼QÞ.qqyuöÛùT.^]]^]..R.ÞÝ.×ü..<}...c.½Í7ÊÈÝ2ýó.?ônl.çKñ³..]\^L_ì©.B03wÜ»$NóòòYu.UC7ñ¶r&8{.$Ö¦®êæH.ÛÜ.ÄÚ´tS...Áë¼ç.BM..¦Ú.aaM..BMêöÈ4M}./áû.X..‰èE¨Ø¸<...4TCµ&.®ÉC@®IMÕì~êÊ®Jø!$Ö¦¥M4Í.Çå> Ö¤èmh6»oy.Iµ©©ªfZðR~.‰µ©iF_6»1¹.È5i.b...Ë}H¬Í.>.´½Ø.ßþ¬êúØêFé>)W©a«.~.´#.{.X.ã.já‹ú>$ÖæD.Œ.‹ú«âÕÈRm½.¹ûÌX¹¶>......', :patch_id='34419443', :patch_uid='24972075', :ru_build_description="Release_Update", :ru_build_timestamp="220924224051", :ru_version="19.17.0.0.0"] at $ORACLE_HOME/sqlpatch/sqlpatch.pm line 5018.
The following interim patches will be rolled back:
32876380 (OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380))
Patch 34419443 (Database Release Update : 19.17.0.0.221018 (34419443)):
Apply from 19.12.0.0.0 Release_Update 210716141810 to 19.17.0.0.0 Release_Update 220924224051
The following interim patches will be applied:
34411846 (OJVM RELEASE UPDATE: 19.17.0.0.221018 (34411846))
DBD::Oracle::st execute failed: ORA-08103: object no longer exists
ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute) [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(0x39bc5f0), :patch_directory='PK........Í.QU§Ñ·AR...Bá......34419443_apply.sqlÍ.[s.Ⱥ@ßý+xØ5.©ÊL¸Jâ¤æÔö$..T9vÊvö>û¼¨.'‰...dkRóãO.hŒ.ɱ .Ë.)Ù±Äòâë+Ý__Oo.ëéÕ¿¦W..n>~ºQ./NN®¦..³$ .R27 .\¹S%qrw©.¦©Ù¦i¼ÖM{¬«cëäÝô÷÷.S%Œ.·Aè{Aªüªü ..¼½<.ôáBÉîÃò.³ê..‹é¿g.:;.4Un×a(.|rr==.¾½QN.xú¤Såï¿.SyÉ.S ÍŠ..(Û¯·g×Såß.N/..³¿²..¯r...xºÎüÔ_=.¾RN]o>[9..ú.òþZ¹øt~þ."ß^~Ý.o/~cç§ÓsñÉÅOK.ò¢Jê'¡ãú_¿T¼ª.%¾ùÇéO;.¨L/Þ..rs9{ûçÙUñ!y.ùYîD‰øõÙ.Ä×.xõîÝìÏ?usöáýìúúôÕîG.^._ÏÞ.ÝLgçg..|:ûcúëÙ.éÕû·g.âÏûûïÓ_.»SåìúÀºø.߯.?(..ð.Ü.;..F..xyy®ü°..n..â.¯ß.ïTQë»r.;i.¬.Jy.¾..J¼R.÷èú?×7ï?L¯oÎ>|ÜBxk'|³{!M=9ùmúÇû‹ò]Þ<ÊfòOøeû..« ..0øâ..̪.yÛ+üúß5Å.°ã_òýëê.Äû%ü3ß/c¹¾þé.ÅÓ.Þ..ÛýæäõI]...¸ÕâWöÊ.ø+gÛB&~õìüfz%ŠãõõûË^K¥.ôöÓÕÕôâfvýöÏé.3Q².Í7_½IoÅ.Š{..._;^.¬^Ï׋.n.'¦¦.f‰.áÒ©¸¬¼OÏ¿A.Å.}¼QÞ.qqyuöÛùT.^]]^]..R.ÞÝ.×ü..<}...c.½Í7ÊÈÝ2ýó.?ônl.çKñ³..]\^L_ì©.B03wÜ»$NóòòYu.UC7ñ¶r&8{.$Ö¦®êæH.ÛÜ.ÄÚ´tS...Áë¼ç.BM..¦Ú.aaM..BMêöÈ4M}./áû.X..‰èE¨Ø¸<...4TCµ&.®ÉC@®IMÕì~êÊ®Jø!$Ö¦¥M4Í.Çå> Ö¤èmh6»oy.Iµ©©ªfZðR~.‰µ©iF_6»1¹.È5i.b...Ë}H¬Í.>.´½Ø.ßþ¬êúØêFé>)W©a«.~.´#.{.X.ã.já‹ú>$ÖæD.Œ.‹ú«âÕÈRm½.¹ûÌX¹¶>......', :patch_id='34419443', :patch_uid='24972075', :ru_build_description="Release_Update", :ru_build_timestamp="220924224051", :ru_version="19.17.0.0.0"] at $ORACLE_HOME/sqlpatch/sqlpatch.pm line 5018.
[2023-02-02 20:42:16] *** START final state end of patching **
Changes
TEMPFILE added to TEMP Tablespace and Datapatch was executed , but resulted in same error.
hcheck Utility did not show any Data Dictionary inconsistency.
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 |
| Changes |
| Cause |
| Solution |