Oracle10g R2 Database on SLES10 for i386 Step-by-Step 1

From MicroFocusInternationalWiki
Jump to: navigation, search

This wiki page is a step by step procedure for installing Oracle10g R2 on SLES 10 for i386. This procedure is to be intended to serve as a quick path to a SLES10 system with Oracle10g R2 installed. Since this is a step by step procedure, some of the higher level considerations will not be covered. This procedure assumes the following goals:

  • ASM will not be used.
  • RAC will not be used.
  • The Oracle software will be installed to a local reiserFS filesystem.
  • A default database will be created as part of the installation process.
  • The database datafiles will be located on a local resierFS filesystem.
  • The system has less than 4GB or physical memory

The last assumption is important because on i386 systems with large amounts of memory, installing a typical database during the installation process may fail if Oracle tries to allocate too much memory for its data structures. Adjust the procedure as needed for the actual environment.

Before beginning

Before beginning the installation it is important to verify that the system to be used has the following minimum requirements:

  • At least 1 GB of memory
  • Swap space equal to the amount of physical memory or 2GB (whichever is more)
  • 400MB of space in the /tmp directory
  • 3.5GB of space in the Oracle home directory (full install)
  • 750MB of space for the database datafiles

In addition to the minimum hardware requirements, it is recommended that at least one network interface used to connect to the system have a static IP address.

OS Installation

The installation of SLES 10 can be done any number of ways so long as the following requirements are met:

  • The partitioning scheme allows for 2GB of swap or swap equal to the amount of memory in the system.
  • All of the required packages are installed (Please Refer Oracle Install Manual for complete list):
    • binutils
    • gcc
    • gcc-c++
    • glibc
    • gnome-libs
    • libstdc++
    • libstdc++-devel
    • libaio
    • libaio-devel
    • make
    • pdksh
    • sysstat
    • openmotif

This procedure assumes that the orarun package is installed in addition to the packages listed above. This procedure assumes that installation will be done manually using the CD or DVD media.

Software Packages and Basic Installation Options

Basic Installation Options

Figure - Select the language.
To begin the process boot the target machine with the first CD or DVD and select Installation from the boot menu. After the installation program loads the Select Language screen will appear. Choose the appropriate language and click Next (this guide assumes English US).

Figure - Accept the license agreement.
Select the Yes, I Agree to the License Agreement radio button and then click Next.

Figure - Choose to perform a new installation.
The Installation Mode screen will appear. Leave the default choice of New Installation and click Next.

Figure - Set the clock and timezone as appropriate for your environment.
The Clock and Timezone screen will appear. Select the appopriate timezone, adjust the date and time if necessary, and click Next.

Figure - Sample partitioning arrangement.
The Installation Settings screen will appear. Verify that the partitioning will meet the requires listed above. If it does not select the Partitioning hyperlink and adjust the partitioning scheme. This example systems has 1.5GB of physical memory so a swap partition of 2GB is allocated. The rest of the first disk is allocated for /. This simple partitioning scheme is sufficient for a demo installation of Oracle, but more complex scheme will be needed for production systems.

The default package selection for SLES10 is not sufficient for an Oracle installation so additional packages will need to be selected. Click on the Software hyperlink.

Choosing Required software Packages

Figure - Select the C/C++ Compiler and Tools and Oracle Server Base patterns
The Software Selection and System Tasks screen will appear. Select the C/C++ Compiler and Tools and Oracle Server Base patterns. Click on Details.

Figure - Select the sysstat package.
Select Search from the Filter drop down list.

Figure - Select the sysstat package.
Type sysstat in the Search text field and click Search. Select the sysstat package from the list on the right.

Figure - Select the openmotif21-libs package.
Type openmotif in the Search text field and click Search. Select the openmotif21-libs package from the list on the right. Click on Accept.

Figure - Accept the additional packages.
A Changed Packages dialog will appear warning you that additional packages will be installed. Click Continue.

Beginning the Installation

Figure - Accept the installation paramemters.
The Installation Settings screen will reappear. At this point the installation program is ready to being installing the system. Review the selections and then click Accept.

Figure - Verify that you want to install.
A Confirm Dialog screen will appear warning that the system will now be installed. Click Install.

Figure - Installation in progress.
The installation will now occur. Reboot the system and switch the CDs as necessary.

System configuration

Hostname and Root Password

Figure - Set a fully qualified hostname.
After the packages have finished installing, the Hostname and Domain Name screen will appear. It is recommended to give the system a fully qualified hostname and not allow DHCP to set the hostname of the system. Once the hostname and domain name have been entered click Next.

Figure - Set the root password.
Enter the root users password and click Next.

Network Configuration

Figure - Disable the firewall and edit the network interface configuration.
The Network Configuration screen, click the enabled hyperlink to disable the firewall and then click on the Network Interfaces hyperlink.

Figure - Select a network interface to edit.
The Network Card Configuration Overview screen will appear. Select a network card from the list (the demo system only has only) and then click on the edit button.

Figure - Assign a static address to the choosen interface.
The Network Interface Setup screen will appear. Select the Static Address Setup radio button and enter an IP Address and Subnet Mask as appropriate for the networking environment.

Figure - Review the network card settings.
The Network Card Configuration Overview screen will re-appear. Review the network settings and if necessary edit more interfaces. Then click Next.

Figure - Review the network settings.
The Network Configuration screen will re-appear. Review the settings, changing any as necessary. Then click Next.

Figure - Test the internet connection and register with the Customer Center or skip the test.
The Test Internet Connection screen will appear. If desiredl, click Next to test the systems internet connection. After testing the internet connection, the Novell Customer Center Configuration will appear and allow the system to be registered with Novell. Following the instructions as desired, this guide will not cover the Nover Customer Center Configuration.

If the system is not connected to the internet or the Novell Customer Center Configuration should be skipped, select the No, Skip this Test radio button and click Next.

User Configuration

Figure - Accept the default settings for OpenLDAP and CA management.
After the Novell Customer Center Configuration is complete or the internet test is skipped, the Installation Settings screen will appear. Accept the defaults and click Next.

Figure - Accept the default authentication method.
The User Authentication Method screen will appear. Accept the default setting of Local (/etc/passwd) and click Next.

Figure - Select the User Management button.
The New Local User screen will appear. If desired, add a local user by filling in all of the required fields. Click on User Management.

Figure - Select the system users filter.
The User and Group Administration screen will appear. Click the Set Filter drop down box and select System Users from the list.

Figure - Select the oracle user.
Select the oracle user from the list of system users and click Edit.

Figure - Enter a password, enable login, and select the details tab.
The Existing System User screen will appear. Enter a password for the oracle user in the Password and Confirm password fields then click on the Details tab.

Figure - Choose the shell for the oracle user.
On the Details tab, select the Login Shell drop down box and choose the desired shell for the Oracle user. The recommended choice is the /bin/bash shell. Then click Accept. The User and Group Administration screen will reappear. Click on Next.

Completing Installation

Figure - SuSeconfig will run to write configuration to disk.
The Writing the system configuration screen will appear and the system configuration will be written to disk.

Figure - Review the SLES10 release notes.
The Release Notes screen will appear. Read the release notes as desired, and then click on Next.

Figure - Review the hardware configuration.
The Hardware Configuration screen will appear. Review the hardware configuration, making changes as needed, and then click on Next.

Figure - Clone the system if desired and complete the installation.
The Installation Complete screen will appear. If you wish to clone the system configuration for future deployments leave the Clone This System for Autoyast check box checked, otherwise uncheck it. Click on Finish.

At this point the OS installation is complete.

Pre-Oracle configuration steps

Note: Modifying /etc/SuSE-release is not recommended by Novell/SUSE. Please see Section #5 of for better options.

Editing the /etc/SuSE-release file

Once the installation has complete, log into an X windows session as root. Open a terminal and using the preferred text editor edit the /etc/SuSE-release file. For example, using vi:

  # vi /etc/SuSE-release

The original contents of the file should be:

   SUSE Linux Enterprise Server 10 (i586)
   VERSION = 10

Replace the 10s with 9. The edited content should be:

   SUSE Linux Enterprise Server 9 (i586)
   VERSION = 9

Save the file. 'Bold text'Note: This is only a temporary change, and may prevent certain YaST tools from operating properly. After the Oracle installation is complete this file should be reverted to it's original state.

Editing the /etc/host's file

Now edit the /etc/hosts file. Comment out or remove the line that maps the IP address to the systems fully qualified hostname. On the example system:

   ff00::0         ipv6-mcastprefix
   ff02::1         ipv6-allnodes
   ff02::2         ipv6-allrouters
   ff02::3         ipv6-allhosts demo demo

Should become:

   ff00::0         ipv6-mcastprefix
   ff02::1         ipv6-allnodes
   ff02::2         ipv6-allrouters
   ff02::3         ipv6-allhosts
   # demo demo

Save the file.

Set the right kernel parameters

Run '/etc/init.d/oracle start' or 'rcoracle start'.

This does not do anything else upon you edit /etc/sysconfig/oracle. Please have a look at the orarun readme (/usr/share/doc/packages/orarun).

Log out of the root session.

Oracle installation

Download and extract the Oracle software

Log into a X windows session as the oracle user.

Download the Oracle Database 10g Release 2 ( Enterprise/Standard Edition for Linux x86 zip file (you will need to agree to the license agreement and have a valid OTN logon) and move it to the system if necessary. Create a directory to stage the Oracle software.

   > mkdir -p /opt/oracle/stage

Copy the zip file to the staging directory.

   > mv /opt/oracle/stage

Change to the stageing directory and unzip the file.

   > cd /opt/oracle/stage
   > unzip

Install Oracle

Change to the database directory under the directory where you extracted the Oracle software.

   > cd database

Invoke the Oracle Universal Installer (OUI).

   > ./runInstaller
Figure 4.2.1 - Enter database password.
The Select Installation Type screen will appear. Enter a password for the database users into the Database Password field and confirm the password in the Confirm Password field. Then click on the Next button.

Figure 4.2.2 - Select location of Oracle inventory.
At the Specify Inventory Directory and Credentials screen accept the defaults of /opt/oracle/oraInventory and oinstall and click Next.

Figure 4.2.3 - Pre-requisite checks.
Next the OUI will perform some checks on the environment and display the results to the Product-Specific Prerequisite Checkes screen. Verify and retry any failures before proceding. Once all the checks pass, click Next.

Figure 4.2.4 - Installation summary.
The Summary screen will appear. Click the Install button to begin the installation.

Figure 4.2.5 - Install in progress.
The Oracle software will now be installed.

Figure 4.2.6 - Configuration assistants.
After the installation has compelted, the OUI will run some configuration assistants.

Figure 4.2.7 - Database creation in progress.
The DataBase Creation Assistant DBCA will run last, and create a sample database.

Figure 4.2.8 - Database creation complete dialog.
After the DBCA has finished creating the database a dialog will appear with information about the created database. Click OK.

Figure 4.2.9 - Dialog prompting for scripts to be run.
After iSQL*Plus configuration assistant has run a dialog will appear asking you to run two scripts as the root user.

Open a separate console and switch to the root user

   > su -

Run the /opt/oracle/oraInventory/ script.

   # /opt/oracle/oraInventory/
   Changing permissions of /opt/oracle/oraInventory to 770.
   Changing groupname of /opt/oracle/oraInventory to oinstall.
   The execution of the script is complete

Run the /opt/oracle/10gr2/ script. When prompted accept the default location for the local bin directory.

   # /opt/oracle/10gr2/
   Running Oracle10 script...
   The following environment variables are set as:
       ORACLE_OWNER= oracle
       ORACLE_HOME=  /opt/oracle/10gr2
   Enter the full pathname of the local bin directory: [/usr/local/bin]:
      Copying dbhome to /usr/local/bin ...
      Copying oraenv to /usr/local/bin ...
      Copying coraenv to /usr/local/bin ...
   Creating /etc/oratab file...
   Entries will be added to the /etc/oratab file as needed by
   Database Configuration Assistant when a database is created
   Finished running generic part of script.
   Now product-specific root actions will be performed.

Figure 4.2.10 - Dialog prompting for scripts to be run.
After both scripts have been run successfully return to the OUI and click the OK button.

Figure 4.2.11 - Exit the OUI.
The End of Installation Screen will appear. Click the Exit button and then confirm that you really want to exit.

At this point the installation is complete.

Post installation cleanup

After the installation is complete, the changes made to the /etc/SuSE-release file should be undone. The altered file:

   SUSE Linux Enterprise Server 9 (i586)
   VERSION = 9

Should be reverted to:

   SUSE Linux Enterprise Server 10 (i586)
   VERSION = 10