Shulou(Shulou.com)06/01 Report--

Editor to share with you the method of navicat connecting to oracle database. I hope you will gain a lot after reading this article. Let's discuss it together.

Let's create a new connection to oracle

Here I call it oracle, of course, you can choose the name you like, and enter the user name and password at the same time, just like the previous one.

In the advanced options

Up to now, if you connect directly, it certainly won't work, and it won't succeed. Another critical step is to configure the oci.dll file

Here, import the oci.dll file in the bin folder under the installation directory of the oracle you installed into E:\ software\ oracle\ Oracle_win64\ product\ 11.2.0\ dbhome_1\ BIN\ oci.dll

The above are the files under my installation directory. Please import them according to your own installation directory.

Restart Navicat after import, and it will take effect automatically after restart.

We can test the connection first.

You can see that the connection is successful.

After reading this article, I believe you have a certain understanding of the method of navicat connecting to oracle database, want to know more about it, welcome to follow the industry information channel, thank you for reading!

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.