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

This article mainly introduces navicat even oracle method, has a certain reference value, need friends can refer to the next. I hope you will have a lot of success after reading this article. Let's take a look at it together.

Navicat Premium is a relatively good visual database management tool, short and concise, a tool to solve the connection problem of three databases, truly integrated management, MySQL, SQL Server, the connection is relatively simple, do not repeat, now summarize the steps to connect Oracle as follows:

I. Description

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

II. Preparations before installation

First, Navicat.

1. Oracle database installation, installation type select shared server, do not select exclusive server.

2. Determine the number of Oracle,Navicat, OracleClient bits, and make sure that the number of bits in your oracle database matches the number of navicat bits, i.e.: 32v32,64v64

3.http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html, Download instantclient with the same version as your database on this page, Be sure to be consistent with your database version, Do not know your database version number please enter select * from v$version in sql, The data is as follows:

Then the client version that matches it is as follows:

When downloading, choose to download BASIC version, remember that the download time and version number must be consistent! Three times. That's it. After downloading, it is usually placed in navicat, as you like. Because it also has an instantclient directory inside, but remember, the own point of chaos is not used, please delete it, and then you download to the directory, most of the online information that only need to replace the oci.dll file can be, this is wrong, the entire folder must be placed inside!

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

Next is the virtual machine aspect.

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

6.Oracle installation, please Google, Du Niang, note is to select the sharing mode during installation, after installation, open Net Configuration Assistant, reconfigure the listening program, as shown in the figure:

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

8. Notice that we don't have a single step to configure tnsname and listener files, this way we don't need configuration, because the previous step to reconfigure the listener has already helped us configure the listener.

9. Test connections, connections in virtual machines.

10. Test the connection. physical connection.

Thank you for reading this article carefully. I hope that Xiaobian will share the method content of navicat and oracle to help everyone. At the same time, I hope that everyone will support you a lot. Pay attention to the industry information channel. When you encounter problems, find detailed solutions 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.