ORA-12631: Username retrieval failed

[THoey]

All,

I have two new servers, one an Oracle 9.2 database server and the other an ASP Web Server, both running off of Windows 2000 that are receiving the following error:

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

Other servers in our company can access the data fine, so I am thinking that this is probably a setting somewhere on the ASP server that someone forgot to change. Any ideas?

Terry
**************************
* General Disclaimer - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[THoey]

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)


Terry
**************************
* General Disclaimer - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[THoey]

Okay, have been advised that this solution will not work as it causes automated logins to Oracle AS SYSDBA to not be allowed. They changes the authentication back to use NTS and now the web server cannot connect to the database as mentioned above.

Anyone else seen this error and figured out a way around it?

Terry
**************************
* General Disclaimer - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...