The creation of an Oracle database is described in chapter 2 “Creating and Configuring an Oracle Database” of the “Database Administrator's Guide”:
Define “Use Unicode (AL32UTF8)” as database character set, “American” as default language and “United States” as default date format.
For Fabasoft Folio an existing database or a new one can be used.
- Keep in mind to set the NLS_LANG parameter (used by the Oracle Instant Client) to “AMERICAN_AMERICA.AL32UTF8” on the Fabasoft Folio Backend Server. More information about the NLS_LANG parameter can be found here: http://www.oracle.com/technetwork/products/globalization/nls-lang-099431.html
- Verify that the database parameter DISTRIBUTED_LOCK_TIMEOUT is set to at least “120”. If the default value (“60”) is used, errors may occur (“ORA-02049: timeout: distributed transaction waiting for lock” or “ORA-01591: lock held by in-doubt distributed transaction”).
It is recommended to set the value to “300”.