ora-12638: Identity retrieval failed. With Sql:select * from T@zjdtdblink. Workaround:
Look at the Dtdblink data link in the Dbastudio, not active. Look at the domain server. The problem is resolved after restarting the domain server. Check online and make a further explanation:
Cause: Credential retrieval failed due to Oracle's inability to apply OS authentication
Action
1. Open Network/admin under Sqlnet.ora modify Sqlnet.authentication _services= (NONE).
2. Start NET8 configuration assistant--> select the third local network service name configuration--> Delete ... (delete the original local network service name)
3. Repeat step Two--> Add. (new local network service name)
4.
Restart Oracle---------------------------------------------------------------
NTS is the Winnt authentication method---------------------------------------------------------------
In Sqlnet.ora, #sqlnet. Authentication_services = (TCP) is changed to
#sqlnet. Authentication_services = (NONE) or comment out this line-------------------------------
Sqlnet.authentication_services = (NONE)