Solutions for using PLSQL + Developer in win7 + 64-bit + Oracle + 11g + 64-bit

Windows 7 + 64-bit + Oracle + 11g + 64-bit use PLSQL + Developer 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 (it must be a 32-bit version. Do not download it on the Oracle official website.) decompress it to the Product in the Oracle Installation Directory (the local name is instantclient_11_2 ): d: \ Oracle \ app \ YM \ product \ instantclient_11_2. Copy a Directory D under the root directory of the database installation at www.2cto.com: \ Oracle \ app \ YM \ product \ 11.2.0 \ dbhome_1 \ NETWORK to the Oracle Client Directory D: \ Oracle \ app \ YM \ 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 \ YM \ product \ instantclient_11_2 OCI Library: D: \ Oracle \ app \ YM \ product \ instantclient_11_2 \ oci. dll 4) set the environment variables (modify the PATH and TNS_ADMIN environment variables) for the NLS_LANG environment variables, it is best to set them 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
Export SIMPLIFIED CHINESE_CHINA.ZHS16GBK www.2cto.com right-click "my computer"-"properties"-"advanced"-"environment variables"-"system environment variables": 1>. select "Path"-click "edit" and add "D: \ Oracle \ app \ YM \ product \ instantclient_11_2;" to; 2>. click "new", set the variable name to "TNS_ADMIN", and set the variable value to "D: \ Oracle \ app \ YM \ product \ instantclient_11_2;", and click "OK "; 3>. click "new", set the variable name to "NLS_LANG", set the variable value to "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", click "OK", and click "OK" to exit. . Start PL/SQL Developer and run without any problems.