Connect Oracle with NAVICAT for Oracle Tools

Connect Oracle with NAVICAT for Oracle Tools This is a graphical management and development tool for Oracle clients that supports many databases.　　Before using Navicat for SQL Server, it feels good to use, so download the Oracle and MySQL tools. Check the Internet. This tool can be used with any version 8i or more of Oracle database server, and support most of Oracle's latest version of the functionality, including directories, tablespaces, synonyms, manifested views, triggers, sequences, types, and so on. The image below is in Oracle, and MySQL and SQL Server are basically the same as it is.

This interface is relatively concise, there is no superfluous things, for the daily operation basically can be satisfied. The following is the installation and configuration of it.

One, Navicat for Oracle installation:

Software installation is not much to say, basically is the next step. Online there is the kind of free installation cracked version, can be used directly.

Second, Navicat for Oracle configuration

1. Start the tool, the Start screen appears, click "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 server address where the Oracle database resides, and here I choose "localhost", enter the port number "1521" of Oracle, Enter the SID of the database or the service name of the database, enter the user name and password, here I use "Scott", click the "Connect Test" button to test to see if it is successful:

3, when I choose to start testing, there was an error: "Ora-12737:instant Client light:unsupported Server character Set CHS16GBK", this error is very typical, is because the server's encoding does not support the cause, but if I changed the server character set encoding, this is unrealistic, so the Internet to find a solution, finally know that as long as the Oracle official website to download a version of the OCI file, the original OCI file coverage can be resolved under the It's just a little bit bigger. The file at the end of the blog has been provided, the following is the file replacement process, the downloaded file is a compressed file, Remove the 4 files: Oci.dll,orannzsbb11.dll,oraocci11.dll,oraociei11.dll (this file is the most important), follow the steps below to replace the file. Select the Options command under the Tools menu to open the interface for the options:

4, in the "other" under the selection of OCI, on the right of the first file to browse the place, select Oci.dll location, 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 removed from the compressed file into that directory, the other can be backed up as shown below:

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

Can right-click ' table ' Import, export table, import data file into the new table, let Giser people pleasantly surprised, ArcGIS of SHP data set is also supported.

The database I'm using is oracle11g, and we're downloading the instant client tool, which has 11 and 10 versions and uses 11 for oracle9i and above. The other uses version 10.

Navicat for Oracle Tools download:

Http://www.jb51.net/database/84092.html

Tools to resolve character sets download:

1, the official website download http://www.oracle.com/technetwork/topics/winsoft-085727.html
2, Thunder download Http://download.oracle.com/otn/nt/instantclient/112030/instantclient-basic-nt-11.2.0.3.0.zip

Reference article:
Http://www.jb51.net/softjc/84100.html

Http://wenku.baidu.com/view/319c742e4b73f242336c5fe2.html

Http://www.jb51.net/softjc/84099.html

Connect Oracle with NAVICAT for Oracle Tools