Database Preinstallation Tasks

Add environment variables and required values to the $PATH variable.

The choices you see in the installation program depend on what the installation program detects in the $PATH variable on the Lawson server machine.

1. Define an environment variable for the $ORACLE_HOME directory.

   $ORACLE_HOME must be defined as the directory where Oracle is installed.

2. Verify that the database location is in the $PATH variable.

   Note: If you plan to install GEN, LOGAN, and/or Lawson applications in different databases, all the directories must be in your path.

3. Verify that the directory containing the command to start the database client appears in your $PATH.

4. Verify that the directory containing the sqlplus command appears in your $PATH.

5. Add the directory containing the database libraries to the shared library path on your Lawson server machine.

For information and instructions, see the documentation provided with the database and/or the operating system.

The installation location of the GEN, LOGAN, and application databases.

The $ORACLE_HOME directory path for each instance.

Determine the initial number of simultaneous database connections

The installation program asks for the number of simultaneous database connections that you allow. A database connection is one driver job, or one open data area for each running program.

The default value is 500; you may need to increase this value significantly. Use this value to calculate the starting values of the USERS, FOREIGN, and IFILES parameters in the Lawson ladb.cfg file. Individually tune these values as required after installation.

Choose the Oracle protocol for the server connection

If the Oracle database is remote, choose TNS (TCP/IP). If Oracle is local, choose either TNS or SID.

Enter the TNS name for the Oracle server

Configure the TNS name must be configured in the file

$ORACLE_HOME/network/admin/tnsnames.ora

You may need to qualify the name (for example using MachineName.DomainName.com

), depending on the default domain name set in the file

$ORACLE_HOME/network/admin/sqlnet.ora

– or –

Enter the SID for the Oracle server

The SID (System ID) is the instance name for the Oracle server. This value must be configured in Oracle before you install Lawson.

Determine database user name (ID) and password

• The login name (user name) and password for the database user who accesses Lawson data at run-time.

  These values are mapped to the LOGINNAME and PASSWORD parameters in the ORACLE database driver configuration file.

Determine how to configure and name Oracle table spaces

Table spaces for GEN and LOGAN tables and indexes must be defined in Oracle as locally-managed with automatic extent management, which is the default.