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