Either ORA-01031 or ORA-12638: Credentials retrieval failed.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

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

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you havent put when you are connecting as scott, only your sysdba access

  3. #3
    Join Date
    Oct 2002
    Posts
    284
    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.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    so whats the problem?

  5. #5
    Join Date
    Oct 2002
    Posts
    284
    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 "

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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
  •  


Click Here to Expand Forum to Full Width