Navicat links to Oracle Tutorials and considerations

Today, when using Navicat to connect Oracle, I faint some pits, and I hereby record it!

Landlord is a 64-bit WIN10 system, has just begun to configure 32-bit OCI. After configuring the connection or the prompt "Connot load OCI dll,87:instant Client package was required for Basic and TNS connetion. "Then follow the re-open OCI configuration and find the OCI path you just selected the text box has become empty!" Then the landlord to the official website to download 64-bit instantclient and then extracted to a local directory, reconfigure the OCI, incredibly successful!

Detailed steps are attached below!

1. You need to configure the OCI path before connecting, as shown! Here need to note that the computer environment is 64-bit words need to download 64-bit, must not be 64-bit use of 32-bit client!

Landlord is a 64-bit WIN10 system, has just begun to configure 32-bit OCI. After configuring the connection or the prompt "Connot load OCI dll,87:instant Client package was required for Basic and TNS connetion. "Then follow the re-open OCI configuration and find the OCI path you just selected the text box has become empty!" Then the landlord to the official website to download 64-bit instantclient and then extracted to a local directory, reconfigure the OCI, incredibly successful!

2. Go to the official website to download instantclient, unzip and put it under a folder, then go back to the 1 steps to configure the path of OCI

: http://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html

Choose your corresponding version according to your operating system, landlord Select 64-bit, click to enter the next page

Select "Accept License agressment" then select the following version to download, the landlord chose the latest version of 12.2, of course, you can also pull down to select the version of 11.2 to download

Download here may require you to register an Oracle account, and then login to download! Of course, you can also click here to download the landlord has downloaded a version of the 11.2! For other versions, please download it yourself!

Link: Https://pan.baidu.com/s/19pvMN9zWExpoLp28R5r_pA Password: K6VH

Navicat links to Oracle Tutorials and considerations