2 Replies Latest reply: Feb 6, 2013 8:40 AM by Kevin Thompson RSS

    Use oracle password authentification with NTS

    Kevin Thompson
      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