Oracle
To install the Oracle software, see the Oracle Installation Manuals. This section provides guidelines for a correct setup of Oracle for LN. For more Oracle database tuning advice, see Infor LN - Performance, Tracing and Tuning Guide for Oracle (B0078 US).
Parameters
This table shows a rough starting value of Oracle parameters which
must be changed while creating the instance. Consider the requirements based on
your system sizing for optimal performance.
| Parameter | Recommended value |
|---|---|
| sga_target (2-tier) | 25% of internal memory |
| sga_target (3-tier) | 40% of internal memory |
| Connection mode | Dedicated server |
| processes | 150 + number of users |
| sessions | Number of users * 1.1 |
| db_block_size | At least 16KB |
The definition of some LN tables requires a db_block_size of at least 16KB. This is currently the largest available block size on Oracle/Windows installations. On Oracle/UNIX 32KB is preferred. Ensure to set this parameter before creating the Oracle database. You cannot change this parameter afterwards.
Character set
For a Unicode installation the value of the character set (NLS_ CHARACTERSET) is not relevant for LN. Select AL16UTF16 as value of the national character set (NLS_NCHAR_CHARACTERSET).Data storage
This table shows a rough starting value for the size of the Oracle
tablespaces. Consider the requirements based on your system sizing for optimal
performance.
| Tablespace | Initial size |
|---|---|
| System | 5 GB |
| Undo | 10 GB |
| Temp | 10 GB |
| Redo | 6 files of 1 GB each |
| Data + Index | See sizing, minimal 20 GB |
Remote database (3-tier)
To install the database on another server:
- Install Oracle Net Services on the application server.
- Configure a listener using net Configuration Assistant (netca).
For more information, see the Oracle Net Services Administrator's Guide.