How to connect navicat to oracle database

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

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

## In the advanced options

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

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.

We can test the connection first

You can see that the connection is successful

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!