Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can't switch user from sqlplus : ORA-12638 Credential retrieval failed

Andrea MOct 2 2007 — edited Oct 5 2007
hi all,

i just installed Oracle10.2.0.1 on my laptop, and i got a problem when switching user in sql*plus: i can login using 'sqlplus / as sysdba' or 'sqlplus user/pwd' or 'sqlplus /nolog + conn user/pwd' or 'sqlplus /nolog' + 'conn / as sysdba'ì, but every time i try to switch user (i.e. every time i do a connect while being already logged into the database) i receive the error
ORA-12638 Credential retrieval failed
So i need to exit from sqlplus and start it again (you can see an example og what's happening at the end of this post)

I installed Oracle 10.2.0 and i created a simple db using dbca (no patches applied yet).
My laptop (win xp sp2, all patched installed) already had installled Oracle 9.2 client and Oracle 10.2 client, but I always connect to the database using the "right" sqlplus.exe, i.e. running
c:\oracle\product\10.2.0\db_1\BIN\sqlplus.exe

the glogin.sql is almost empty (there are only a few COL commands),
login.sql does not exists.

sqlnet.ora contains
SQLNET.AUTHENTICATION_SERVICES= (NTS)
and if i change it to
SQLNET.AUTHENTICATION_SERVICES= (NONE)
everything works fine.

So my questions are:
- why both NTS authentication and password authentication only work once with sqlnet.authentication_services=(NTS) ?
- How can I fix these essors to use both NTS and password authentication, as i am used to do?

thanks!

andrea

---------------------------------------------------
login example

Microsoft Windows XP [Versione 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\amonti>set ORACLE_SID=ORCL

C:\Documents and Settings\amonti>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mar Ott 2 10:29:28 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connesso a:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> conn system/manager
ERROR:
ORA-12638: Recupero credenziali non riuscito


Avvertenza: Connessione a ORACLE interrotta.
SQL> conn / as sysdba
ERROR:
ORA-12638: Recupero credenziali non riuscito


SQL> exit

C:\Documents and Settings\amonti>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mar Ott 2 11:28:35 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn system/manager
Connesso.
SQL> conn / as sysdba
ERROR:
ORA-12638: Recupero credenziali non riuscito


Avvertenza: Connessione a ORACLE interrotta.
SQL>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2007
Added on Oct 2 2007
5 comments
1,493 views