Oracle 11G RAC Client Installation and Plsql connection configuration

for convenience Project group developers use oracle11g RAC Database , Install a client and configure Plsql to access the database server .

from Oracle official download of the following three packages : 

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

Instantclient-jdbc-win32-11.2.0.1.0.zip include JDBC Driver the 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:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4C/79/wKiom1Q-KTyjtkFzAAKmaZp75Nk733.jpg "title=" 1212. JPG "alt=" wkiom1q-ktyjtkfzaakmazp75nk733.jpg "/>

2. config if oracle oracle (Tnsnames.ora

(the file under $oracle_home/network/admin ) put it put it in the table above D:\oracleclient the next. 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 variablesAdd an environment variable, namedTns_admin, the value isTnsnames.oraThe path where the file is located (for example:D:\oracleclient), which is to be able to find the above mentionedTnsnames.ora. If you have a computer installed on thisORACLE, and set theOracle_homeenvironment variable, it is automatically$ORACLE _home/network/admin/Locate under LocationTnsnames.orafile.

4,SetORACLElanguage, add a registry entry:"Nls_lang=simplifiedchinese_china. ZHS16GBK ", located inhkey_local_machine\software\oracle. If this machine is not installedORACLE, in hkey_local_machine\software\the next is no"ORACLE"this item, which needs to be created manually, is thenORACLEkey under Key creationNls_lang, the key value is: Simplifiedchinese_china. ZHS16GBK

can be. The name of the database you want to connect to, in General the same name as the Service_Name .

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4C/7A/wKiom1Q-MvuQZBdWAAIFTmT-TEM177.jpg "title=" 11111. JPG "alt=" wkiom1q-mvuqzbdwaaiftmt-tem177.jpg "/>

5, Download and install PL. Sql. Developer and Configure the app
Open Plsql, and then configure tools->preferences->connection

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4C/7A/wKiom1Q-M3rSehyIAAJM0_-21yA488.jpg "title=" 2222. JPG "alt=" wkiom1q-m3rsehyiaajm0_-21ya488.jpg "/>

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 Again Plsql you will be in Database in a prod option, enter the appropriate user name password and the corresponding role permission to log in.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/4C/7B/wKioL1Q-OeSRyIhFAAE4O1wXQQk488.jpg "title=" Plsql1.png "alt=" Wkiol1q-oesryihfaae4o1wxqqk488.jpg "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/4C/7C/wKioL1Q-OfvhDtw2AAOoG-aePuw002.jpg "title=" Plsql2.png "alt=" Wkiol1q-ofvhdtw2aaoog-aepuw002.jpg "/>

This article is from the "Hollows Jie Sun" blog, be sure to keep this source http://xjsunjie.blog.51cto.com/999372/1564423

Oracle 11G RAC Client Installation and Plsql connection configuration