If the Oracle client was installed using the domain administrator account instead of the local administrator, the following message could be displayed when trying to connect:
ORA-12638: Credential retrieval failed
From the wording of the error message one could think that this error means that he is using the wrong password but this is not the case. To solve this:
1) Go to /oracle home/network/admin and open sqlnet.ora
2) Search forย SQLNET.AUTHENTICATION_SERVICES= (NTS) and change it to
SQLNET.AUTHENTICATION_SERVICES= (NONE)
3) Save the file and try to connect, this should work
Thanks
It really worked and solved my problem ๐
no problem, glad to help.
when change name
SQLNET.AUTHENTICATION_SERVICES= (NTS) and change it to
SQLNET.AUTHENTICATION_SERVICES= (NONE)
error come ORACLE NOT AVILABE please give me solution
if you are sure that oracle service is up (sometimes this message means that the service is not running) try to open the command line and type set oracle_sid=your_sid_name and than SQLPLUS and see if it works. It is possible that your oracle_sid parameter is not set.
I changed the NTS in the file and it worked. thank a lot.
that actually works
thx alot
Thanks a lot. It worked for me.
Did not work for me. Now getting ORA-01031: insufficient privileges
@Robert, what are you trying to do when you get the ora-01031? this message is shown when the user is trying to do something (create a table or a view for example) without the right permission.
This actually means that you are connected and it probably did work for you.
Thanks a lot. It worked.
I changed it to NONE but I am getting the same ORA-12638 error. What else is going on?
I have to add, I was trying to connect using sever explorer db connection in Visual Studio 2010 premium.
Verify that you are using the right oracle home. Try to change tnsnames and check that you are seeing the changed entry.
It solves my problem. But the performance decrease dramaticly
This is a client side solution. It shold have no effect on db performence. Verify that you are using the correct client version.
Tnx
Thanks a lot!
Thank you very much, god bless you for this valuable help.
Greeting from domincan republic.
It worked for me.. Thanks a lot!
It did work, thanks for the solution.
Thanks!
Just to clarify, this has to be done on the client machine. And restart Toad or whatever client application you are using
thanks again!
Thank you it’s perfect !
Thanks.. it worked for me..
Thanks a lot. Saved hell lot of time.
Thanks a lot !!!
Wow!
A simple fix that actually fixes the issue in hand (I rarely find them these days)
5:00pm panic averted!
Thank you very much.Problem fixed in no time.Appreciate for posting this helpful tip.
By doing this you will not be able to use ‘sqlplus “/as sysdba” ‘ on the host.
This is a client solution. Why would affect the server?
Thanks, really appreciate this tip.
Thankyou this worked for me … (Changing to NONE) – Many Thanks
Thanks you so much this is very help for me. thanks once again!
Grazie,
I solved my problem ๐
It’s work! Thx!
REALLY THANKS FOR GIVEN GOOD
It worked for me, thank you very much
it worked..Great!!!!!!!!! Thanks
Thank you very much. This works great on ORACLE 11G XE intalled on WINDOWS 8
Gracias!!
Funcionou.
Obrigado
Thank you so much! This worked for me!