{"id":451,"date":"2019-02-24T20:22:23","date_gmt":"2019-02-24T20:22:23","guid":{"rendered":"https:\/\/www.spotonoracle.com\/?p=451"},"modified":"2019-06-08T13:56:25","modified_gmt":"2019-06-08T13:56:25","slug":"bugs-are-annoying-kerberos-ticket-issue","status":"publish","type":"post","link":"https:\/\/www.spotonoracle.com\/?p=451","title":{"rendered":"Bugs are annoying – Kerberos ticket issue"},"content":{"rendered":"

Update 08-JUN-2018<\/strong><\/i>
\nThis bug has been fixed with the Oracle 19.3 client release for Windows. Below workaround should not be necessary anymore.<\/i><\/p>\n

One cool feature of using Kerberos authentication is that when you have a TGT (Ticket Granting Ticket) in the ticket cache the Oracle client software can use that to get a service ticket and log you into the database without further asking for any credentials (single sing-on).<\/p>\n

Here’s what it looks like with a Kerberos authenticated SSH session on Linux:
\n\"\"<\/a>
\nAs you can see from the screenshot the “orasrv” service ticket is flagged “forwardable” and the database login is successful (“-f” tells “oklist” to show the ticket flags).<\/p>\n

On Windows on the other hand the same fails with “ORA-12638: Credential retrieval failed”:
\n\"\"<\/a><\/p>\n

If we change to “non-forwardable” service tickets it works on both, Linux and Windows:
\n\"\"<\/a><\/p>\n

How do you change to “non-forwardable” service tickets?<\/strong>
\n1) Use “okinit” to manually re-initialize your ticket cache. By default it will get “non-forwardable” tickets (or use “-F” to be explicit).<\/p>\n

2) You can configure the service principal in Active Directory so only “non-forwadable” tickets will be issued (even when you use “okinit -f” to explicitly ask for “forwardable” tickets)
\n\"\"<\/a><\/p>\n

Both workarounds do the trick but I don’t like neither of them for their obvious drawbacks. After a few weeks trying to convince the Oracle Support Engineer of the issue bug 28734494 has been filed on Oct 8, 2018 with no notable progress to date \ud83d\ude41
Despite what the bug description says the issue is not MSLSA vs file ticket cache, it is the ticket flags that make or break.<\/p>\n

Btw. I’ve tested client versions 12.2.0.1, 18.3, 18.5 and they all exhibit the same behaviour.<\/p>\n","protected":false},"excerpt":{"rendered":"

Update 08-JUN-2018 This bug has been fixed with the Oracle 19.3 client release for Windows. Below workaround should not be necessary anymore. One cool feature of using Kerberos authentication is that when you have a TGT (Ticket Granting Ticket) in the ticket cache the Oracle client software can use that to get a service ticket […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,12],"tags":[],"class_list":["post-451","post","type-post","status-publish","format-standard","hentry","category-internals","category-security"],"_links":{"self":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts\/451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=451"}],"version-history":[{"count":14,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts\/451\/revisions"}],"predecessor-version":[{"id":466,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts\/451\/revisions\/466"}],"wp:attachment":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}