Win7 64 installation of Oracle 11G, standard practice for connecting using Plsql

The first step: the installation of Oracle services, two unpacking, respectively extracted after merging into a folder, click EXE installation (if you encounter path problem during installation, directly ignore it)

Step two: Use SQLPlus to test whether successful installation succeeded: CMD = "SQLPlus = =" Username =>pwd "= connect to ... Indicates success.

Step three: Connect using Plsql, the connection failure is found because there is no configuration oraclehome and OCI Library.

Fourth step: Configure the Oraclehome OCI Library for Plsql. Method: Enter in a non-logged-in manner, configure the parameters in the preferences, as follows:

Fifth step: Use Plsql connection test, Discover failure, prompt OCI connection problem (reason is 64 bit system and 32 bit plsql problem. ) You need to connect using Oracle client at this time

Sixth step: Download the Instantclient_11_2 tool and place it in a unified directory Plsql.

Seventh Step: Configure the environment variables for Oracle client as follows:

Nls_lang = Simplified Chinese_china. Zhs16gbk

Tns_admin = D:\install\PLSQL\instantclient_11_2"Set yourself here according to your specific circumstances"

Eighth step: Configure the OCI for Plsql for Oracle client as shown in:

Nineth Step: Use the Plsql test link to prompt the problem: the service could not be resolved. The reason is simple, the Oracle client's Tnsnames.ora file is not configured correctly.

Tenth step: Configure the Oracle client's Tnsnames.ora file, it is very simple, find the Oracle installation directory of the Network\admin\tnsnames.ora file, directly copy the content replication coverage to Oracle In the Tnsnames.ora of the client. The work is not done unexpectedly at this time.

=============================================================================================================== =======================

Install the best immediately practice practiced hand:

1.sys can only be logged in as DBA.

2. SCOTT, System uses normal as login.

3. Create a Table Space command:

Create Tablespace Startdb
DataFile ' c:\FirstDB.dbf '
Size 10m
Autoextend on
Next 16m maxsize 1024m
Extent management Local;

4 Create a complete table space, which can be created by users.

Method: File = "new =" User "Set user name, association table space, role permissions-dba, connect" = "Application.

5 test using the created user login, click on the key button, login = "success."

Ok class.

Win7 64 installation of Oracle 11G, standard practice for connecting using Plsql