Database Installation and Configuration Requirements

This document provides guidelines and requirements for configuring the database to work with the Lawson system.

Caution: 

Lawson does not provide instructions for installing Oracle products; installing the database is the responsibility of the customer. Lawson cannot assume any responsibility for the results of an improper installation. Use the documentation provided with the Oracle database for installation instructions.

Database Settings

  • Use the following table to help determine the settings you need for Unicode support.

    Landmark Landmark with Infor Lawson System Foundation
    Character set (NLS_CHARACTERSET)

    WE8MSWIN1252

    WE8MSWIN1252
    Sort order (NLS_SORT) Binary Binary
    Note: 

    To correctly configure Lawson to use Oracle, the database client character set must match that of the operating system the client is running on.

    For example, set:

    NLS_LANG=Language_Territory.CharacterSet

    or,

    NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

    Implementing Unicode Support

For more information, see the Oracle NLS_LANG FAQ, located at http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm

Oracle Configuration Parameter Initial Settings

The following table lists recommended initial values for some key configuration parameters in the Oracle init.ora file.

Note: 

These numbers should be reviewed and adjusted by a database administrator, based on system use at your installation site.

Parameter Recommended initial value
processes 800
dml_locks 1000
open_cursors 800

Database Support for the Text Search Feature

To enable the text search feature, you must install and configure the Oracle Text component of the Oracle database. The Oracle Text home page is a good place to start learning about this feature: http://www.oracle.com/technology/products/text/index.html, and the Oracle Text Application Developer's Guide includes a chapter on administration of this feature.

For more detailed information on text search setup and configuration, see Implementing Text Indexing and Text Searches.