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

This article is about how to connect to a remote oracle using navicat. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Navicat Premium is a relatively good visual database management tool. It is short and short. One tool solves the connection problem of three kinds of databases, and it really achieves integrated management. For MySQL,SQLServer, the connection is relatively simple, so I won't go into details. The steps to connect to Oracle are summarized as follows:

I. explanation

This tutorial is to install the Oracle database into the Vmvare virtual machine. As far as simple debugging is concerned, installing to the physical machine is a headache, the performance of the physical machine will be greatly reduced, and the database is not easy to uninstall.

II. Preparation before installation

First of all, there is Navicat.

1. Install the Oracle database and choose a shared server instead of a dedicated server.

two。 Determine the number of digits of Oracle,Navicat,OracleClient and make sure that the number of digits of your oracle database is the same as that of navicat, that is, 32v32 and 64v64

3. Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html, download the instantclient that is the same as your database version on this page, and be sure to be the same as your database version. If you don't know your database version number, enter select * from v$version in sql. The data is as follows:

Then the client version that matches it is as follows:

Choose to download the BASIC version when downloading, and remember that the number of bits and the version number must be the same! I've said it three times. Usually put it in navicat after downloading, as you like. Because it also has an instantclient directory, but please remember, there is no misuse, please delete it, and then use what you download to put in this directory, most of the online materials say that you only need to replace the oci.dll file, this is wrong, you must put the whole folder inside!

4. Open navicat- > tools- > oci, select the instantclient you just downloaded, find oci.dll, and set it to the path. Navicat is done!

Next is the virtual machine aspect.

5. Virtual machine installation, system installation, please Google, du Niang, note is the choice of network adapter should choose VMNET8, as shown in the figure:

To install 6.Oracle, please use Google and du Niang. The key point is to select the sharing mode during installation. After installation, open Net Configuration Assistant and reconfigure the listener, as shown below:

7. Because it is in the virtual machine, turn off the firewall directly, if you do not want to close, release Oracle in the network firewall, firewall this step may not be considered. Need to pay attention to.

8. Do you notice that we do not have any steps to configure tnsname and listener files, which do not need to be configured, because the previous step of reconfiguring the listener has done for us to configure the listener.

9. Test the connection, connect in the virtual machine.

10. Test the connection. Physical machine connection.

Thank you for reading! On how to use navicat to connect the remote oracle to share here, 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 and let more people see it.

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.