Hi Everyone,
We want to upgrade Jira Core server version(8.20.1) to DataCenter version.
However, it gives a health check database collation warning. We perform the following steps in the database, the result is "BINARY" as Jira wants.
Related parameters on both database and session basis are BINARY.
nls_com=BINARY, nls_sort=BINARY
https://confluence.atlassian.com/jirakb/database-collation-health-check-fails-in-jira-server-790955315.html
https://confluence.atlassian.com/jirakb/health-check-database-collation-in-oracle-943951532.html
It sounds like the SQL that the support document says must have a BINARY result.
so, Why does healt check still give a collation warning when all conditions are as jira wants?
thank you
slq:
<span>SELECT</span> <span>COALESCE</span><span>(</span><span>value</span><span>,</span> <span>(</span><span>SELECT</span> <span>value</span>
<span>FROM</span> nls_database_parameters
<span>WHERE</span> parameter <span>=</span> <span>'NLS_SORT'</span><span>)</span><span>)</span>
<span>FROM</span> nls_session_parameters
<span>WHERE</span> parameter <span>=</span> <span>'NLS_SORT'</span>
