WIN7/8 the installation of Oracle

Installing Oracle under 64-bit Win7 and Win8 can be a hassle, and you'll need to download the appropriate Setup files and environment configuration to get things done.

The following are the procedures that I installed:

Step 1: Download the files you need to install

             a.   download 64-bit Oracle 11g  database file (about 2.1G), click the hyperlink download win64_11gr2_oracle.zip

             b.   Download 32-bit Oracle 11g client files (approx. 49.1M),

C.   Download the 32-bit PL/SQL V9.0 installation package (about 25.6M), which provides the Chinese package, serial number (provided in the documentation), please click the hyperlink download plsql Developer v9.zip  

Step 2: Install sequentially

A. First install the Oracle database, the author installed Oracle base directory is: "C:\APP\LX", follow the installation wizard prompts to complete the installation of the Oracle database. The directory after installation is as follows:

650) this.width=650; "style=" Border-bottom:medium none;border-left:medium none; Width:570px;height:349px;border-top:medium none;border-right:medium none; "Src=" http://img.blog.csdn.net/ 20131010154844218 "Width=" 646 "height=" 421 "/>  

B. Next Unzip the Oracle client file into the "product" folder, as shown in the Instantclient_11_2 is the Oracle client file

650 "this.width=650;" style= "Border-bottom:medium None;border-left:medium none;border-top:medium none;border-right:medium none; "align=" Middle "src="/http img.blog.csdn.net/20131010155745734 "width=" 570 "height="/>  

              C.   finally install PL/SQL and do not install the default path C:\Program Files (x86) because PL/SQL does not recognize the path "(", " ) "These symbols. The path installed by the author is:   "C:\PLSQL" as shown in:

650) this.width=650; "style=" Border-bottom:medium none;border-left:medium none;border-top:medium none; Border-right:medium none; "src=" http://img.blog.csdn.net/20131010160622656 "width=" 570 "height="/>

Step 3: Configure the environment for PL/SQL  

             A.   copy C:\app\lx\product\11.2.0\dbhome_1\NETWORK\ADMIN\ Tnsnames.ora   to C:\app\lx\product\ instantclient _11_2   directory Tnsnames.ora file contains some configuration information for the Oracle database (server name, protocol type, database, port number, etc.).  

             B.   set environment variables

  right-click My Computer-Properties-Advanced-" environment variable "-" System environment variable ":

 1 >  Select "Path"-click "Edit", append directory " c:\app\lx\product\ Instantclient_11_2 ; " to the variable path;

 2>  Click "New", the variable name is set to " tns_admin ", "Tns_admin" Variable is used to indicate the directory where the Tnsnames.ora file is located (the client connection information originates from the file), the variable value is set to " C:\app\lx\product\instantclient_11_2; ", and click OK ;

 3>  Click "New", the variable name is set to " Nls_lang " and the variable value is set to " Simplified Chinese_china. ZHS16GBK ", click" OK ";

  finally click "OK" to exit.  

                C.   PL/SQL Developer environment settings, set up Oracle home and  oci Library in Tools->perferences->connection. The author's environment is:

Oracle Home=c:\app\lx\product\instantclient_11_2

oci Library for =c:\app\lx\product\instantclient_11_2\ Oci.dll

 

650) this.width=650; "style=" Border-bottom:medium none;border-left:medium none;width:666px;height:453px;border-top : Medium None;border-right:medium none; "src=" http://img.blog.csdn.net/20131010165039906 "width=" 570 "height=" 350 "/ >

So far, all configurations are complete, restart PL/SQL, and the configuration is successful!

650) this.width=650; "style=" Border-bottom:medium none;border-left:medium none;border-top:medium none;border-right: Medium none; "src=" http://img.blog.csdn.net/20131010165506968 "/>

Note:

1. Because PL/SQL does not yet provide 64-bit files, in order to enable PL/SQL to connect to 64-bit Oracle 11g databases, be sure to download 32-bit Oracle 11g client Files , otherwise PL/SQL will error!

2. The value of the environment variable Nls_lang can not be set arbitrarily, the following SQL statement query

Sql> Select Userenv (' language ') from dual;
Userenv (' language ')
----------------------------------------------------
Simplified Chinese_china. Zhs16gbk

3. PL/SQL development do not install in the default C:\Program Files (x86) directory, or you will get an error because the path of this band () cannot be resolved.

This article is from the "worry-free 1" blog, make sure to keep this source http://12803871.blog.51cto.com/12793871/1914931

WIN7/8 the installation of Oracle