Shulou(Shulou.com)06/01 Report--

Installing Oracle under 64-bit Win7 and Win8 will encounter some trouble, and you need to download the appropriate installation file and the configuration of the environment to complete it smoothly.

The following is the process of the author's installation:

Step 1: download the files you need to install

a. To download the 64-bit Oracle 11g database file (about 2.1g), please click the hyperlink to download win64_11gR2_Oracle.zip.

b. To download the 32-bit Oracle 11g client file (about 49.1m), please click the hyperlink to download ORCALE11-instantclient-basic-win32-11.2.0.1.0.zip

c. Download the 32-bit PL/SQL V9.0 installation package (about 25.6m), which provides a Chinese package with serial number (provided in the documentation). Please click the hyperlink to download PLSQL Developer V9.zip

Step 2: install sequentially

a. First install Oracle database, the author install Oracle base directory is: "C:\ app\ lx", follow the installation wizard prompts, complete the installation of Oracle database. The installed directory is shown in the following figure:

b. Second, extract the Oracle customer file to the "product" folder. As shown in the following figure, instantclient_11_2 is the Oracle customer file.

c. Finally, install PL/SQL, not in the default path "C:\ Program Files (x86)", because PL/SQL does not recognize the symbols of the path "(", ")". The path to the author's installation is "C:\ PLSQL", as shown in the following figure:

Step 3: configure the environment for PL/SQL

a. Copy C:\ app\ lx\ product\ 11.2.0\ dbhome_1\ NETWORK\ ADMIN\ tnsnames.ora to the C:\ app\ lx\ product\ instantclient_11_2 directory. The tnsnames.ora file contains some configuration information for the Oracle database (server name, protocol type, database, port number, etc.).

b. Set environment variabl

Right-click "my computer"-"Properties"-"Advanced"-"Environment variables"-"system Environment variables":

1 > Select "Path"-Click "Edit" and append the directory "C:\ app\ lx\ product\ instantclient_11_2;" to the variable Path

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

3 > Click "New", set the variable name to "NLS_LANG", set the variable value to "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", and click "OK"

Finally, click OK to exit.

C. PL/SQL Developer environment settings, set Oracle Home and OCI Library in Tools- > perferences- > Connection. The author's environment is as follows:

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

OCI Library is = C:\ app\ lx\ product\ instantclient_11_2\ oci.dll

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

Note:

1. Since 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 report an error!

two。 The value of the environment variable NLS_LANG cannot be set casually, and can be queried by the following SQL statement

SQL > select userenv ('language') from dual

Userenv ('language')

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

3. Do not install PL/SQL Development in the default C:\ Program Files (x86) directory, otherwise an error will be reported because the path with () cannot be parsed.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.