Navicat "Ora-28547:connection to server failed

My "ora-28547:connection to server failed,probable Oracle Net Admin Error" Resolution steps (NAVICAT,TOAD,PLSQL Developer tools Common)

Connect Oracle 11g Suddenly popped an error "ora-28547:connection to server failed,probable Oracle Net admin Error", see, I'm a go, really depressed dead, Helpless in the online search for a long time to find a solution, written down for later reference.

650) this.width=650; "style=" BORDER-WIDTH:0PX;BORDER-STYLE:NONE;WIDTH:669PX; "title=" QQ20120307213721 "alt=" QQ20120307213721 "src=" http://images.cnblogs.com/cnblogs_com/juddhu/201203/201203072158369099.png "border=" 0 " height= "154" width= "760"/>

The first method solution:

Listener.ora is the server-side configuration of Oracle files.

And then commented out this line of Listener.ora, just go, (program = Extproc)
Modified to:
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = prod)
(Oracle_home =/u01/app/oracle/product/10.2.0/db_1)
# (program = Extproc)
)
)

LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.8) (PORT = 1522))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0))
)
)

The second solution is as follows:

Reference Path: https://forums.oracle.com/forums/message.jspa?messageID=693607

Tidy up as follows:

The client configuration file Sqlnet.ora is configured as follows:

Will #sqlnet. authentication_services= (NTS) Comment out, change to the following can!

As follows:
Sqlnet. Authentication_services= (NONE)

Modify the listener profile at the same time by searching for the Listener.ora file in the Oracle installation directory, typically in the $/network/admin directory, replacing the hostname with an IP address, for example (address = (PROTOCOL = TCP) ( Host = HBONLINE1) (port = 1523) is changed to (ADDRESS = (PROTOCOL = TCP) (host = 168.168.168.42) (port = 1523)).

The third solution:

If you use the Plsql Developer tool or Toad tool above, you should definitely solve your problem with the above operation.

But if you're using the Navicat tool, the above is not going to solve your problem. Specific if used on the Navicat tool is the following question:

Oracle is basically the default installation and the installation process has not experienced any exceptions
Oracle opens two services: ORACLESERVICEORCL and Oracleoradb11g_home1tnslistener
Navicat is not connected to local Oracle
Search the Internet a lot of information, mostly to change the 3 configuration files
It's not going to solve the problem at the end.
The final question is:
Navicat host where if you fill in the native IP address (192.168.18.8), the error code is: Ora-12541:tns:no Listener
If you fill in localhost, the error code is: ora-28547:connection to server failed,probable Oracle Net admin Error
Tnsping localhost is a pass, tnsping 192.168.18.8 error TNS-12541:TNS: no listening program

The solution is:

Oci.dll version is incorrect
Download client from http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
There are many, according to your version to the next, I downloaded is instantclient_11_1.
In Navicat Tools-options-Other-oci, select the Oci.dll in the client just below
Set Environment variables:
1) Add C:\Instantclient10_2 at the beginning of the environment variable path;
2) Add user environment variable SQLPath, value is C:\Instantclient10_2
3) Add user environment variable Nls_lang, value is American_america. UTF8
Select the Basic connection and you'll probably be able to connect.

The above actions can be checked by the following:

To find:
1, first confirm that your database has been started, you can use net start ORACLESERVICEORCL
2, next confirm that your listening start No, with Lsnrctl status View, if not started, start with Lsnrctl start.
3, the above start, directly open Sqlplus, enter the user name password, no need to enter the service name, directly login can.

***************************************************************************************

Take the next step and leave the footprints. Hope the farther away, go more stable, better!

Alter Hu
Blog Address: http://www.cnblogs.com/alterhu/

This article is copyright to the author and the blog Park, Welcome to reprint, but without the consent of the author must retain this paragraph, and in the article page obvious location to the original link, otherwise reserves the right to pursue legal responsibility.
***************************************************************************************

This article from "Mr_computer" blog, reproduced please contact the author!

Navicat "Ora-28547:connection to server failed