Installation of Oracle9i Database

This guide describes how to install and configure Oracle9i Database release 2 (9.2.0) on Linux systems with the Install Navigator for Oracle. Read the release notes for the product on your platform before installing it. The release notes are available on the Oracle9i Database disc. The latest version of the release notes is also available on the OTN Web site:
http://otn.oracle.com/documentation/


INDEX

  1. Preparation
  2. Require patches of Oracle
  3. Check the Installation Requirements
  4. Set the environments
  5. Mount the Product Disc
  6. Start the Install Navigator for Oracle
  7. Select the Installation type
  8. Select the source media
  9. Check the Version
  10. Configure the Linux User
  11. Set the oracle user password and the home directory
  12. Set the environment of the oracle user
  13. Set the environment variables of Apache Software
  14. Configure the installation of Oracle
  15. Start the Oracle Universal Installer
  16. Specify Inventory directory and credentials
  17. Specify Installation Group Name
  18. Run orainstRoot.sh
  19. Specify File Locations
  20. Select a product to install
  21. Select the Installation Type
  22. Select Database Configuration
  23. Specify the Database Identification
  24. Specify Database File Location
  25. Select the Database Character Set
  26. Review the installation Summary
  27. Handing of the errors
  28. Run Configuration Assistant
  29. Run root.sh
  30. End of Installation

    1. Preparation
    2. Before starting installation, you should consider the following things:

      1. Prepare Installation CD-ROM

      2. Prepare Oracle Patches. See below seciton 2.

      3. Determine the Installation user name.
        The default name is "oracle", and the user is automatically created by the Install Navigator for Oracle.

      4. Determine the Installation group name.
        The default name is "oinstall", and the group is automatically created by the Install Navigator for Oracle.

      5. Determine the Administration group name.
        The default name is "dba", and the group is automatically created by the Install Navigator for Oracle.

      6. Determine the Oracle SID.
        The default name is "orcl".

      7. Determine the Oracle Base.
        The default directory is "/opt/app/oracle".

      8. Determine the Oracle Home.
        The default directory is "/opt/app/oracle/product/9.2.0".


    3. Require patches of Oracle
    4. There are two kinds of CD in Oracle9i Database Release 2 named as 9.2.0.1 and 9.2.0.4. Please obtain the patches stated below for your version of Oracle9i CD.

      • 9.2.0.1 CD
        • Patch#3119415
        • Patch#3016968 (optional)
        • PSR9.2.0.6
      • 9.2.0.4 CD
        • Patch#3016968 (optional)
        • PSR9.2.0.6

      Note: Asianux 2.0 supports only on and after R9.2.0.6.

      These patehces are provided by Oracle Corporation and downloadable from Oracle MetaLink. The information is available from Doc ID 252217.1 and 264178.1. Oracle MetaLink is accessible from the following URL:
      http://metalink.oracle.com/

      However, since Asianux provide the RPM named as oracle9i_support, which is an equivalent of the patch #3006854. You do not need to apply additional patch for 9.2.0.4 if you have installed this package.


    5. Check the Installation Requirements
    6. The system must meet the following minimum hardware requirements.

      CPU PentiumIII 233MHz
      Physical memory(RAM) 512MB
      Disk space For software files:2.5GB
      For database files:1.2GB (/tmp: 400MB)
      Swap space 1GB or twice the size of RAM
      Supported Oracle Version on and after R9.2.0.6

      Note:

      If there is less than 400 MB of disk space available in the /tmp directory, set the TEMP and TMPDIR environment variables to the oracle user environment. The Install Navigator for Oracle would unknowingly switch user from root to oracle, hence to set these environment variables for the root user's environment doesn't work at all this time.

      1. Create a directory that have more than 400MB free disk space.

        # mkdir /opt/tmp
        # chmod 1777 /opt/tmp

      2. Add the TEMP, TMPDIR environment variables to the oracle user's shell startup file(.bash_profile)

        export TEMP=/opt/tmp
        export TMPDIR=/opt/tmp


    7. Set the environments
    8. In order to install Oracle9i in Asianux, you need to configure this system as described below. In this seciton you will learn how to use Oracle9i with oracle9i_support package.

      oracle9i_support is equivalent functionality to the patch #3006854 . You do not need to apply additional patch for 9.2.0.4 if you have installed this package.

      1. oracle9i_support is not installed by default. You need to install manually from Asianux Install CD.
      2. # rpm -ivh /mnt/cdrom/Asianux/RPMS/oracle9i_support-2.0-3AX.i386.rpm  
        
      3. Change the version of gcc from 3.4.6 to 2.96. It can be done using chgcc.sh script provide by oracle9i_support.
      4. # chgcc.sh -v 296 
        
        Upon the completion, you need to revert the version of gcc back to 3.4.6. To do that please execute chgcc.sh script as following.
        # chgcc.sh -v 346
        
      5. The hostname command should return the fully qualified host name(FQDN) as follows. If it doesn't return FQDN, please modify the entry in /etc/sysconfig/network.
      6. # hostname
        sample.doamine.name
        
      7. Please proceed to the next step.

      NOTES
      If you are going to install Oracle without the support from oranavi, LD_ASSUME_KERNEL environment variable must be set for the oracle user.

      $ export LD_ASSUME_KERNEL=2.4.19

    9. Mount the Product Disc
    10. Log in as root user. If you are installing the software from disc, automatically mount discs when you insert them into the drive. When a disc isn't mounted automatically, right-click the Desktop and then click Mount or enter a command similar to the following:

      # mount /mnt/cdrom


    11. Start the Install Navigator for Oracle
    12. To run Install Navigator for Oracle as the root user, Enter a command similar to the following:

      # oranavi


    13. Select the Installation type
    14. Start Install Navigator for Oracle. Select the Operation type from following choices, then Click Next.


      Menu

      • Oracle DBMS Installation
        Install the Oracle Database.


      • Oracle AS Installation
        Install the Oracle Application Server


      • Setting Automatic Startup and Shutdown of Database instances
        Setup an automatic start up and shutdown Oracle instances during Linux system startup or shutdown.

    15. Select the source media
    16. Specify the installation media.

      Menu

      กก
      • CD-ROM
        Install from the installation CD-ROM.
        Insert the appropriate disc into the disc drive, and Click Next.


      • Harddisk
        Choose Harddisk, when you install from the hard drive, or install from the disc drive at a remote machine.

        In this case, you can install without the Installation CD-ROM at the installation target machine.
        Choose Harddisk, and specify the path in the response directory if you prefer, then Click Next.



    17. Check the Version
    18. Check the Product Version that you plan to install, then Click OK.

      Check the Version


    19. Configure the Linux User
    20. Specify the local Unix groups and user, then Click Next.

      Configure the Linux User

      • Installation group
        This is the Oracle Inventory group.
        The default name is "oinstall".


      • Administration group
        This is the OSDBA group.
        The default name is "dba".


      • Installation and Administration User
        This is the Oracle Software owner.
        The default name is "oracle".



    21. Set the oracle user password and the home directory
    22. Specify the oracle user password and user home directory, then Click Next.

      the oracle user information

      • Password
        Type in the user password.


      • Password(Retype)
        Verify password by retyping.


      • Home Directory
        Specify the user's home directory.
        The default directory is /home/username.

    23. Set the environment of the oracle user
    24. The ORACLE_BASE, ORACLE_HOME and ORACLE_SID environment variables, then Click Next.

      Set the environment variables

      • ORACLE_BASE
        The root of the Oracle directory tree.


      • ORACLE_HOME
        A subdirectory under ORACLE_BASE and a directory where the Oracle software is installed.


      • ORACLE_SID
        The database instance identifier.

    25. Set the environment variables of Apache Software
    26. If Add some environment variables of the Oracle Database to the Apache configured file, Click Yes. Otherwise Click No.

      Set variables of Apache


    27. Configure the installation of Oracle
    28. If Start the installation now, Click Yes. Otherwise Click No.


    29. Start the Oracle Universal Installer
    30. Start Oracle Universal Installer. then, Click Next.

      Welcome

    31. Specify Inventory directory and credentials
    32. Specify the full path of the inventory directory, and operating system group name which is suppose to be "oinstall". then, Click Next.

      Inventory Location

    33. Specify Installation Group Name
    34. Specify the Unix Group Name which will be the Oracle Software owner group. then, Click Next.

      UNIX Group Name

    35. Run orainstRoot.sh
    36. Only during the first installation of Oracle products on a system, run /tmp/orainstRoot.sh in a separate terminal window as the root user:

      # /tmp/orainstRoot.sh

      After running the script, Click Continue.

      /tmp/orainstRoot.sh

    37. Specify File Locations
    38. In the Destination section, specify the Path value for the Oracle home directory, then Click Next.

      File Locations

    39. Select a product to install
    40. Select the installation product, then Click Next. At this time select "Oracle9i Database 9.2.0.1.0".

      Installation Products

    41. Select the installation Type
    42. Select the installation type, then Click Next. At this time select "Enterprise Edition".

      Installation Types

    43. Select Database Configuration
    44. Choose either to create a database with this installation or install the software only. At this time select "General Purpose" that has a starter database. Accept the default values, then click Next.

      Database Configuration

    45. Specify Database Identification
    46. Specify the Global Database Name which is also used for the SID. The SID should be equal to the SID environment variable.

      Database Identification

    47. Specify Database File Location
    48. Specify the directory for database files, then Click Next.

      File System

    49. Select the Database Character Set
    50. Select the database character set, then click Next. At this time select "default character set".

      Auto Backup

    51. Review the installation Summary
    52. Review the information displayed, then click Install.

      Summary

    53. Handing of the errors
    54. Using 9.2.0.1 CD, during the installation you would have two error messages.

      1. Install the 3119415 patch

        Popping up a error as following, install the patch for your system as the oracle user.

        install error

        Enter a command similar to the following:

        # su - oracle
        $ unzip p3119415_9203_LINUX.zip
        $ cd 3119415
        $ sh patch.sh

      2. Ignore a error

        Popping up a error as following, just ignore about it. This error is resolved by PSR9204.

        install error


    55. Run root.sh
    56. After the configuration assistants, this window appears. Then, run the $ORACLE_HOME/root.sh in a separate terminal window as the root user:

      # /opt/oracle/product/9.2.0/root.sh

      root.sh

    57. Run Configuration Assistant
    58. The Configuration Assistants screen displays status information for some configuration assistants that configure the software and create a database. After the Database Configuration Assistant finishes, click OK to continue.

      Configuration Tools

    59. End of Installation
    60. This is the End of Installation. The configuration assistants configure several Web-based applications. This screen displays the URLs configured for these applications. Make a note of the URLs used.


    logo
    Copyright(C) 2000-2007 MIRACLE LINUX CORPORATION