Oracle 11G RAC Client Installation and Plsql connection configuration

  
to make it easier for project team developers to use the oracle11g RAC database, install a client and configure Plsql to access the database server.

Download The following three packages from Oracle official:

Instantclient-basic-win32-11.2.0.1.0.zip This is the core package.


Instantclient-jdbc-win32-11.2.0.1.0.zip contains the JDBC driver package


Instantclient-sqlplus-win32-11.2.0.1.0.zip The simplest sqlplus package

first, the three compressed package files are extracted to D under the packing OracleClient below (can also be the specified directory under other disks)

The final file structure should be as follows:

2. Configure Tnsnames.ora, if you do not have Oracle installed on this computer, you can copy one (Tnsnames.ora file) from the server on which Oracle is installed.
(the file is under $oracle_home/network/admin) and put it under the directory D:\oracleclient above. The contents of the Tnsnames.ora are:
 
# Tnsnames.ora Network Configuration File:c:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
prod=
(DESCRIPTION =
(ADDRESS = (PROTOCOL =tcp) (HOST = Scan-rac) (port= 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = prod)
    )
  )
3, in My Computer-attribute---Advanced system settings-environment variables, add an environment variable, named Tns_admin, the value of the Tnsnames.ora file is located in the path (such as: D:\oracleclient), This is to be able to find the Tnsnames.ora said above. If ORACLE is installed on this machine and the ORACLE_HOME environment variable is set, the Tnsnames.ora file is automatically found in the $oracle_home/network/admin/location.
 
4, set the Oracle language, add the registry key: "Nls_lang=simplifiedchinese_china. ZHS16GBK ", located in Hkey_local_machine\software\oracle. If the machine does not have Oracle installed, there is no Oracle under Hkey_local_machine\software\, it needs to be created manually, and then the key Nls_lang is created under the ORACLE key, with the following key values: Simplifiedchinese_china. ZHS16GBK
can be. The name of the database you want to connect to, in general the same name as the service_name.

fill in the corresponding content

Oracle Home (Empty is AutoDetect) =d:\oracleclient

OCI Library (Empty is AutoDetect) =d:\oracleclient\oci.dll

- checkconnection the box to be hit √

6, open Plsql again will have the PROD option in database, enter the corresponding user name password and corresponding role permissions can login.

Oracle 11G RAC Client Installation and Plsql connection configuration