64-bit Windows 8/7 32-bit PLSQL connection 64-bit Oracle 11g, plsql11g

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.