Navicat failed to connect to Oracle Database: cannot load OCI DLL, 87: instant client package is

Cannot load OCI DLL,87:Instant Client package is required for Basic and TNS connection.For more information…

** Question why ：**navicat Connect oracle The corresponding database needs to be configured oci.dll file .
Solution ：
1 get oci.dll file
according to Navicat Official document , Just download Oracle Of Instance Client that will do . This package contains only some dll file , There is no need to install and unzip （ What we should pay attention to is to see the corresponding version clearly ）.

2 stay Navicat To configure oci.dll file ：
1） open Navicat-> Select tool -> Options , Go to the configuration page ;

2) choice oci-> Select local oci.dll File address where the file is placed , Click ok .

3） Restart Navicat( Very important ), Conduct database connection test , At this point, you can connect successfully .

Finally, the perfect solution .