Unexpected CON_NAME Returned if Connecting to Non-Consolidated Database in Release 22.214.171.124 and higher
Last updated on JANUARY 23, 2018
Applies to:SQL*Plus - Version 126.96.36.199 and later
Information in this document applies to any platform.
According to the following documentation (SQL*Plus User's Guide 12.1 and 12.2) :
SQL*Plus User's Guide and Reference
Displays the name of the Container to which you are connected when connected
to a Consolidated Database. For non-consolidated database, it will return
If connecting to non-consolidated database, CON_NAME will return as "Non Consolidated", but from release 188.8.131.52 the value of sys_context will be returned.
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