Navicat for Oracle connection to Oracle 11G operation process, navicat11g

Navicat for Oracle connection to Oracle 11G operation process, navicat11g

Procedure for connecting Navicat for Oracle to Oracle at 11 GB

1. Change the Oracle configuration file

After installing Oracle 11g, you need to change the listener. ora and tnsnames. ora files under the C: \ Oracle Installation Base directory \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN. Remember to back up the two files first. Then, change localhost in each file to the name of the computer on which the Oracle computer is installed.


Finally, in Windows running, enter services. msc to enter the system service, and restart the two services in the red box.

This step is mainly used to remotely connect to the Oracle database through Navicat on the client. If you do not change the file, you can only connect to Oracle on the machine where the Oracle database is installed, that is, local connection.

2. Install Navicat for Oracle

To install Navicatfor Oracle, The Navicat version must be able to operate on the Oracle 11g, for example, 11.0.10-Enterprise Edition. You can download the version without registration that has been cracked from the Internet.

3. Install the instant client

Download the instantclient-basic-nt-11.2.0.3.0 (for win32) from the Internet and copy its content to the Navicat installation directory; In Navicat's tool> Options> others> OCI, select the content of the OCI library as the oci in the instantclient-basic-nt-11.2.0.3.0. dll; finally, follow the instructions in Navicat to restart Navicat.

4. Configure Navicat

This step begins to connect to the Oracle database. Our ultimate goal is to connect the database with localhost, computer name, and IP address, both locally and remotely, as sys, system, and scott.

4.1 system and scott users

To configure the Connection Properties, you must correctly configure all the three option cards. The following figure shows the correct configuration. Both the "advanced" and "SSH" option cards are configured by default.



After the configuration is complete, click "connection test". If the test is successful, the configuration is successful and the database can be operated properly.

4.2 sys user

All configurations are the same as scott and system users, except for changing the role on the "advanced" tab to SYSDBA, as shown in.

After the configuration is complete, click "connection test". If the test is successful, the configuration is successful and the database can be operated properly.