After installing Oracle (64-bit), PL/SQL developer, execute PL/SQL occurs for example the following error:
On the Internet, my PL/SQL developer is incompatible with Oracle, that is, PL/SQL does not support 64-bit Oracle, so the next 32-bit orcaleclient will be configured with the corresponding number of parameters:
To resolve the steps in small notes:
First, download Oracle 32-bit client
: http://www.onlinedown.net/soft/102902.htm (Oracle 10gclient Lite Green Edition)
Second, extract to the Oracle installation folder under a named Product folder, and rename (the name is not necessary), I do this step is named Instantclient_11_2
third, PL/SQL Developer configuration,perference->connection inside set OCI library and Oracle_home
Oracle Home (Empty is AutoDetect): This option configures the home folder of the Oracle client
OCI Library (Empty is AutoDetect): Give the option to configure the full folder Oci.dll under the OracleClient folder
Four. Environment variable setting
for Nls_lang environment variables, it is best to set to the same as the database side, first query the character set information from the database side:
sql> Select Userenv (' language ') Nls_lang from dual;
Nls_lang
----------------------------------------------------
simplified Chinese_china. ZHS16GBK
Right-click My Computer-Properties-advanced-environment variables-system environment variables:
1> Click "New" and the variable name is set to "Nls_lang" and the variable value is set to "simplified Chinese_china. ZHS16GBK ", click" OK ";
2> New environment variable "tns_admin" variable value is "OracleClient's home folder"
In this my configuration is: "D:\app\Administrator\product\instantclient_11_2"
3>: Finally click "OK" to exit.
Restart PL/SQL Developer no problem!
PL/SQL Developer running on Oracle 64-bit database initialization error