Overview

The new Ranking system (often called Lexo Rank) requires specific database configuration in Oracle. Follow the steps below to check the current configuration.

1. Run the following SQL to check on the database sort and comparison setting, Expected value is (BINARY)

   SELECT * FROM nls_session_parameters WHERE parameter IN ('NLS_COMP', 'NLS_SORT');
    
   SELECT * FROM nls_database_parameters WHERE parameter IN ('NLS_COMP', 'NLS_SORT');
    
   SELECT SYS_CONTEXT('USERENV','NLS_SORT') nls_sort FROM DUAL;

2. Run the following SQL to check on the database collation, Expected value is `AL32UTF8`

   SELECT * FROM nls_session_parameters WHERE PARAMETER='NLS_CHARACTERSET';
    
   SELECT * FROM nls_database_parameters WHERE PARAMETER='NLS_CHARACTERSET';

Resolution

If the SQL result is not returning the expected result, contact your local DBA to change the configuration as per the expected result.