| # Oracle Server This chapter describes how to install the Oracle software. Before you install the ERP LN software, you must perform several tasks. Requirements This section assumes that you are familiar with Windows and the version of Oracle server you want to install. For best results, use the information contained in this section together with the Getting Started manuals for Oracle on Windows. Also use the following hardware and software requirements for Oracle server and Windows: A destination installation drive that contains the Windows file system (NTFS). Note that this cannot be a drive on a network. Overview of the installation process Oracle installations are version-dependant and system-dependant. The installation procedures specified in this section are examples. Check your Oracle documentation for the installation procedure for the Oracle version you are installing. A 2-Tier Architect Oracle installation process will be used as an example. Enter the appropriate values in the proper sequence, and locations. There can be differences between this description and the actual Oracle Installer, such as additional checks. For more details, refer to the Oracle Installation Guide, which you can find on the Oracle documentation medium. Solution Check solution 166049 for Important Oracle 10g Parameters 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 to select " Choose the appropriate Character set ", while creating the oracle instance. 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 the oracle database Create a database with the Database Configuration Assistant. Start the Database Configuration Assistant: click Start -> Accessories, Configuration and Migration Tools -> Database Configuration Assistant. During the process, several dialog boxes appear. This section provides notes you must be aware of while 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 those in the Additional Database Configurations area. Database Connections dialog box Click Dedicated Server Mode. You can change this later in the Oracle configuration (adjust init<SID>.and restart Oracle). 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, because Windows page size is also 4KB. 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. For more information on monitoring and tuning, review the “Oracle” Appendix. If all the required Oracle software is installed and configured, you are ready to start the Staging Wizard. For more information, refer to the Overall Installation Guide for ERP LN Products - New installation (U9498 US). |