DB session parameters depend on DB server OS language

XMLWordPrintable

    • 7.01
    • 13
    • Severity 2 - Major
    • 1

      "Instance Health" detected a Collation problem with the following error message: The session collation of: 'GERMAN' is unsupported by JIRA

      Each time JIRA opens a DB session on an Oracle DB the session does not take the nls_* parameters set in the DB or the DB schema but from informations it gets from the OS.
      (i.e. set nls_sort=BINARY' on DB and and DB session will be changed within the session to nls_sort=GERMAN' just because the DB is installed on a German Windows2012)

      In my opinion the language of the OS must not influence the DB session parameters.

      Our selfmade solution is:
      Creating a session trigger on the DB which alters the parameter back to nls_sort=BINARY'

      Please fix this bug or document it in the installation description.

            Assignee:
            Unassigned
            Reporter:
            Thomas Ransberger
            Votes:
            9 Vote for this issue
            Watchers:
            18 Start watching this issue

              Created:
              Updated: