重庆思庄Oracle、Redhat认证学习论坛

标题: WINDOWS上出现ORA-28547 Error Using ODBC Application or Net Manager [打印本页]

作者: 刘泽宇 时间: 2021-7-4 13:18
标题: WINDOWS上出现ORA-28547 Error Using ODBC Application or Net Manager
本帖最后由刘泽宇于 2021-7-4 13:19 编辑

现象：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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)