2017 R1

Database CreationPermanent link for this heading

The creation of an Oracle database is described in chapter 2 “Creating and Configuring an Oracle Database” of the “Database Administrator's Guide”:

http://docs.oracle.com/database/121/ADMIN/create.htm

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.

Note:

  • 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”.