问题

连接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安装路径oracle\product\10.2.0\db_1\NETWORK\ADMIN\sqlnet.ora 文件修改一下
在这里插入图片描述
把文件中的:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
修改为:
SQLNET.AUTHENTICATION_SERVICES= (BEQ,NONE)

修改前:

# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.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:\oracle\product\10.2.0\db_1\network\admin\sqlnet.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)

一个好奇的人