My Oracle Support Banner

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

Last updated on MAY 26, 2023

Applies to:

SQL*Plus - Version 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) :
SQL*Plus User's Guide and Reference
Release 12.1

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 the value of sys_context will be returned.

For Example:




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

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