Issue: WIN8 64 uses bit system PLSQL developer Local connection Oracle inexplicably problems occur in the database. The error message box may even be empty.
Reason: It indicates that the Internet, for reasons, is expected to be installed on a 64-bit system in a 64-bit Oracle database. However, there is no corresponding 64-bit PL/SQL developer to use, so you cannot connect directly at this time, you need to install Oracle client.
Solve:
1, download instantclient_11_2 (database version number is 10g, 11g can connect), address http://download.csdn.net/detail/zxnlmj/8063243
2. Place the Instantclient_11_2 folder in the compressed package downloaded in 1 into the product folder under Oracle's installation folder, The Oracle client configuration variable in the compressed package. txt The file does not need to be configured in this case (requires configuration when connecting to remote Oracle)
3, configure environment variables (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, change 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 and login again.
Ok.
WIN8 64-bit use Plsql developer to connect to Oracle database issues