PLSQL Dervloper solution for 64-bit Systems

64-bit system with PLSQL Dervloper solution 1) install Oracle 11g 64-bit 2) install 32-bit Oracle client (instantclient-basic-win32-11.2.0.1.0) download instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not download the wrong version. download it from the Oracle official website. decompress it to the Product in the Oracle Installation Directory (the local name is instantclient_11_2): D: \ Oracle \ app \ dd \ product \ instantclient_11_2. Copy a Directory D: \ Oracle \ app \ dd \ product \ 11.2.0 \ dbhome_1 \ NETWORK under the root directory of the database installation to the Oracle Client Directory D: \ Oracle \ app \ dd \ product \ instantclient_11_2 (in fact, only NETWORK \ ADMIN \ tnsnames is required. ora) 3) install PL/SQL Developer to install PL/SQL Developer. Set OCI Library and Oracle_Home in perference> Connection. For example, set the local machine to Oracle Home: D: \ Oracle \ app \ dd \ product \ instantclient_11_2 OCI Library: D: \ Oracle \ app \ dd \ product \ instantclient_11_2 \ oci. dll 4) set environment variables (modify environment variables) for NL S_LANG environment variables, preferably set to be consistent with the database. First, query the character set information from the database: SQL> select userenv ('language') nls_lang from dual; NLS_LANG login SIMPLIFIED CHINESE_CHINA.ZHS16GBK right-click "my computer"-"properties"-"advanced"-"environment variables"-"system environment variables": 1>. click "new", set the variable name to "NLS_LANG", set the variable value to "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", and click "OK"; 2>. create an environment variable "TNS_ADMIN" with the value "D: \ Oracle \ app \ dd \ product \ instantclient_11_2" and click "OK" to exit. start PL/ SQL Developer, running is normal.