After installing the oracle client, what should I do if I cannot connect to the client using plsql ?, Oracleplsql

Source: Internet
Author: User

After installing the oracle client, what should I do if I cannot connect to the client using plsql ?, Oracleplsql

After 64-bit oracle is installed and tested with SQL plus, you can successfully connect to the client, but cannot connect with plsql.

1. The test results with SQL plus are as follows:

2. The created instance cannot be found using plsql.

Unable to find the database, and no identity login box, click [Cancel], enter plsql to try to connect to the oracle client

3. log out and log on again. Click OK. An error is displayed:

The general meaning of this error is that the 64-bit database installed cannot be identified by plsql, and a 32-bit database needs to be installed.

4. In order not to uninstall the original 64-bit oracle database, download the compressed file of the 32-bit oracle client. decompress the file and place it in the 64-bit database directory;

5. Reset the link path in plsql (the path of the 32-bit client is now set)

6. Set these three variables in the system variables: The first two are the paths of the decompressed compressed package files;

The third system variable is the system variable added to prevent plsql from garbled Chinese characters (I checked it online and didn't use it any more, but add it, just in case)

7. Restart your computer; log on to plsql; then you can find the TNS of the database:

8. However, an error still occurred while logging on. The original database cannot be found,

8. Later, I re-used the tool provided by oracle to create an instance and log on again to log on to the newly created database instance. I used the statement to query the current time for testing and found that the data can be queried successfully, this is the final solution.

So far, it has finally been completed.

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.