SQL Script NONCDB_TO_PDB.SQL Fails with ORA-600 [kqlobjlod-no-result-from-proc$] (Doc ID 2125647.1)

Last updated on APRIL 15, 2016

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

Database was successfully upgraded to 12.1.0.2 (non-CDB). Now trying to convert the database to PDB using the noncdb_to_pdb.sql script this fails with errors like below in the alert log:

Sat Apr 02 01:51:57 2016
Errors in file /u01/app/oracle/diag/rdbms/crac01a/CRAC01A1/trace/CRAC01A1_j020_17094.trc (incident=6297) (PDBNAME=PDB_BSM):
ORA-00600: internal error code, arguments: [kqlobjlod-no-result-from-proc$], [1403], [1779778], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/crac01a/CRAC01A1/incident/incdir_6297/CRAC01A1_j020_17094_i6297.trc
...
Sat Apr 02 01:52:02 2016
Errors in file /u01/app/oracle/diag/rdbms/crac01a/CRAC01A1/trace/CRAC01A1_j020_17094.trc (incident=6298) (PDBNAME=PDB_BSM):
ORA-00600: internal error code, arguments: [kqlobjlod-no-result-from-proc$], [1403], [1779778], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_UTILITY", line 1294
ORA-06512: at line 1
Incident details in: /u01/app/oracle/diag/rdbms/crac01a/CRAC01A1/incident/incdir_6298/CRAC01A1_j020_17094_i6298.trc
Sat Apr 02 01:52:04 2016


The trace with the ORA-600 file shows next characteristics:

----- Current SQL Statement for this session (sql_id=d1s02myktu19h) -----

begin dbms_utility.validate(:1,:2,:3,:4); end;
[TOC00005]


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

object line object
handle number name
0x2b7288cd0 1294 package body SYS.DBMS_UTILITY
0x2b36b2290 1 anonymous block
0x2a5e7e330 413 package body SYS.UTL_RECOMP
0x2a5e7e330 559 package body SYS.UTL_RECOMP
0x2a5e7e330 807 package body SYS.UTL_RECOMP
0x2b960d288 4 anonymous block
[TOC00005-END]
[TOC00004-END]

[TOC00006]
----- Call Stack Trace -----

... kqlLoadAuditingOptions kglspsld kqllod_new kqllod kglobld kglobpn kglpim kglpin kglgob psd_validate pevm_icd_call_common pfrinstr_ICAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe opipls opiodr rpidrus skgmstack rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool pfrrun plsql_run ...

 

Changes

Non-CDB database was tried to convert to PDB using the ?/rdbms/admin/noncdb_to_pdb.sql script.

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