Navicat Premium for Linux 64-bit remote Oracle database tutorial, navicatpremium

Navicat Premium for Linux 64-bit remote Oracle database tutorial, navicatpremium

If you are a friend of Desktop Linux who uses Oracle databases, they will think of Navicat. Although this little item is charged, it is really easy to use and has a gorgeous interface. Here we will not discuss how to crack it, but how to install and use it!

First download Navicat. Here we take Navicat Premium for Linux 64-bit as an example.

Select Navicat Premium for Linux 64installation package file navicat120_premium_cs_x64.tar.gz

After downloading it to a local directory, create a folder to save the decompressed folder, such as/usr/local/navicat.

Enter the decompressed folder, which contains a start_navicat file. Run./start_navicat to start navicat.

Load wine Package, if there is garbled interface, edit start_navicat File Settings export LANG = "zh_CN.UTF-8" just fine, you can do

Quick Start icon.

There is also a Navicat folder. After clicking it, there is a folder starting with instantclient, which is the simple client of oracle,

Because the oracle database is not installed locally, you must use a simple client.

The default version seems to be 10. If the remote oracle database is of a higher version, the database may not be connected.

To download the corresponding instantclient on the oracle official website, and emphasize that the windows version of instantclient is to be downloaded, because this software is used

For running wine, we will download the latest instantclient-basic-windows.x64-12.1.0.2.0.zip

Decompress the package to obtain the instantclient_12_1 folder. Move the folder to the Navicat folder.

Configure OCI, open the option, select the environment, and select the OCI. dll file in the instantclient_12_1 folder we just downloaded in oci library.

Yes. You need to restart navicat.

Now we can start the connection.

Create a connection and edit the connection properties:

Make sure that the connection name (custom), Host ip address, port, service name, user name, and password are correct.

Test connection. Connection successful

Okay, you're done!