WINDOWS上出现ORA-28547 Error Using ODBC Application or Net Manager

刘泽宇

现象：An application using the ODBC driver fails to connect.  The error returned to the screen is:

ORA-28547: connection to server failed, probable Oracle Net admin error.

The ODBC DSN test button yields the same error.
The same error may be reproduced using the Net Manager tool to create and test a service.  If Net Manager is running in the same home as the ODBC client.
This problem will not likely reproduce using SQL*Plus from the same ORACLE_HOME.

造成原因：

Bug 8209821 : NTS AUTHENTICATION DOES NOT PICK KERBEROS IN 10.2 VERSION

处理方法：

The only available workaround is to change the following sqlnet.ora file parameter on the client (see note below):
Current setting is:
SQLNET.AUTHENTICATION_SERVICES=(NTS)

Change to:
SQLNET.AUTHENTICATION_SERVICES=(NONE)

*NOTE: It is not necessary nor is it desirable, to change this parameter on the Database server.  In fact, many Windows DBAs use OS authentication and require the NTS service to be available on the server itself.

参照官方文档：ID 1080521.1