<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/install/windows/Pre_Windows_Oracle_Server" xml:lang="en">
   <Header>
      <Title>Oracle Server</Title>
      <Keyword type="header" order="d1e1084692">
         <Level1>Oracle</Level1>
      </Keyword>
   </Header>
   <AimSection>
      <Paragraph>This chapter describes how to install the Oracle software.
		Before you install the LN software, you must perform several tasks.</Paragraph>
   </AimSection>
   <GeneralSection>
      <SectionTitle>Requirements</SectionTitle>
      <Paragraph>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:</Paragraph>
      <List>
         <ListItem>A destination installation drive that contains the Windows file
		  system (NTFS). Note that this cannot be a drive on a network.</ListItem>
      </List>
      <GeneralSection>
         <SectionTitle>Overview of the installation process</SectionTitle>
         <Paragraph>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.</Paragraph>
         <Paragraph>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.</Paragraph>
      </GeneralSection>
      <GeneralSection>
         <SectionTitle>Solution</SectionTitle>
         <Paragraph>Check solution 166049 for Important Oracle 10g
		  Parameters</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
		  to select " <GUIRef href="" role="manual">Choose the appropriate Character set</GUIRef> ", while
		  creating the oracle instance.</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 the oracle database</SectionTitle>
         <Paragraph>Create a database with the Database Configuration Assistant.</Paragraph>
         <Paragraph>Start the Database Configuration Assistant: click Start -&gt;
		  Accessories, Configuration and Migration Tools -&gt; Database Configuration
		  Assistant.</Paragraph>
         <Paragraph>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.</Paragraph>
         <List>
            <ListTitle>Database Options dialog box</ListTitle>
            <ListItem>In case of a default LN installation, clear all the check boxes, including those in the Additional
			 Database Configurations area.</ListItem>
         </List>
         <List>
            <ListTitle>Database Connections dialog box</ListTitle>
            <ListItem>Click Dedicated Server Mode. You can change this later in the
			 Oracle configuration (adjust init&lt;SID&gt;.and restart Oracle).</ListItem>
         </List>
         <List>
            <ListTitle>Initialize Parameters dialog box</ListTitle>
            <ListItem>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.</ListItem>
            <ListItem>On the Archive tab, specifying the archive mode is not
			 mandatory. This parameter setting is left to the installer.</ListItem>
            <ListItem>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.</ListItem>
         </List>
         <List>
            <ListTitle>Database Storage dialog</ListTitle>
            <ListItem>Open tablespaces and remove the TOOLS tablespace and USER
			 tablespace. These are not required for LN.</ListItem>
         </List>
         <Paragraph>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 <DocRef>Overall Installation Guide for LN Products -
		  New installation (U9498 US)</DocRef>.</Paragraph>
      </GeneralSection>
   </GeneralSection>
</ManualTopic>