cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Identity suggest issues with Oracle database

Identity suggest issues with Oracle database

One can run into strange sorting issues when using the identity select/search widgets inside the IdentityIQ UI. For example, if the IdentityIQ data is in German, the default Oracle sort order of binary can abort the search and return no values.

 

Set the following Oracle sorting variables to the following:

NLS_COMP=LINGUISTIC

NLS_SORT=BINARY_CI

 

Note: The information above applies only to Oracle 11.2.0.2 prior to Patch 25. If you are using Oracle 11.2.02 Patch 25 or later or Oracle 11.2.0.3, this workaround is not required.

Labels (2)
Comments

The information above applies only to Oracle 11.2.0.2 prior to Patch 25.  if you are using Oracle 11.2.02 Patch 25 or later or Oracle 11.2.0.3, this workaround is not required.

We have had these two NLS setting for past few years.

NLS_COMP=LINGUISTIC

NLS_SORT=BINARY_CI

We've upgraded our Oracle DB to 11.2.0.4.

Does it mean we need to or should revert back to using the defaults?

NLS_COMP=BINARY

NLS_SORT=BINARY

Version history
Revision #:
2 of 2
Last update:
‎Jun 08, 2023 10:22 PM
Updated by:
 
Contributors