Performance of non-simultaneous login between Oracle client and Oracle version, oracle client

Performance of non-simultaneous login between Oracle client and Oracle version, oracle client

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

Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Please leave a message or email (hyldba@163.com) indicating that there is an error. Thank you very much.

This article 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

[Oracle @ org54 ~] $ Sqlplus scott/tiger@10.53.105.65/hyl

-- Sqlplus user name/password @ host name/Database Service name

SQL * Plus: Release 10.2.0.1.0-Production on Sun Sep 7 08:57:23 2014

Copyright (c) 1982,200 5, 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;

-- Check that the database version is 11.2.0.4.0, and the client corresponding to logon is 10.2.0.1.0.

SQL> quit

-- When you exit the database, the database version is displayed.

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

Withthe Partitioning, OLAP, Data Mining and Real Application Testing options

Add: How to allow 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:

Use sqlplus to log on to the database. Do not confuse sqlplus with the database version. The two are different concepts.

3. supplemented knowledge: Database Authentication format

1. operating system authentication: by default, the local server logs on to the Oracle database and uses operating system authentication without entering the database username and password,

Login Format: SQL> sqlplus/as sysdba

2. User Password Authentication: when a user remotely connects to the database, the user name and password must be used for authentication before login,

For example: SQL> sqlplus scott/tiger as sysdba

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

Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Please leave a message or email (hyldba@163.com) indicating that there is an error. Thank you very much.

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

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

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

Oracle10 Client Login Problems

You need to modify several parameters.
1. Server IP Address
2. SID (Global Database Name)
However, I personally think that the client needs to be installed when the oracle earlier version is connected to the later version.
That is, the oracle8 client is installed to connect to the oracle10 server.
If you install the oracle8 server on your local machine, I think it will be a problem to change the tnsname directly.
I think you can try this.
1. Install the oracle8 Client
2. Configure net manager or net configuration assistant in the client
3. Try to connect.

After which version of oracle will be used for page management, that is, you can log on to the server to manage the database without installing a client.

You mean OEM, it should be from 10 Gb later

The following are from networks:
Oracle Enterprise Manager: OEM has become a Web page since the 10gb. There are two OEM types: Grid Control and Database Control ).

Grid Control is a full-featured enterprise-wide Oracle ecosystem management tool.
Database Control is an OEM version that can be deployed only as a Database management utility.

Difference between Grid Control and Database Control: Grid Control can monitor the entire Oracle ecosystem. It has a central storage warehouse for collecting data about multiple targets on multiple computers, it also provides an interface to display the common information of all discovered targets.
Database Control is a subset of the Grid Control function. Database Control only monitors one Database and cannot monitor multiple databases. It only runs on the database.