• 连接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安装路径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)
    
  • 相关阅读:
    Hibernate中的HQL
    hibernate配置数据库连接池三种用法
    Hibernate的延迟检索和立即检索
    Hibernate关系映射中的注解
    Hibernate的多种关系映射(oto、otm、mtm)
    自然主键和代理主键的区别
    Hibernate的xml方法配置和操作代码
    Hibernate简介
    VirtualBox从USB设备(PE)启动图文教程
    属性动画
  • 原文地址:https://www.cnblogs.com/tian-ci/p/10543071.html
Copyright © 2020-2023  润新知