Oracle client, Oracle version not simultaneous login performance

*********************************************** Declaration **********************************************

original works, from the "Deep Blue Blog" blog, Welcome Reprint, please be sure to indicate the source when reproduced , otherwise be held responsible for copyright law.

Please leave a message or email ([email protected]) to indicate the error.

This reprint must be kept here: http://blog.csdn.net/huangyanlong/article/details/39216069

Deep Blue Blog:http://blog.csdn.net/huangyanlong

***************************************************************************************************

1.10g Client Login 11g library phenomenon

[Email protected]~]$ sqlplus scott/[email protected]/hyl

--sqlplus username/Password @ hostname/Database service Name

Sql*plus:release 10.2.0.1.0-production on Sun Sep 7 08:57:23 2014

Copyright (c) 1982, 2005, Oracle. All rightsreserved.

Connectedto:

Oracledatabase 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

Withthe partitioning, OLAP, Data Mining and Real application testing options

Sql>select comp_name,version,status from Dba_registry;

--The version of the view database is 11.2.0.4.0, and the client that corresponds to the login is 10.2.0.1.0

Sql>quit

--The version of the database is also displayed when you exit the database

Disconnectedfrom Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bitproduction

Withthe partitioning, OLAP, Data Mining and Real application testing options

Add one point: How to get other users to access the data dictionary

Sql>show parameter O7

NAME TYPE VALUE

----------------------------------------------- ------------------------------

O7_dictionary_accessibility Boolean FALSE

Sql>alter system set o7_dictionary_accessibility=true scope=spfile;

Sql>show parameter O7

NAME TYPE VALUE

----------------------------------------------- ------------------------------

O7_dictionary_accessibility Boolean TRUE

2.11g Client Login 10g library phenomenon

Summary:

Note Using the Sqlplus login database, do not confuse the Sqlplus and the database version, the two are different concepts.

3. Supplemental TIP: Database authentication format

1, operating system certification: By default, the local server landed Oracle database, using operating system authentication, do not enter the database user name and password,

The login format is usually: Sql>sqlplus/as sysdba

2, the user password Authentication: When the user remote connection database, need to use the database user name, password authentication before you can log in,

such as: Sql>sqlplus Scott/tiger as Sysdba

*********************************************** Declaration **********************************************

original works, from the "Deep Blue Blog" blog, Welcome Reprint, please be sure to indicate the source when reproduced , otherwise be held responsible for copyright law.

Please leave a message or email ([email protected]) to indicate the error.

This reprint must be kept here: http://blog.csdn.net/huangyanlong/article/details/39216069

Deep Blue Blog:http://blog.csdn.net/huangyanlong

***************************************************************************************************

Oracle client, Oracle version not simultaneous login performance