Hello,
Oracle RAC 12.1.0.2 (2 node)
Windows 2008R2
I am trying to use DB link created from our departments to access data from other department. But while issuing SELECT statement I am getting error..
"ORA-12638: Credential retrieval failed"
From the Oracle forum & Internet, I found it can be solved by changing NTS value of SQLNET AUTH parameter to NONE..
It works after changing that parameter. But once I change that value, I am unable to login to database even wtih SYS password and gets below error.
ERROR:
ORA-01017: invalid username/password; logon denied
ORA-17503: ksfdopn:2 Failed to open file
+DATA/DTPS/PASSWORD/pwddtps.256.879004531
ORA-01017: invalid username/password; logon denied
How can we make both DB Link and SQLPLUS working without any error ?
Thank you in advance!
-Hitesh