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

Editor to share with you how navicat connects to the oracle database. I hope you will get something after reading this article. Let's discuss it together.

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.

After reading this article, I believe you have a certain understanding of "how navicat connects to oracle database". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

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.