datapatch fails with Error :'ORA-00600: internal error code, arguments: [17287] ,[SYS], [DBMS_SQLPATCH]','ORA-04063: package body "SYS.DBMS_SQLPATCH" has errors'
(Doc ID 2977570.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.16.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
datapatch is failing with error:
BOOTSTRAP/PREREQ FAILURES:
The following PDBs encountered an error during the pre-patching
stage and are not being patched. Please review the errors shown
and invoke datapatch for these PDBs after fixing the errors.
PDB$SEED: DBD::Oracle::st execute failed: ORA-00600: internal error code, arguments: [17287], [0x7FEF02BD7C68], [0x0AF4A4588], [], [SYS], [DBMS_SQLPATCH], [11], [1], [], [], [], [] (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN
:build_label := 'NONE';
:dbmssqlpatch_header := 'NONE';
:prvtsqlpatch_header := 'NONE';
:dbmsqopi_header := 'NONE';
:prvtqopi_header := 'NONE';
The following PDBs encountered an error during the pre-patching
stage and are not being patched. Please review the errors shown
and invoke datapatch for these PDBs after fixing the errors.
PDB$SEED: DBD::Oracle::st execute failed: ORA-00600: internal error code, arguments: [17287], [0x7FEF02BD7C68], [0x0AF4A4588], [], [SYS], [DBMS_SQLPATCH], [11], [1], [], [], [], [] (DBD ERROR: OCIStmtExecute) [for Statement "BEGIN
:build_label := 'NONE';
:dbmssqlpatch_header := 'NONE';
:prvtsqlpatch_header := 'NONE';
:dbmsqopi_header := 'NONE';
:prvtqopi_header := 'NONE';
SQL> select * from OPATCH_XML_INV ;
XML_INVENTORY
--------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <InventoryInstance> <ora
XML_INVENTORY
--------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <InventoryInstance> <ora
SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;
select dbms_sqlpatch.verify_queryable_inventory from dual
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_SQLPATCH" has errors
select dbms_sqlpatch.verify_queryable_inventory from dual
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_SQLPATCH" has errors
Changes
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 |