64-bit Windows 8/7 32-bit PLSQL connection 64-bit Oracle 11g, plsql11g
64-bit Windows 8/7 32-bit PL/SQL connection 64-bit Oracle 11g
Note: Oracle's oci. dll is 64-bit after installation, while 32-bit application PL/SQL Developer cannot load
Solution
Step 1: Download the Instant Client for Microsoft Windows (32-bit) package address: http://www.oracle.com/technetwork/topics/winsoft-085727.html
Step 2: Decompress the file
Step 3: configure system environment variables
TNS_ADMIN = E: \ app \ xiaokui \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
(Note: The first half of NLS_LANG must be AMERICAN_AMERICA, Because instant client does not support other languages;
The latter half can be adjusted according to the character set of your database. If the database uses AL32UTF8, you can set AL32UTF8)
Step 4: Configure PL/SQL
Time: August 06, 2014
Speaker: xiaokui
Original video potato network address: http://www.tudou.com/programs/view/7Wr-G7zgGdc/
In win7 64-bit operating system, how does plsql connect to the oracle database?
Solution to PLSQL + Developer + in win7 + 64-bit + Oracle + 11g + 64-bit
1) install Oracle 11g 64-bit (this part will not be mentioned)
2) install a 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 \ 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
Install PL/SQL Developer and set OCI Library and Oracle_Home in perference-> Connection. For example, set the local machine:
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 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>. 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"
Click "OK" to exit.
Start PL/SQL Developer and run it .... Remaining full text>
32-bit PLSQL and 32-bit oracle are connected in 64-bit win8 system.
Right-click the "-" attribute to check the Administrator permission and compatibility mode.