Shulou(Shulou.com)05/31 Report--

This article is to share with you about how to solve the problem that Navicat Premium 12 prompts oracle library is not loaded when connecting to oracle library is not loaded. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The author uses a screenshot of the Navicat Premium 12 startup interface:

Please note that it is 64-bit. The author win7 64-bit system.

Prompt "oracle library is not loaded" when connecting to Oracle.

Solution:

1. Go to "http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html""

two。 Select the "Instant Client" that matches your system.

Mine is 64-bit software, so I choose the first "Instant Client for Microsoft Windows (x64)". If your software is 32-bit, choose the second.

3. Select "Accept License Agreement" as shown, and then click "instantclient-basic-windows.x64-x.x.x.x.zip". The "x.x.x.x" here is the version number, which is not important. In theory, any version will do. Note that you need to log in to your Oracle account at this time. No, you can register directly. It's no trouble.

4. If you are not logged in, you will jump to the login screen below. Sign up for an account without an account, enter the account number and password directly, and click the "login" button to download the zip package automatically.

5. Download the compressed package and unzip it, and put the extracted directory under a path without Chinese characters, in order to prevent program errors. I put it in the "D:\ ORACLE\" directory.

6. Open the Navicat Premium program, open "tools-options-Environment-OCI Environment-OCI library (oci.dll)", then fill in the complete directory of the oci.dll files in the folder you just downloaded, and click OK.

7. Restart the Navicat Premium program to test double-click the oracle database and find that it is now ready to connect.

Note: pay special attention to:

Be sure to restart the Navicat Premium program after configuration, otherwise the configuration will not take effect!

Recently, several friends said that the problem could not be solved according to my method, so you can try to install the version I installed.

The oracle client must be installed. Note that it is the client, not the server.

Thank you for reading! This is the end of this article on "how to solve the problem of prompting oracle library is not loaded when Navicat Premium 12 connects to Oracle". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.