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

This article is about how Navicat for Oracle tools connect to oracle. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Navicat for Oracle is a client-side graphical management and development tool for oracle, which is supported for many databases. I have used Navicat for sqlserver before, and I feel very easy to use, so I downloaded the Oracle version.

Check the Internet to see that this tool can be used on any version 8i or above Oracle database server, and supports most of the functions of the latest version of Oracle, including catalogs, tablespaces, synonyms, materialized views, triggers, sequences, types and so on. The picture below is the oracle version, and the MySQL version is basically the same as the Sql Server version.

The interface is simple, there is no redundancy, and it can basically meet the daily data operation. The following is the installation and configuration, which focuses on the configuration.

1. Installation of Navicat for Oracle:

There is no need to say much about the installation of the software, basically it is always the next step. There is the kind of installation-free cracking version on the Internet, which can be used directly.

II. Configuration of Navicat for Oracle

1. Start the tool, the start interface appears, and click the "File"-"New connection" option to connect to the database.

2. In the "New connection" dialog box, enter any connection name, select the default connection type, enter the address of the server where the oracle database is located, the local oracle of the connection can enter "localhost", the default port number of oracle is "1521", enter the SID of the database or the corresponding service name of the database, enter the user name and password, here I use "test", click the "connection test" button to test The connection succeeded, as shown in the figure:

3. When you choose to start the test for the first connection, there is often an error:

"ORA-12737: Instant Client Light: unsupported server character set CHS16GBK", this error is very typical, because the server's encoding is not supported, but if I change the server's character set encoding, this is not realistic, so I went online to find a solution. Finally, I know that as long as I go to the oracle official website to download the latest version of OCI file, the original OCI file can be overwritten. This file is provided at the end of the blog.

The following is the process of file replacement. The downloaded file is unzipped and four of them are found: oci.dll,orannzsbb11.dll,oraocci11.dll,oraociei11.dll (this file is the most important).

Select the options command under the tools menu and open the interface of the options as shown in the figure.

4. Select OCI under "other", and select the location of oci.dll where the first file is browsed on the right. My default location is "F:\ Program Files\ Navicat_for_Oracle (www.greenxf.com)\ Navicat for Oracle\ instantclient_10_2\ oci.dll". Put the four files extracted from the compressed file into this directory, and the rest can be backed up, as shown in the following figure:

5. After this configuration, restart the software, repeat the connection configuration in 2, test the connection, and the connection is successful. After success, you can see the "TEST" user's table, you can easily manipulate the database, I have not created a table here.

You can right-click the 'table' to import and export tables, and import data files into the new table. To the surprise of GISER people, dbf of ArcGIS's SHP dataset also supports it.

The database I use is oracle11g, and what we download is Instant client, which has versions 11 and 10, and uses 11 for oracle9i and above. Others use version 10.

Thank you for reading! This is the end of this article on "how to connect Navicat for Oracle tools to oracle". 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 out for more people to see!

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.