Either ORA-01031 or ORA-12638: Credentials retrieval failed.

[vr76413]

Hello all..

I Installed Oracle 10.2.0.1 on Windows 2003 Server using Domain Admin (insdo) Account. There is no Local Accnt on this box.

This 'insdo ' is a member of ora_dba group and admin group.

Now sqlnet.ora file on the Windows Server is
SQLNET.AUTHENTICATION_SERVICES = (NTS)

----------------------------------------------
C:\Documents and Settings\isdo>set ORACLE_SID=miloisd
C:\Documents and Settings\isdo>sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Nov 7 09:28:33 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> conn / as sysdba
Connected.
-------------------------------------------------

but when i connect as Oracle user scott using SQLPLUS , i get this error
ORA-12638: Credentials retrieval failed.



Now, when i change SQLNET file entry to
SQLNET.AUTHENTICATION_SERVICES = (NONE)

I can Connect Scott using SQLPLUS without any problems.
but when i try OS authentication

-------------------------------------------------------
C:\Documents and Settings\isdo>set ORACLE_SID=miloisd
C:\Documents and Settings\isdo>sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Nov 7 09:24:36 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges
----------------------------------------



SO basically i have to pick and choose my sides and can't both the work.
Any help ?

Thanks
Ron

[davey23uk]

you havent put when you are connecting as scott, only your sysdba access

[vr76413]

ORA-12638: Credentials retrieval failed error doesn't happen all the time, but happens at a fairly regular frequency. May be 1-2 times a day.

I have to log off my Cleint Desktop and Log Back in to get rid of that Error.

[davey23uk]

so whats the problem?

[vr76413]

Why do i have to Log off and Logon to connect to Database ?..All current Connections on the Client machine throw back the error message
"ORA-12638: Credentials retrieval failed "

[davey23uk]

you have os issues if you need to do that