Set up the RDBMS

Lawson has the following setup requirements for all supported databases.

  1. Install the database client software on the Lawson server machine.
  2. Establish a database user and password.
  3. Create the database, observing the following guidelines:
    Database Guidelines
    Oracle

    The installation program will prompt for the TNS name or the SID. If you set up a SID, the SID name must not exceed 20 characters.

    Lawson does not support the UTF-8 character set.

    The client server character set must match that of the operating system where the client server runs.

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

    The Oracle database must be created with the following character set:

    NLS_CHARACTERSET= WE8ISO8859P1

    If Oracle is on a remote server, set the NLS_LANG variable on the Lawson server to the following character set: NLS_CHARACTERSET= WE8ISO8859P1

    Note: To locate the WE8ISO8859P1 character set:

    1. When creating the Oracle database, use the Database Configuration Assistant and choose the Advance Mode.

    2. In the Initialization Parameters step, under the Character Set tab, uncheck the "Show recommended character sets only" checkbox.

      This adds WE8ISO8859P1 to the drop-down list of character sets.

    3. Select WE8ISO8859P1 as your character set.

    For detailed instructions, refer to the Oracle Database documentation, available online.

    DB2

    The local alias name must not exceed 20 characters.

    Code page 819

    Code set ISO8859-1

    Sort order Binary (identity)
  4. Set up tablespaces for tables and indexes for both GEN and LOGAN.
  5. Verify that you can connect to the database before you begin the Lawson installation.
  6. Add the directory containing the database library(s) to the shared library path on your Lawson server machine. Lawson requires the 64-bit libraries for all supported databases.
  7. Set an environment variables to define the database locations.
    Database Define this variable
    Oracle $ORACLE_HOME must be defined as the directory where Oracle is installed.
    DB2

    $DB2HOME

    must equal ~$DB2INSTANCE/sqllib (the sqllib subdirectory in the home directory of the DB2 instance owner.

    $DB2INSTANCE must equal the DB2 database instance name.
  8. Verify that the directory location of the database client command is in the PATH variable on your Lawson server machine.
  9. Add the database environment variables to the environment variable script.

    $ORACLE_HOME or $DB2HOME

    DB2 only $DB2INSTANCE

    $PATH

    Shared library path