牧码

时间不多，道路很长

连接Oracle报错 ORA-12638: 身份证明检索失败

问题

连接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)
posted @ 2019-01-08 09:26  脚印在泥泞路上  阅读(1180)  评论(0)  编辑  收藏  举报