ORA-00600:[17287] even after applying patch 29972176 (Doc ID 2689946.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

SQL> ALTER PLUGGABLE DATABASE PDBD_APPLICATION1 OPEN READ WRITE INSTANCES=ALL;

ALTER PLUGGABLE DATABASE PDBD_APPLICATION1 OPEN READ WRITE INSTANCES=ALL

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []

Patch applied 29972176

Customer was getting error again after that

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.6.0.0.0

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDBR                           MOUNTED

4 PDBD                           MOUNTED

SQL> alter pluggable database PDBD_CODETEST open instances=ALL;

alter pluggable database PDBD_CODETEST open instances=ALL

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [17287], [0x7FFFF2669708], [], [], [], [], [], [], [], [], [], []

===========================

*** 2020-02-26T15:59:54.260467+00:00

dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)

[TOC00003]

----- Current SQL Statement for this session (sql_id=35wx0ztzd89yj) -----

begin gsmadmin_internal.dbms_gsm_cloudadmin.syncParameters; end;

[TOC00004]

----- PL/SQL Stack -----

----- PL/SQL Call Stack -----

object line object

handle number name

0x71c8ee28 1 anonymous block

[TOC00004-END]

[TOC00003-END]

Changes

Customer has perfrmed this action after every clone

As our security standards require us to revoke execute privileges on the following packages from PUBLIC:

utl_file, utl_smtp, utl_http, utl_tcp

Per the oracle support note 1577002.1

the list of users that need to have execute privileges granted individually is limited to the following users:

XDB,WMSYS,CTXSYS,ORDSYS,MDSYS,OLAPSYS,DVSYS,LBACSYS

Even after running individual grants, there are invalid objects under gsmadmin_internal. After running individual grants for GSMADMIN_INTERNAL, compilation of invalid objects completed successfully.

Based on this document

Action Plan(ORA-00600 [17287] After Restore/ Recovery Made From the Cloud Console (OCI DBCS) (Doc ID 2606522.1))

To resolve this error catalog and catproc script executed after clone. 

Cause

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