Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to authenticate DB Link

Mike YevtyeyevMay 16 2023

Hi, friends!

I need some help with database link and kerberos authentication. I apologize if this is wrong place to post, but I need to start somewhere.

I have a couple of the databases, both of them have kerberos authenticated user by the same name. User is able to login to both databases directly. I however need to create private link (in target database) to be able query data from another database (source).

Database link in target database created without specifying connect to user, just database connectivity information.

When i attempt query over link i am getting:

ORA-12662: proxy ticket retrieval failed
12662. 00000 - "proxy ticket retrieval failed"
*Cause: The authentication adapter used by Oracle Net failed to retrieve the
credentials needed to authenticate a database link.
*Action: Enable tracing to determine the exact error.

I suspect it is not related to the client configuration, but is rather issue between databases. By the way client is windows and servers are both on Linux.

Could someone at least hint the direction to solution to this problem?

Thanks beforehand!

Comments
Post Details