<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/install/unix/Pre_Unix_Oracle_Server" xml:lang="en">
   <Header>
      <Title>Oracle Server</Title>
      <Keyword type="header" order="d1e1083470">
         <Level1>Oracle</Level1>
      </Keyword>
   </Header>
   <AimSection>
      <Paragraph>This chapter describes how to setup the Oracle software. Before
		you install the LN software, you must perform several tasks described in the following
		sections.</Paragraph>
   </AimSection>
   <GeneralSection>
      <SectionTitle>Overview of the installation process</SectionTitle>
      <Paragraph>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.</Paragraph>
      <Paragraph>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.</Paragraph>
      <GeneralSection>
         <SectionTitle>Short overview of the installation steps</SectionTitle>
         <Paragraph>To install the Oracle Software, complete the following
		  procedures:</Paragraph>
         <ProcedureList>
            <ListItem>Create the Oracle installation environment.</ListItem>
            <ListItem>Run the Oracle installer.</ListItem>
            <ListItem>Create an Oracle instance using Database Configuration
			 Assistant, known as dbca.</ListItem>
            <ListItem>If the installation was successful, click <GUIRef href="" role="manual">Exit</GUIRef> to end the installation.</ListItem>
         </ProcedureList>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>Requirements</SectionTitle>
         <Paragraph>Install the latest version of the Oracle software. You can use
		  several hardware configurations to install LN with Oracle. For
		  more-detailed information, refer to the Enterprise Server Technical Notes
		  (U8891 US) or contact Infor for additional sizing information</Paragraph>
         <Caution>
            <SectionTitle>Caution!</SectionTitle>
            <Paragraph>In case of a multibyte installation, a double amount of
			 disk space is required.</Paragraph>
         </Caution>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>Solution</SectionTitle>
         <Paragraph>Check solution 166049 for Important Oracle 10g
		  Parameters</Paragraph>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>To tune the kernel for Oracle</SectionTitle>
         <Paragraph>You have already tuned the kernel of the UNIX machine to
		  accommodate the projected number of users for LN. Now tune the kernel
		  for Oracle. Check the pre installation tasks in the Oracle documentation.</Paragraph>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>Character set for the Oracle Instance</SectionTitle>
         <Paragraph>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 " <GUIRef href="" role="manual">Choose the appropriate Character set</GUIRef> ".</Paragraph>
         <Paragraph>The following table shows the available character
		  sets:</Paragraph>
         <TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated">
            <TBODY noTR="5">
               <TR no="1" isLast="false">
                  <TD width="271" rowspan="1" colspan="1">
                     <GUIRef href="" role="manual">Language Pack</GUIRef>
                  </TD>
                  <TD width="306" rowspan="1" colspan="1">
                     <GUIRef href="" role="manual">Oracle instance character set</GUIRef>
                  </TD>
               </TR>
               <TR no="2" isLast="false">
                  <TD width="271" rowspan="1" colspan="1">Japanese</TD>
                  <TD width="306" rowspan="1" colspan="1">ja16sjis</TD>
               </TR>
               <TR no="3" isLast="false">
                  <TD width="271" rowspan="1" colspan="1">Simplified Chinese</TD>
                  <TD width="306" rowspan="1" colspan="1">zhs16cgb231280</TD>
               </TR>
               <TR no="4" isLast="false">
                  <TD width="271" rowspan="1" colspan="1">Traditional
				  Chinese</TD>
                  <TD width="306" rowspan="1" colspan="1">zht32euc</TD>
               </TR>
               <TR no="5" isLast="true">
                  <TD width="271" rowspan="1" colspan="1">Korean</TD>
                  <TD width="306" rowspan="1" colspan="1">ko16ksc5601</TD>
               </TR>
            </TBODY>
         </TABLE>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>To install the Oracle software</SectionTitle>
         <Paragraph>To install the Oracle software, you must use the Oracle
		  Installation Manuals.</Paragraph>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>Create an Oracle instance for a default LN installation</SectionTitle>
         <Paragraph>With user oracle, start the Database Configuration Assistant.</Paragraph>
         <CodeBlock space-and-orientation="indented-estimated">$cd $ORACLEHOME/bin
$./dbca</CodeBlock>
         <Paragraph>The Welcome dialog box will appear.</Paragraph>
         <Paragraph>During the process, several dialog boxes appear. This section
		  provides notes when you create an instance with the Database Configuration
		  Assistant.</Paragraph>
         <List>
            <ListTitle>Database Options dialog box</ListTitle>
            <ListItem>In case of a default LN installation, clear
			 all the check boxes, including the check boxes in the <GUIRef href="" role="manual">Additional Database Configurations</GUIRef> area.</ListItem>
         </List>
         <List>
            <ListTitle>Database Connections dialog box</ListTitle>
            <ListItem>Click <GUIRef href="" role="manual">Dedicated Server Mode</GUIRef>. You can change
			 this later in the Oracle configuration.</ListItem>
         </List>
         <List>
            <ListTitle>Initialize Parameters dialog box</ListTitle>
            <ListItem>On the <GUIRef href="" role="manual">Memory tab</GUIRef>, select <GUIRef href="" role="manual">Custom</GUIRef> 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.</ListItem>
            <ListItem>On the <GUIRef href="" role="manual">Archive tab</GUIRef>, specifying the archive
			 mode is not mandatory. This parameter setting is left to the
			 installer.</ListItem>
            <ListItem>On the <GUIRef href="" role="manual">DB Sizing tab</GUIRef>, a <GUIRef href="" role="manual">Block Size</GUIRef> 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.</ListItem>
         </List>
         <List>
            <ListTitle>Database Storage dialog</ListTitle>
            <ListItem>Open tablespaces and remove the <GUIRef href="" role="manual">TOOLS</GUIRef> tablespace and <GUIRef href="" role="manual">USER</GUIRef> tablespace. These are not required for LN.</ListItem>
         </List>
         <Paragraph>Check Appendix "Oracle" of this manual for more specific
		  Oracle database information.</Paragraph>
         <Paragraph>If all the required Oracle software is installed and
		  configured, you can start the Staging Wizard.</Paragraph>
         <Paragraph>For more information, refer to the Overall installation Guide
		  for Infor LN Products
		  (U9498 US).</Paragraph>
      </GeneralSection>
   </GeneralSection>
</ManualTopic>