Install and use 32-bit PLSQL-developer in a 64-bit Oracle database environment

Source: Internet
Author: User

After a 64-bit Oracle 10g Database is installed on the 64-bit win2003 operating system, you can connect to the database using PLSQL over the network, but the server cannot connect to the database.
Solve the problem as follows:
1. Install the 32-bit Oracle client (about MB) and select the Administrator mode.
And use the net manager of this version to configure the server connection string. Do not use the server version for configuration, because the former is 32-bit, and the latter is 64-bit.
One of their home directories is under D: \ oracle \ product \ 10.2.0 \ client_1, and the other is under D: \ oracle \ product \ 10.2.0 \ db_1.
Both directories contain the network \ admin \ tnsnames. ora file. The 32-bit software must use the file in the 32-bit client directory.

2. Install PLSQL to the specified directory (for example, D: \ PLSQL). Do not select the default directory (D: \ Program Files (x86 ))
Because the 32-bit software installed on the 64-bit server is installed on D: \ Program Files (x86) by default, because the Oracle Net service has a bug when parsing the connection, the parentheses included in the path cannot be parsed.

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.