Oracle Learning Note 4 error when using NAVICAT for Oracle connection Oracle: Ora-28547:connection to server failed, probable Oracle Net admin Error

The problem to the machine environment:
Oracle 11gR2 64bit
Navicat for Oracle 11.0.10

According to the practices of some of the great gods on the internet and some of the personal speculations, the following are summarized:

The problem occurs because the navicat is inconsistent with the number of bits of Oracle, the former 32bit, the latter 64bit
Some of the online practices are not effective:
1. Modification of Listener.ora or Tnsname.ora configuration files in Oracle is not effective;
2. Replace Oci.dll in Navicat with Oci.dll in Oracle, "Cannot load Oci.dll" error will not take effect;
3. Configure the Navicat tool--and other-->oci--> paths to the Oci.dll path under Oracle, which fails to take effect;

Speculation: The above method, the great God before the release, certainly resolved the ORA-28547 errors they encountered, but the cause of the error is different, so at this time not effective ...

Effective practices for ORA-28547 caused by this type of cause:
Step1: To view your own Oracle specific version number, you can enter the sqlplus-version command in CMD
Step2: to http://www.oracle.com/technetwork/topics/winsoft-085727.html download consistent with your Oracle version
An instance client of 32bit. For example: The Oracle version on the data server is: 11.2.0.2.0, find the page Version11.2.0.2.0 the first file below the download can be instantclient-basic-nt-11.2.0.2.0.zip (note that Select Accept License agreement before downloading, then download, right-click on Connect-to save target as you can)
Step3: Unzip the 32-bit instance client that you just downloaded, find the specific path to the Oci.dll, and set it to Navicat
:navciat--> Tools--and other-->oci, in the OCI library box, select the path oci.dll in the instance client that you just downloaded.
Step4: Restart Navicat, test connection

Oracle Learning Note 4 error when using NAVICAT for Oracle connection Oracle: Ora-28547:connection to server failed, probable Oracle Net admin Error