This article uses Navicat for Oracle tools to connect Oracle
The installation process I will not repeat this, and the general software installation process is similar. The following is the main explanation of navicat configuration.
1, start the tool, the following Start screen appears, click the "Connect" option to connect to the database,:
2. In the New Connection dialog box, enter any connection name, select the default connection type, click the Connect Test button, and test to see if it is successful:
3, this should be the connection failed. So go to Oracle's website to download a new version of the OCI file
Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html
Here according to your own download Navicat for Oracle version to choose to download the corresponding Instant-client version, because I was under the 64bit navicat, so, I correspond to download:
4, take out the file: Oci.dll,orannzsbb11.dll,oraociei11.dll,oraocci11.dll, put the navicat for Oracle under the installation directory
Under the Instantclient_10_2 folder:
5, select the "Tools" menu under "Options" command, open the interface of the options:
7, in the "other" under the selection of OCI, on the right of the first file to browse the place, select the location of the Oci.dll, that is, we just placed the location.
After this configuration, restart the software, the connection is successful.