Oracle 12c Show Con_name

An Oracle 12c database was installed today for testing, and an error occurred while running a very simple command:

SQL>  Show Con_nameconcat "." (Hex 2e) SP2-0158option "_name"

Internet search for a long time also did not search, in Google incredibly only found a record, is a French blog, but it seems that he did not write the reason for the mistake. Finally looked at the operation of their own, found that is the following,

[[email protected] profile]$ sqlplus/  asSysdbasql*Plus:release 11.2. 0.4. 0 Production onWed6  the: -: -  theCopyright (c)1982, -, Oracle. Allrights reserved. Connected to: OracleDatabase12c Enterprise Edition Release12.1.0.1.0 -64bitProduction withThe partitioning, OLAP, Advanced Analytics and RealApplication Testing Optionssql>show Con_nameconcat "." (Hex 2e) SP2-0158: Unknown SHOWoption"_name" SQL>

It can be found that the Sqlplus is 11g. Although the Sqlplus is 11g, but the connection is 12c database, this is because I set the environment variable when only set the Oracle SID and Oracle home does not set path. The 11g Sqlplus does not recognize the 12c command. So you need to use the following method.

[[email protected] profile]$/U01/App/Oracle/Product/12c/Bin/Sqlplus/  asSysdbasql*Plus:release12.1.0.1.0Production onWed6  the: A: One  theCopyright (c)1982, -, Oracle. Allrights reserved. Connected to: OracleDatabase12c Enterprise Edition Release12.1.0.1.0 -64bitProduction withThe partitioning, OLAP, Advanced Analytics and RealApplication Testing Optionssql>Show Con_namecon_name------------------------------Cdb$rootsql>