Home > Database > navicat > body text

How to connect navicat to oracle database

(*-*)浩
Release: 2019-08-21 17:30:50
Original
18202 people have browsed it

How to connect navicat to oracle database

We create a new oracle connection (recommended tutorial: navicat tutorial)

How to connect navicat to oracle database

Here I named it oracle. Of course, you can name it whatever you like, and enter the user name and password at the same time. The same as before

How to connect navicat to oracle database

## In the advanced options

How to connect navicat to oracle database

As of now, if you connect directly, it will definitely not work and it will not be successful. Another step is very critical, which is to configure the oci.dll file

How to connect navicat to oracle database

Here you need to put the bin folder in the installation directory of the oracle you installed. Import the oci.dll file into E:\software\oracle\Oracle_win64\product\11.2.0\dbhome_1\BIN\oci.dll

The above are the files in my installation directory, everyone will be different according to their own installation directory Come to import

After importing, restart Navicat. It will take effect automatically after restarting.

How to connect navicat to oracle database

We can test the connection first

How to connect navicat to oracle database

You can see that the connection is successful

How to connect navicat to oracle database

The above is the detailed content of How to connect navicat to oracle database. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!