| # Oracle Server This chapter describes how to setup the Oracle software. Before you install the ERP LN software, you must perform several tasks described in the following sections. Overview of the installation process Oracle installations are version-dependant and system-dependant. The installation procedures provided in this section are examples. Check your Oracle documentation for the installation procedure for the Oracle version you are installing. The Oracle Installation Guide describes the procedures to create the Oracle installation environment, and to run the Oracle installer for your operating system and media type. Short overview of the installation steps To install the Oracle Software, complete the following procedures: Create the Oracle installation environment. Run the Oracle installer. Create an Oracle instance using Database Configuration Assistant, known as dbca. If the installation was successful, click Exit to end the installation. Requirements Install the latest version of the Oracle software. You can use several hardware configurations to install ERP LN with Oracle. For more-detailed information, refer to the Enterprise Server Technical Notes (U8891 US) or contact Infor for additional sizing information Caution! In case of a multibyte installation, a double amount of disk space is required. Solution Check solution 166049 for Important Oracle 10g Parameters To tune the kernel for Oracle You have already tuned the kernel of the UNIX machine to accommodate the projected number of users for ERP LN. Now tune the kernel for Oracle. Check the pre installation tasks in the Oracle documentation. Character set for the Oracle Instance In case of a Multibyte language pack installation such as Japanese, Simplified Chinese, Traditional Chinese, or Korean, it is recommended while creating the oracle instance, you select " Choose the appropriate Character set ". The following table shows the available character sets:
Language Pack | Oracle instance character set
Japanese | ja16sjis
Simplified Chinese | zhs16cgb231280
Traditional Chinese | zht32euc
Korean | ko16ksc5601
To install the Oracle software To install the Oracle software, you must use the Oracle Installation Manuals. Create an Oracle instance for a default ERP LN installation With user oracle, start the Database Configuration Assistant.
    $cd $ORACLEHOME/bin
    $./dbca
The Welcome dialog box will appear. During the process, several dialog boxes appear. This section provides notes when you create an instance with the Database Configuration Assistant. Database Options dialog box In case of a default ERP LN installation, clear all the check boxes, including the check boxes in the Additional Database Configurations area. Database Connections dialog box Click Dedicated Server Mode. You can change this later in the Oracle configuration. Initialize Parameters dialog box On the Memory tab, select Custom and fill in the fields. The values to use are left to the installer. If the values are not correct, this can negatively impact performance. Therefore, the installer must perform sizing, depending on the number of companies, installation type, number of processes, and internal memory. On the Archive tab, specifying the archive mode is not mandatory. This parameter setting is left to the installer. On the DB Sizing tab, a Block Size of 4KB pages were determined to be best for Oracle. However, for queries with multiple full table scans, consider moving up the block size to 8KB. Database Storage dialog Open tablespaces and remove the TOOLS tablespace and USER tablespace. These are not required for ERP LN. Check Appendix "Oracle" of this manual for more specific Oracle database information. If all the required Oracle software is installed and configured, you can start the Staging Wizard. For more information, refer to the Overall installation Guide for Infor ERP LN Products (U9498 US). |