ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-12631: Username retrieval failed

ORA-12631: Username retrieval failed

原创 Linux操作系统 作者:fengjin821 时间:2009-06-11 14:10:10 0 删除 编辑

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,成功解决此问题。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13165828/viewspace-605896/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 真实的DBA 工作
请登录后发表评论 登录
全部评论

注册时间:2009-04-29

  • 博文量
    191
  • 访问量
    506749