ORA-12631: Username retrieval failed

最新推荐文章于 2024-05-06 17:08:23 发布

原创最新推荐文章于 2024-05-06 17:08:23 发布 · 716 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#authentication #database #domain #network #microsoft #oracle

技术积累专栏收录该内容

82 篇文章

订阅专栏

博客提及Oracle 10G冒出错误，但未详细说明错误情况。主要围绕信息技术领域的Oracle数据库相关问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Oracle 10G冒出的错误：

ORA-12631: Username retrieval failed
Cause: The authentication service failed to retrieve the name of a user.
Action: Enable tracing to determine which routine is failing.

Error Type:
Microsoft OLE DB Provider for Oracle (0x80004005)
ORA-12631: Username retrieval failed
/apps/beta14a.asp, line 96
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; SBC; .NET CLR 1.0.3705; .NET CLR 1.1.4322)
Page:
GET /apps/beta14a.asp
Time:
Monday, July 12, 2004, 10:23:05 AM

对于这个错误，一般是由于使用域用户帐号登录导致的，如果换成本地用户则没有问题。
解决方案：
RESOLUTION on METALINK:

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)

通过使用NONE，成功解决此问题。