health checks database collation about

[serkan_sezer]

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:

SELECT COALESCE(value, (SELECT value 
                        FROM   nls_database_parameters 
                        WHERE  parameter = 'NLS_SORT')) 
FROM   nls_session_parameters 
WHERE  parameter = 'NLS_SORT'

[Pavel Junek]

Hi Serkan,

After making changes, Jira must be restarted for the changes to take effect.

Pavel

[serkan_sezer]

Hello,
we haven't made any changes here but i will try your suggestion anyway
Kind regards.