win864 bit using Plsqldeveloper to connect to Oracle database

Problem: An inexplicable problem occurs when you use Plsql developer to connect to a local Oracle database on a WIN8 64-bit system, and the error prompt box may even be empty.

Reason: According to the internet, the reason is estimated to be installed on 64-bit system 64-bit Oracle database, but there is no corresponding 64-bit PL/SQL developer for our use, so at this time cannot directly connect, need to install Oracle client.

Solve:

1, download instantclient_11_2 (database version is 10g, 11g can connect), address http://download.csdn.net/detail/zxnlmj/8063243

2. Put the Instantclient_11_2 folder in the compressed package downloaded in 1 into the product directory under the Oracle installation directory, and the Oracle client configuration variable in the package. txt This file does not need to be configured (requires configuration when connecting to remote Oracle) )

3, the Configuration environment variable (for example) oracle_home=d:/programfile/oracle/product/10.2.0/db_1,

Path=d:/programfile/oracle/product/10.2.0/db_1/bin,

Nls_lang = Simplified Chinese. ZHS16GBK.

4, modify Plsql developer-"Cancel Landing-" tools-"preferences-" oracle-"Connection"

Oracle_home=d:/programfile/oracle/product/instantclient_11_2

OCI Library = D:/programfile/oracle/product/instantclient_11_2/oci.dll

Application, exit the login again.