Use oracle password authentification with NTS
Hi,
Database: Oracle 11.2.0.2
OS: Windows Server 2008 R2
I am trying to create a database link from a RAC database to a remote database. I have added an entry for the remote database in the tnsnames.ora on all RAC servers but when I try a SQLplus connection I get:
ORA-12638 Credential retrieval failed
The sqlnet.ora has the following entry:
SQLNET.AUTHENTICATION_SERVICES= (NONE,NTS)
I know setting this to (NONE) will prevent this ORA-12638 error but my understanding is that NTS is required for RAC - please correct me if you I'm wrong?
Basically, I want to use Oracle username/password authentication for a database link without setting the SQLNET.AUTHENTICATION_SERVICES= (NONE)
All comments welcome !
Thanks,
Kevin