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

This article mainly introduces how to connect navicat to oracle, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

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:

One: description

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.

2: preparation before installation

First of all, there is Navicat.

1: install the Oracle database. Choose a shared server instead of a dedicated server.

2: 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, 32v3264v64

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. The important thing is to say it 3 times. Make sure it is the same as your database version. If you do not 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 connection, connection in virtual machine

10: test the connection. Physical machine connection

Expand content

Navicat is a fast, reliable and affordable database management tool designed to simplify database management and reduce system management costs. It is designed to meet the needs of database administrators, developers and small and medium-sized enterprises. Navicat is built with an intuitive graphical user interface that allows you to create, organize, access, and share information in a secure and simple way.

Navicat is well-known in the world, widely trusted by major enterprises, government institutions and educational institutions around the world, and is a necessary working partner for practitioners from all walks of life. Since 2001, Navicat has been downloaded more than 2000000 times worldwide and has a customer base of more than 70000 users. More than 100 Fortune 500 companies are also using Navicat.

Navicat provides customers with up to 7 languages to choose from and is recognized as the most popular database front-end user interface tool in the world.

It can be used to manage and develop local or remote MySQL, SQL Server, SQLite, Oracle and PostgreSQL databases.

The functionality of Navicat is sufficient to meet all the needs of professional developers, and it is quite easy for novice database servers to learn. With a very complete graphical user interface (GUI), Navicat allows you to create, organize, access and share information in a secure and easy way.

Navicat is available on three platforms-Microsoft Windows, Mac OS X and Linux. It allows users to connect to any local or remote server and provides some practical database tools such as data model, data transfer, data synchronization, structural synchronization, import, export, backup, restore, report creation tools and scheduling to assist in managing data.

Thank you for reading this article carefully. I hope the article "how to connect navicat to oracle" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.