ORA-12638 credential retrieval failed Weird Problem

• papabeartai

  SSC Veteran

  Points: 231

  More actions

  March 14, 2011 at 6:23 pm

  #73018

  Hi,

  I created a linked server from my 2005 box to an Oracle 11g server running on Windows.

  I have two stored procedure which runs fine manually. However, when I create a

  SQL Server Agent job to run, it throws the ORA-12638 error.

  Changing Authentication to NONE does not help. Any suggestions much appreciate.

  RT

• Peter Maloof

  SSCommitted

  Points: 1733

  More actions

  March 15, 2011 at 12:48 pm

  #1299066

  I don't have any experience with linked servers, but this might help:

  1. You've verified there's only one sqlnet.ora file, right?

  2. What does your SQLNET.AUTHENTICATION_SERVICES statement look like:

  SQLNET.AUTHENTICATION_SERVICES=NONE or

  SQLNET.AUTHENTICATION_SERVICES=(NONE)

  3. Using SQLNET.AUTHENTICATION_SERVICES=(NONE,BEQ) might help.

  4. Does the SQL Agent have to be in the ORA_DBA group?

  5. Make sure the ORACLE_SID parameter is set.

  ---

  Peter MaloofServing Data