Oracle Note: Plsql cannot connect 64-bit Oracle Solutions

Plsql prompt error after opening, login interface no connection target selection.

Cause: Plsql itself does not seem to support 64-bit Oracle.

Workaround:

2. Download the 32-bit Oracle client to Oracle's website at http://www.oracle.com/technetwork/topics/winsoft-085727.html

4. Unzip the downloaded 32-bit client.

6. Plsql Login interface to temporarily cancel login, first enter the Plsql interface, click Preferences, set the OCI library for the 32-bit client just downloaded the OCI path, the path must include Oci.dll.

7. To add an environment variable:

   The first one points to the directory where the TNS file is located, which is the directory where you installed the 64-bit version of Oracle's TNS file. The TNS file is the file that holds the connection information. (You no longer need to enter 127.0.0.1 when connecting to a local instance after configuration is complete)
   tns_admin value: E:\app\OYK\product\11.2.0\dbhome_1\NETWORK\ADMIN
   the second is the encoding used by the specified database. If you do not set the following values, then when you connect to the database, all the Chinese content you see will be garbled, a bunch of question marks.
   Nls_lang value: Simplified Chinese_china. ZHS16GBK

9. Tips for missing MSVCR71. DLL, copy 64 to the downloaded 32-bit client for this file under the installation path. in the file under: \oracle\product\10.2.0\db_1\bin\ctxhx