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: MicrosoftOLE DB Provider for Oracle (0x80004005) ORA-12631: Username retrieval failed /apps/beta14a.asp, line 9...
ORA-12631: TNS: 用户名检索失败 metalink一把,解决方法: 把客户端sqlnet.ora中的 SQLNET.AUTHENTICATION_SERVICES= (NTS) 改为 SQLNET.AUTHENTICATION_SERVICES= (NONE) 即可 服务器端:Windows,Oracle 19.22 登录到服务器端时出现错误: ERROR: ORA-12631: TNS: 用户名检索失败 metalink一把,解决方法: 把客户端...
We have error when connecting to Oracle - ORA-12631 : username retrieval failed Problem Description: Failed to login to Oracle 11.2.0.1 database from SQLPLUS as SYS user. Our testing environment: Windows 2008 domain controller has the following: - domain administrator user - domain user (regular...
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: ...
ORA-12631 / TNS-12631: Username retrieval failed Problem Explanation: === These errors are associated with remote authentication on NT under NTS (NTTransport Services). Essentially, the following parameter is set in the "sqlnet.ora": SQLNET.AUTHENTICATION_SERVICES...
Using Oracle Database with Microsoft Active Directory
Information in this document applies to any platform.SymptomsWhile attempting to connect to the database the following error occurs: sqlplus system/password@dbnameError: ORA-12631 "username retrieval failed" The error occurs only when sqlnet.ora parameter:SQLNET.AUTHENTICATION_SERVICES = (NTS)is set....
We have error when connecting to Oracle - ORA-12631 : username retrieval failed Problem Description: Failed to login to Oracle 11.2.0.1 database from SQLPLUS as SYS user. Our testing environment: Windows 2008 domain controller has the following: ...
Using Oracle Database with Microsoft Active Directory
1. with sqlnet.ora content: sqlnet.authentication_services=(NONE) sqlplus / as sysdba get ORA-1031 insufficient privileges 2. with sqlnet.ora content: sqlnet.authentication_services=(NTS) sqlplus / as sysdba get ORA-12631 Username retrieval failedCause...