My Oracle Support Banner

Unexpected CON_NAME Returned if Connecting to Non-Consolidated Database in Release 12.1.0.2 and higher (Doc ID 2350093.1)

Last updated on MAY 26, 2023

Applies to:

SQL*Plus - Version 12.1.0.2 and later
Information in this document applies to any platform.Symptoms

According to the following documentation (SQL*Plus User's Guide 12.1 and 12.2) :

https://docs.oracle.com/database/121/SQPUG/E18404-12.pdf
SQL*Plus User's Guide and Reference
Release 12.1
E18404-12

CON_NAME
Displays the name of the Container to which you are connected when connected
to a Consolidated Database. For non-consolidated database, it will return
"Non Consolidated".

 
If connecting to non-consolidated database, CON_NAME will  return as "Non Consolidated", but from release 12.1.0.2 the value of sys_context will be returned.

For Example:

 

 

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
Cause
Solution
References


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