"Go" plsql unrecognized Oracle_home solution on 64-bit Oracle Client

Transferred from: http://www.2cto.com/database/201503/386267.html

Display question mark in Chinese

Transferred from: http://zhidao.baidu.com/link?url=qJDmsahlNUjNdI2beflLkx4NDrA11YEJSLGZ_eWjqtT6aUJ-DDtIqu4crDTnZ_ T0ravrqpjxews82e0ekv_zxpfbwmj-gkpe_k4oj82sawq

1. Questions

Plsql so far only 32-bit programs, and most of the desktop system is basically the use of 64-bit Windows operating system, on 64-bit Windows, most of the time is also installed 64-bit Oracle client program, this combination, Causes Plsql to not recognize the Oracle_home directory and cannot read the connection string in the Tnsnames.ora file

2. Solution 2.1 Configure the ORACLE_HOME environment variable on windows

Right click on "My Computer" click on the "Properties" menu, go to the "System Properties" dialog box, select the "Advanced" tab, click "Environment Variables", in the User variable box area, create a new variable name named ' Oracle_home, according to their own ORACLE actual installation directory to fill their values, for example, The Oracle_home value of the author's environment is "C:\oracle\product\12.1.0\dbhome_1"

2.2 References instantclient-basic-win32-10.2.0.5

Unzip the Instantclient-basic-win32-10.2.0.5.zip file, compress the file, and copy it to the product under Plsql Developer installation directory, such as C:\oracle\product\, The final instantclient directory is c:\oracle\product\c:\oracle\product\instantclient-basic-win32-10.2.0.5\instantclient_10_2

Instantclient-basic-win32-10.2.0.5.zip file, Baidu under the right to have

Http://download.csdn.net/detail/kandeet/4282943#comment

2.3 Configuring the Oracle_home and OCI libraries 2.3.1 configuration in Plsql oracle_home

On the Plsql main menu, click Tools, select the Preferences submenu, go to the Preferences Page dialog box, on the right side of the Connections tab, locate the Oracle home directory name (automatically detect null), and in this box, fill in the Oracle's home directory name, such as "C: \ Oracle\product\12.1.0\dbhome_1 "

2.3.2 Configuring the OCI Library

On the Plsql main menu, click Tools, select the Preferences submenu, go to the Preferences Page dialog box, on the right side of the Connections tab, locate the OCI library (automatically detect empty), and fill in the box with an absolute path to the Oci.dll file, such as: "C:\oracle\ Product\instantclient-basic-win32-10.2.0.5\instantclient_10_2\oci.dll "

3. Results

Once the above four-step configuration is complete, restart Plsql to identify the oracle_home and to locate the database connection string in the Oracle client Tnsnames.ora file.

4, add: will appear in Chinese garbled solution

My Computer---Right-click---properties---advanced---environment variables---system variables---NEW
Variable name: Nls_lang
Variable value: Simplified Chinese_china. Zhs16gbk

———————————————————————————————————————————————— Simplified version

1. My Computer---Right-click---properties---advanced---environment variables---system variables---Create a new 2 environment variable

The value of Oracle_home is "C:\oracle\product\12.1.0\dbhome_1"//note, here is your 64-bit Oracle installation directory

The Nls_lang value is simplified Chinese_china. Zhs16gbk

2. Download Instantclient-basic-win32-10.2.0.5.zip Online

Extract to Oracle installation directory, product folder

3, open Plsql preferences, enter the path of home, the same value as above environment variables

Enter the path of the OCI, that is, after the decompression of the inside there is a. Oci.dll path

Once you are sure, re-open the Plsql and you can use the

"Go" plsql unrecognized Oracle_home solution on 64-bit Oracle Client