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

(oracle 11g R2 64-bit + PLSQLDeveloper installation instructions and PLSQLDeveloper + ORCALE11-instantclient-basic-win32-11.2.0.1.0 detailed steps to connect oracle 11g R2 64-bit)

Step one:

Prepare the tool

1.oracle 11g R2 64-bit installation package

2.PLSQL Developer v11.0.2.1766 official Chinese version (includes PLSQL Developer installer, Sinicization program, PLSQL Developer registration program, PLSQL Developer 9.0 PDF documentation)

3.ORCALE11-instantclient-basic-win32-11.2.0.1.0 (download address of Baidu network disk: http://pan.baidu.com/share/link?uk=1192701576&shareid=3384046651&fid=1008150190098024)

-

Step 2:

Installation instructions

Oracle11g R2 64-bit installation

A. Extract the two compressed packages in oracle 11g R2 64-bit into the same folder (database after decompression)

B. Open (unzipped) database, find the setup.exe installer, right-click and run this installation as "administrator". The following is the installation diagram of oracle 11g:

Note: this illustration is to perform the installation in turn, you need to wait during the installation, and this installation is not the only installation (for more resources, please go online)

PLSQLDeveloper installation

Extract the "PLSQLDeveloper v11.0.2.1766 official Chinese version" (i.e. the PLSQL+Developer10.0.3.1701 folder), open and find the "PLSQLDeveloper10.0.3.1701_CHS" Chinese program and install it, then find the "PLSQLDeveloper10.0.3.1701" PLSQL main installation program for installation, both of which are installed in the same folder. (note: the installation of the Chinese program depends on yourself, because the Chinese package is incomplete and cannot be completely Sinicized).

-

Step 3 (key points)

Configuration

A. Extract "ORCALE11-instantclient-basic-win32-11.2.0.1.0" to Product in the Oracle installation directory (after decompression: instantclient_11_2):

Such as: d:\ app\ adminnistrator\ product\ instantclient_11_2

B. Copy a folder (NETWORK) under the root directory of Oracle installation (dbhome_1):

For example: d:\ app\ adminnistrator\ product\ 11.2.0\ dbhome_1\ NETWORK

And paste "NETWORK" into the instantclient_11_2 directory under Product in the Oracle installation directory

Such as: d:\ app\ adminnistrator\ product\ instantclient_11_2\ NETWORK

C. Open the successfully installed PL/SQL Developer shortcut (Note: you need to register when you open PL/SQL Developer for the first time. Find the "PLSQL registration machine" in the folder unzipped by "PLSQL Developer v11.0.2.1766", like a program with "Z" icon, and you can fill in the contents of the registry. Set OCI Library and Oracle_Home in Tools- > perference- > Connection, for example:

Oracle Home: d:\ app\ adminnistrator\ product\ instantclient_11_2

OCI Library: d:\ app\ adminnistrator\ product\ instantclient_11_2\ oci.dll

(note: this setting can be set or not set. If you want to set it, please check "checked connection")

D. Set environment variables (modify PATH and TNS_ADMIN environment variables):

(note: for the NLS_LANG environment variable, it is best to set it to be the same as the database side. First, query the character set information from the database side (that is, log in to your own PLSQL under the DOS command, type as follows):

SQL > select userenv ('language') nls_lang from dual

Get: "SIMPLIFIED CHINESE_CHINA.ZHS16GBK" suggests entering the above code in the DOS command to confirm)

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

1 >. Select "Path"-Click "Edit" and add "D:\ app\ adminnistrator\ product\ instantclient_11_2;" to the value of other variables

2 >. Click "New", set the variable name to "TNS_ADMIN", set the variable value to "D:\ app\ adminnistrator\ product\ instantclient_11_2;", and click "OK"

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

-

Finally, click OK to exit.

(note: the semicolon during configuration is switched to English input method. When the installation is complete, when you open the PLSQL Developer shortcut to enter the login page, enter orcl in the drop-down box of connection as for the first time, and then log in, and there is no need to type the second startup, because the previous PLSQL Tools configuration under the check "checked connection", that is, "check connection". Other services (such as ORACLR_CONNECTION_DATA, LISTENER_ORCL) in the drop-down box need to be configured.

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.