Home / server / Questions / 19517
In Process
Leonid Shirmanov
Asked: 2009-06-05 00:01:27 +0800 CST

Oracle Database character set issue with the audit tables on Debian

  • 772

I've got Oracle XE installed on Debian linux and the character set is configured to AL32UTF8. There are several client applications that connects to a database from Windows with the different locales - French etc, not English. That's ok with all the client data these applications put into database, nothing converted and text data in French represents correctly.

But texts in audit tables looks like '??????' if contains any not-english character. I suppose this is because audit records go to database in the different locale and it's not dependent on the client's globalization/locale settings.

How this globalization issue can be fixed? thanks!

debian security oracle localization

1 Answers

  1. The likely option is the the audit data is saved correctly in French, but YOUR client doesn't support it, so your Oracle client translate French letters to ???? for you.

    1. What is the NLS_LANG of your client / environment? (for example, from your environment)
    2. In order to check if the data is stored correctly in sys.aud$ table, run:

    SELECT username, ascii(username) from DBA_AUDIT_TRAIL; --optionally with a WHERE clause to limit it to a few suspected rows

    If all the ??? characters have the same ascii code, Oracle stores ???. If every ??? has a different ascii code, Oracle stores French letters and you client NLS_LANG configuration does not support French letters.

    I hope that helps you troubleshooting it...

    • 1