How to connect navicat to oracle

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

Recommended tutorial: Database video tutorial

1: Description

This tutorial is to install the Oracle database into the Vmvare virtual machine. For simple debugging, it is a headache to install it into the physical machine, and the performance of the physical machine will be affected. Greatly reduced, and the database is not easy to uninstall.

2: Preparations before installation

First of all, Navicat

##　1 :Install Oracle database, Select shared server type during installation, do not select dedicated server.

2: Determine the number of digits of Oracle, Navicat, and OracleClient, and ensure that the number of digits of your oracle database is consistent with the number of digits of navicat, that is: 32v32,64v64

3: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html,

Download the instantclient that is consistent with your database version on this page. The important thing is to say 3 times, must be consistent with your database version. If you don’t know your database version number, please enter select * from v$version in sql. The data will be as follows:

Then the matching client version is as follows:

When downloading, choose to download the BASIC version, remember that the download time and version number must be Consistent! I said it three times. After downloading, it is usually placed in navicat, whichever you like. Because it also has an instantclient directory in it, but please remember that the one that comes with it cannot be used at all. Please delete it, and then put the one you downloaded into this directory. Most online information says that you only need to replace the oci.dll file. That’s it, this is wrong, the entire folder must be placed in it!

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

The next step is the virtual machine.

5. Installation of the virtual machine, installation of the system, please Google and Du Niang, please pay attention to the selection of network adapter. Select VMNET8, as shown in the figure:

6. Oracle installation, Please Google, Du Niang, please note that select the shared mode during installation, the installation is complete Finally, open the Net Configuration Assistant and reconfigure the listening program, as shown in the figure:

##　7. Because it is in a virtual machine, just turn off the firewall. If you don't want to shut it down, just release Oracle in the network firewall. This step of the firewall may not be considered

. requires attention.

8. Have you noticed that we do not have any steps to configure the tnsname and listener files? This method does not require configuration, because the previous step of reconfiguring the listener has already helped We have finished configuring the listener.

　9. Test the connection, connect in the virtual machine

　10: Test the connection. Physical machine connection

Extended 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 easy way.

Navicat is world-famous and widely trusted by major enterprises, government agencies, and educational institutions around the world. It is also an essential daily working partner for practitioners from all walks of life. Since 2001, Navicat has been downloaded over 2,000,000 times worldwide and has a customer base of over 70,000 users. More than 100 Fortune 500 companies are using Navicat.

Navicat provides up to 7 languages ​​for customers 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.

Navicat is powerful enough to meet all the needs of professional developers, and is easy to learn for those new to database servers. With an extremely complete graphical user interface (GUI), Navicat lets you create, organize, access and share information in a secure and simple 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, structure synchronization, import, export, backup, restore, report creation tools and plans to assist in managing data.

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