My Oracle Support Banner

Datapatch fails with Error "Error: prereq checks failed! patch xxxxxxx: Error reading descriptor from registry: encoding specified in XML declaration is incorrect " (Doc ID 2876712.1)

Last updated on MAY 30, 2024

Applies to:

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

Symptoms

Datapatch verbose fails with below error-

[oracle@localhost OPatch]$ <ORACLE_HOME>/OPatch/datapatch -verbose
SQL Patching tool version 19.13.0.0.0 Production on Mon Jun 13 02:44:52 2022
Copyright (c) 2012, 2021, Oracle. All rights reserved.

Log file for this invocation: <ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_215366_2022_06_13_02_44_52/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
No interim patches found

Current state of release update SQL patches:
Binary registry:
No release update patches installed
SQL registry:
Applied 19.10.0.0.0 Release_Update 210108185017 successfully on 23-APR-21 09.18.41.495842 AM

Error: prereq checks failed!
patch 32218454: Error reading descriptor from registry:
encoding specified in XML declaration is incorrect at line 1, column 30, byte 60 at <ORACLE_HOME>/perl/lib/site_perl/5.28.1/x86_64-linux-thread-multi/XML/Parser.pm line 187.
XML::Simple called at <ORACLE_HOME>/sqlpatch/sqlpatch.pm line 8041.

Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 and/or the invocation log
<ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_215366_2022_06_13_02_44_52/sqlpatch_invocation.log
for information on how to resolve the above errors.

 sqlpatch_invocation log shows below error blocks-

Current state of release update SQL patches:
[2022-06-13 02:45:02] Binary registry:
[2022-06-13 02:45:02] No release update patches installed
[2022-06-13 02:45:02] SQL registry:
[2022-06-13 02:45:02] Applied 19.10.0.0.0 Release_Update 210108185017 successfully on 23-APR-21 09.18.41.495842 AM
[2022-06-13 02:45:02]
[2022-06-13 02:45:02] Error: prereq checks failed!
[2022-06-13 02:45:02] patch 32218454: Error reading descriptor from registry:
encoding specified in XML declaration is incorrect at line 1, column 30, byte 60 at <ORACLE_HOME>/perl/lib/site_perl/5.28.1/x86_64-linux-thread-multi/XML/Parser.pm line 187.
XML::Simple called at <ORACLE_HOME>/sqlpatch/sqlpatch.pm line 8041.

[2022-06-13 02:45:02] Prereq check failed, exiting without installing any patches.

'32218454/24018797' => {
'apply_script' => '<ORACLE_HOME>/sqlpatch/32218454/24018797/32218454_apply.sql',
'installed_binary' => 0,
'logdir' => '<ORACLE_BASE>/cfgtoollogs/sqlpatch/32218454/24018797/',
'patch_key' => '32218454/24018797',
'patchdir' => '<ORACLE_HOME>/sqlpatch/32218454/24018797',                    <<<<<<<<<<<<<<
'patchid' => '32218454',
'patchuid' => '24018797',
'pdb_info' => {
'TESTDB' => {
'last_action_time' => '23-APR-21 09.18.41.495842 AM',
'ru_info' => 1,
'sql_state' => 'APPLY/SUCCESS'
}
},
'prereq_failed_reason' => 'Error reading descriptor from registry:
encoding specified in XML declaration is incorrect at line 1, column 30, byte 60 at <ORACLE_HOME>/perl/lib/site_perl/5.28.1/x86_64-linux-thread-multi/XML/Parser.pm line 187.
XML::Simple called at <ORACLE_HOME>/sqlpatch/sqlpatch.pm line 8041.

 

Changes

 Below Patches installed in OH-

oracle@localhost ~]$ <ORACLE_HOME>/OPatch/opatch lspatches
33192793;Database Release Update : 19.13.0.0.211019 (33192793)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)

registry$sqlpatch output-

SQL> select PATCH_ID,ACTION,STATUS,ACTION_TIME,DESCRIPTION from registry$sqlpatch order by ACTION_TIME;

PATCH_ID ACTION STATUS ACTION_TIME DESCRIPTION
----------------------------------------------------------------------------------------------------------------------------
32218454 APPLY SUCCESS 23-APR-21 09.18.41.495842 AM Database Release Update : 19.10.0.0.210119 (32218454)

 

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
References


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