64 win7 + 64 Oracle + 32plsql Installation

64 win7 + 64 Oracle + 32plsql installation 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 \ YM \ product \ instantclient_11_2. Copy a Directory D: \ Oracle \ app \ YM \ product \ 11.2.0 \ dbhome_1 \ NETWORK under the root directory of the database installation 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 ---------------------------------------------------- SIMPLIFIED CHINESE_CHINA.ZHS16GBK

 

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 it normally.