My Oracle Support Banner

ORA-600 [16201] Running "noncdb_to_pdb.sql" Script (Doc ID 2039530.1)

Last updated on OCTOBER 08, 2020

Applies to:

Oracle Database Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Below error is thrown when running noncdb_to_pdb.sql:

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


The incident trace files shows a current sql and call stack like:

----- Current SQL Statement for this session (sql_id=905yx037acjvp) -----
select distinct subscription_name, namespace from reg$


----- Call Stack Trace -----
... kqlLoadAuditingOptions kglspsld kqlCallback kqlobjlod kqllod_new kqlCallback kqllod kglobld kglobpn kglpim IPRA.$kglpin kglgob IPRA.$kzpchkc IPRA.$kzpchkc kzpchkbu_internal ksfchk kglchk3 kglchk2 kglchk1 qcsCheckPriv qcsbxl qcspqbDescendents qcspqb kkmdrv opiSem opiDeferredSem opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 opiall0 opikpr opiodr rpidrus skgmstack rpidru rpiswu2 kprball kkcnrini kponPdbNfy kscdnfy kpdbaSwitchOpenClose kpdbSwitchRunAsSysCbk rpiswu2 kpdbSwitch kpdbaOpenPdb kpdbaOpenClose kpdbaChangePDBState kpdbaSwitchStateFromRoot kpdbSwitch kpdbaChangeStateCurrentPDB kpdbadrv opiexe ...

  

Changes

The first run of noncdb_to_pdb.sql failed due to an ORA-4031, e.g.

ORA-04031: unable to allocate 289080 bytes of shared memory ("shared pool","DBMS_STATS","PLSRC^1c8c4f2d","pl/sql source")


Subsequently
the noncdb_to_pdb.sql was re-run after increasing the memory (SGA) which raised the ORA-600 [16201]

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

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