Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ORA-12631: Username retrieval failed

3,617 views
Skip to first unread message

RgrSoucy

unread,
Jul 25, 2003, 8:59:20 AM7/25/03
to
I have an Oracle 9i database running on Windows 2000. Recently when i tried to
use any of the tools such as the 'SQLPlus Worksheet', I get the following
error:

ERROR:
ORA-12631: Username retrieval failed

If I do a 'Test' from the odbc driver, I also get the message. The odd thing is
that my application that I use against the database does still work and I can
log in. Any idea's would be greatly appreciated. Thanks in Advance.

Roger

RgrSoucy

unread,
Jul 29, 2003, 12:19:07 PM7/29/03
to
This problem was finally resolved by me updating the following line in the
sqlnet.ora file from:

SQLNET.AUTHENTICATION_SERVICES= (NDS)

To:

SQLNET.AUTHENTICATION_SERVICES= (NONE)

Then everything worked again...

Rick Wessman

unread,
Aug 6, 2003, 5:20:03 PM8/6/03
to
It sounds like either NDS (Novell Directory Service) was selected as an
authentication method by accident during installation or the sqlnet.ora file was
modified incorrectly.

Rick

In article <20030729121907...@mb-m24.news.cs.com>, RgrSoucy says...

P.S. To respond by mail, please reverse the "elcaro".
Rick Wessman
Oracle Corporation
The opinions expressed above are mine and do not necessarily reflect
those of Oracle Corporation.

anand b

unread,
Aug 30, 2006, 12:48:21 AM8/30/06
to

I had same problems while connecting to the database. I modified
sqlnet.ora as mentioned and it is all working again.

But still I have not understood how sqlnet.ora got modified with the
wrong entry.

Regards,
AB.


--
anand b
------------------------------------------------------------------------
anand b's Profile: http://www.dbtalk.net/m746
View this thread: http://www.dbtalk.net/t61954

DA Morgan

unread,
Aug 30, 2006, 2:41:56 PM8/30/06
to
anand b wrote:
> I had same problems while connecting to the database. I modified
> sqlnet.ora as mentioned and it is all working again.
>
> But still I have not understood how sqlnet.ora got modified with the
> wrong entry.
>
> Regards,
> AB.

Then you have an internal security problem you need to address.

SQLNET.ORA can only be modified by people that have access to the
server. Who are they? Why do they have access? Which one did it?
--
Daniel A. Morgan
University of Washington
damo...@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

ManChild

unread,
Sep 13, 2006, 12:17:26 PM9/13/06
to

I have gotten so used to see this on 8i, 9i and 10g installs on Windows
that I have made it a point to check the sqlnet.ora file after sqlnet
has been configured --

J

0 new messages