Navicat Connect Oracle Database ora-28547:connection to server failed, probable Oracle Net admin error Error, workaround

Navicat PREMIUM11 Connection Oracle appears ora-28547:connection to server failed

Environment Description:
Local Oracle is installed normally, and no exception occurs halfway through.
Ensure that Oracle's primary services are started.
1, ORACLESERVICEORCL
2, Oracleoradb11g_home1tnslistener

Problem Description:
Navicat creates a new Oracle connection, in the host or IP address column.
If you fill out the native IP, you will report Ora-12541:tns:no listener.
If you fill out localhost, you will report ora-28547:connection to server failed

Workaround:
Navicat Oci.dll version is wrong, my computer is installed oracle11g.

Method one: Directly in Navicat, tool-> option-> other->OCI below reset the path of the OCI library, where I point to my Computer installation Oracle directory E:\Oracle11g\product\11.2.0\ Dbhome_1\bin\oci.dll, restart Navicat will not be an error.

Method Two:
Download the Oracle client at the address below and install

1	http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gr2_client.zip

The path to the OCI library is then directed to the Oci.dll in the client in method one.
To set environment variables:
(1) Increasing C:\Instantclient10_2 at the beginning of the environment variable path;
(2) Increase the user environment variable SQLPath, the value is C:\Instantclient10_2
(3) Increase the user environment variable Nls_lang, the value is American_america. UTF8