• ORA-12631 / TNS-12631: Username retrieval failed


    From Metalink:

    Problem Description:
    ====================
    When your server is not connected to the network and you try to connect in
    Server Manager (svrmgrl), the connection fails returning an ORA-12570. If you
    check the "sqlnet.log" you will find a TNS-12631 error.

    ORA-12570 / TNS-12570: TNS:packet reader failure 
    ORA-12631 / TNS-12631: Username retrieval failed 

    Problem Explanation:
    ====================
    These errors are associated with remote authentication on NT under NTS (NT Transport Services).

    Essentially, the following parameter is set in the "sqlnet.ora":
    SQLNET.AUTHENTICATION_SERVICES = (NTS)
    As a result, if you are logged on as a domain user, and you don't have a network connection (network cable temporary removed or laptop booted standalone), you will not be able to connect to the database because the authentication will try to reach the domain users database on the PDC (Primary Domain Controller) or BDC (Backup Domain Controller).


    Solution Description:
    =====================
    There a 2 solutions to connect to the database when no network is present:
    1. You can log in as a NT local user. 
    2. You can disable NTS in sqlnet.ora by setting the following parameter:
      SQLNET.AUTHENTICATION_SERVICES = (NONE)

    Explanation:
    ============
    1. When you log in as a local user, then the local users database is contacted and not the remote domain users database.
    2. When NTS is disabled, even though you are logged in as a domain user, the domain user's database will not be accessed.

  • 相关阅读:
    typescript学习记录-基础类型(3)
    typescript学习记录-基础语法(2)
    typescript学习记录-介绍与环境(1)
    elementUI中的日历组件(DatePicker)怎样单独设置默认年和默认月
    怎样保持div中的子元素的长宽比例展示
    大批量端口扫描、服务识别
    域环境搭建
    sed 替换换行符
    zmap/masscan 快速扫描网络
    内网渗透——代理和转发
  • 原文地址:https://www.cnblogs.com/princessd8251/p/4018958.html
Copyright © 2020-2023  润新知