问题
连接Oracle数据库时报错:ORA-12638: 身份证明检索失败
C:Users***>sqlplus scott/tiger@192.168.56.103:1521/orcl
SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 1月 8 09:13:18 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12638: 身份证明检索失败
解决
将oracle安装路径oracleproduct10.2.0db_1NETWORKADMINsqlnet.ora
文件修改一下
把文件中的:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
修改为:
SQLNET.AUTHENTICATION_SERVICES= (BEQ,NONE)
修改前:
# sqlnet.ora Network Configuration File: C:oracleproduct10.2.0db_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
修改后:
# sqlnet.ora Network Configuration File: C:oracleproduct10.2.0db_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (BEQ,NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)