First explain the environment of my machine:
1, Win10-64bit
2, Navicat Premium_11.2.7-64bit
3. Oracle database not installed (including client not installed)
Workaround:
1. Download Instant Client Package
"Note: Many of the network posts are said that whether the machine is 32-bit or 64-bit must download 32-bit Instant Client package, Navicat the official said, many people also said the problem solved ..."
"Focus: But I downloaded the 32-bit is no, desperate the end of the moment to try to download the mood of the 64-bit package, incredibly connected success ..."
Download method: Baidu Instantclient, on the official website download can. (http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html)
Download the package:
2. After downloading the files, extract the files to your Navicat installation directory.
3, open the Navicat software, click on the menu bar ' tools '--' options '--' other '--' OCI '
4, find you put instantclient unzip the directory, find Oci.dll.
5, click to confirm. Restart the NAVICAT program. Connect again, Success!
Navicat Connecting Oracle Database error ORA-28547 Solution