ORA-3113/ORA-600[18062] connecting to pluggable database when global_name has been set to NULL (Doc ID 2083851.1)

Last updated on JANUARY 03, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

 An attempt to connect to a pluggable database from sqlplus will fail with the following errors:

SQL> alter session set container=bp1;
alter session set container=bp1
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 28883
Session ID: 1 Serial number: 8383

The alert.log will show the following error:

See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/bc121b/BC121B/trace/BC121B_ora_18800.trc (incident=407) (PDBNAME=BP1):
ORA-00600: internal error code, arguments: [18062], [], [], [], [], [], [], [], [], [], [], []

An attempt to connect to the pub using a tnsalias will fail with the above ORA-600 error:

sqlplus system/manager1@bp1

SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 30 22:05:10 2015

Copyright (c) 1982, 2014, Oracle. All rights reserved.

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

 

Changes

 The global_name of the pluggable database has been set to NULL:

SQL> select nvl(value$,'NULL') from containers(props$) where name = 'GLOBAL_DB_NAME';

NVL(VALUE$,'NULL')
--------------------------------------------------------------------------------
BP2.ME
NULL
MYDB.ME

 

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