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

Last updated on MAY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
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 alert log shows info like:

alter pluggable database "NYMWH31" close IMMEDIATE instances = all
ORA-65020 signalled during: alter pluggable database "NYMWH31" close IMMEDIATE instances = all...
alter pluggable database "NYMWH31" open upgrade
Tue Jul 14 17:25:20 2015
Database Characterset for NYMWH31 is WE8ISO8859P15
Errors in file /db01/app/oracle/diag/rdbms/nymwh31c/nymwh31c/trace/nymwh31c_ora_30802126.trc  (incident=19389) (PDBNAME=NYMWH31):
ORA-00600: internal error code, arguments: [16201], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /db01/app/oracle/diag/rdbms/nymwh31c/nymwh31c/incident/incdir_19389/nymwh31c_ora_30802126_i19389.trc
Tue Jul 14 17:25:30 2015
Dumping diagnostic data in directory=[cdmp_20150714172530], requested by (instance=1, osid=39649375), summary=[incident=19389].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Jul 14 17:25:30 2015
Pdb NYMWH31 hit error 600 during open read write (1) and will be closed.
Tue Jul 14 17:25:30 2015
Errors in file /db01/app/oracle/diag/rdbms/nymwh31c/nymwh31c/trace/nymwh31c_ora_30802126.trc:
ORA-00600: internal error code, arguments: [16201], [], [], [], [], [], [], [], [], [], [], []
ALTER SYSTEM: Flushing buffer cache inst=0 container=3 local
ORA-600 signalled during: alter pluggable database "NYMWH31" open upgrade...
Tue Jul 14 17:25:37 2015


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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms