-
Either ORA-01031 or ORA-12638: Credentials retrieval failed.
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
-
you havent put when you are connecting as scott, only your sysdba access
-
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.
-
-
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 "
-
you have os issues if you need to do that
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|