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