ORA-600 [17287] When Opening Pluggable Database or Dropping User in Pluggable Database (Doc ID 1929389.1)

Last updated on JANUARY 26, 2017

Applies to:

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

Symptoms

Open of pluggable database fails with ORA-600 [17287] in the alert log like below:

...
Tue Sep 23 10:34:34 2014
alter pluggable database all open
Tue Sep 23 10:34:34 2014
This instance was first to open pluggable database PDPOCPA (container=3)
Database Characterset for PDPOCPA is AL32UTF8
Errors in file /u01/app/oracle/diag/rdbms/cdpocp/cdpocp2/trace/cdpocp2_ora_8943.trc  (incident=10257) (PDBNAME=PDPOCPA):
ORA-00600: internal error code, arguments: [17287], [0x7F5191BC68E8], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/cdpocp/cdpocp2/incident/incdir_10257/cdpocp2_ora_8943_i10257.trc
...


The current sql form the trace shows the issue is related to dropping a user:

Current SQL Statement:
begin "SYS"."OJDS_CONTEXT"."USER_DROPPED"(:myuser); end;


The call stack from the trace file shows functions like:

... kgiinb pfri3_inst_body pfrrun plsql_run peicnt kkxexe opiexe opiodr rpidrus skgmstack rpiswu2 rpidrv rpiexe kzdukl kzudrp opiexe opiosq0 opiall0 opikpr opiodr rpidrus skgmstack rpiswu2 kprball kpdbSyncExec kpdbSyncDropUser kpdbsReplayCbk kpdbSwitch kpdbsGetCommonDDLCbk kpdbSwitch kpdbsGetCommonDDL kpdbSyncPDB kpdbaOpenSync kpdbaSwitchOpenClose kpdbSwitchRunAsSysCbk rpiswu2 kpdbSwitch kpdbaOpenPdb kpdbaOpenClose kpdbaChangePDBState kpdbaSwitchStateFromRoot kpdbadrv opiexe opiosq0 kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main

 

The object "SYS"."OJDS_CONTEXT" is also found to be invalid:

 

Changes

The default tablespace USERS has been dropped/replaceD for a bigfile tablespace.

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