Installation of Oracle10g on LINUX RRS feed

  • General discussion

  • Table of Contents

    1. Pre-installation Tasks for the ORACLE 10g Database.
    2. Installing the ORACLE 10g Database.
    3. Post-installation tasks for the ORACLE 10g Database.
    4. Testing the installation.

    Pre-installation Tasks for the ORACLE 10g Database.

    Before starting the oracle 10g installation ,several parameters must be checked. To
    perform these checks login as the root user or switch user to root using the command  su – root.

    Checking Memory and Swap space.

    For successful installation of Oracle 10g, the system is required to have atleast 512MB of RAM
    and 1 GB of Swap space.
    You can verify this using :--

    <System Prompt> grep MemTotal /proc/meminfo
    <System Prompt> grep SwapTotal /proc/meminfo

    Checking /tmp space.

    The Oracle Universal Installer requires 400 MB of free space in the /tmp directory. The
    command to check this is as follows:--

    <System Prompt> df /tmp

    Checking The Existence of following Softwares/RPM Packages.
    The following packages or later versions must be installed :---

    · make-3.79.1
    · gcc-3.2.3-34
    · glibc-2.3.2-95.20
    · glibc-devel-2.3.2-95.20
    · compat-db-4.0.14-5
    · compat-gcc-7.3-2.96.128
    · compat-gcc-c++-7.3-2.96.128
    · compat-libstdc++-7.3-2.96.128
    · compat-libstdc++-devel-7.3-2.96.128
    · gnome-libs-
    · openmotif21-2.1.30-8
    · setarch-1.3-1
    · libaio-0.3.96-3
    · libaio-devel-0.3.96-3

    Check the existence of the above packages by issuing the following command:--

    <System Prompt> rpm -q make gcc glibc glibc-devel compat-db compat-gcc
    compat-gcc-c++ compat-libstdc++ gnome-libs openmotif
    setarch libaio libaio-devel

    If any packages are not installed first install them using the command :--
    <System Prompt> rpm -ivh <Package name>

    Oracle Database 10g while being installed detects the Linux Distribution via a file called redhatrelease.

    Oracle Database 10g can be installed only on Redhat Enterprise Linux Advance Server 2.1 and 3.

    TO install Oracle Database 10g on Fedora Core

    A file called /etc/redhat-release needs to be edited to make Oracle Database 10g believe that it
    is running on an appropriate Linux Version. (Since it does not support Fedora Core.)

    To accomplish this type in the following command at the prompt :--

    <System Prompt> cp /etc/redhat-release /etc/redhat-release.backup

    Now type in the following command to change the current distribution's identity.
    <System Prompt> cat >> /etc/redhat-release << EOF
    >Red Hat Enterprise Linux AS release 3 (Taroon)

    Changing Kernel Parameters--

    The file /etc/sysctl.conf contains all the basic system parameters and is read during the boot
    Open this file in any text editor and carefully type in the following lines:--

    kernel.shmmax = 2147483648
    kernel.sem = 250 32000 100 128
    fs.file-max = 65536
    net.ipv4.ip_local_port_range = 1024 65000

    These modifications will cause the system to change the kernel parameters after each
    boot so as to make the system compatible for running Oracle 10g.

    Creating Oracle User accounts.

    <System Prompt> su -root
    <System Prompt> groupadd dba
    <System Prompt> groupadd oinstall
    <System Prompt> useradd -c “Oracle Software Owner” -g oinstall -G dba oracle
    <System Prompt> passwd oracle

    Creating Oracle Directories

    <System Prompt> mkdir -p /u01/app/oracle
    <System Prompt> chown -R oracle.oinstall /u01

    Setting the Oracle Environment.

    To set the oracle environment variables automatically each time the oracle user logs in issue the  following commands:--

    <System Prompt> su oracle
    <System Prompt> cat >> ~oracle/.bashrc << EOF
    >export ORACLE_BASE=/u01/app/oracle
    >export ORACLE_SID=SCT

    The next step is to unset the ORACLE_HOME and TNS_ADMIN Variables
    Do this as follows :--

    <System Prompt> su oracle
    <oracle@localhost.localdomain> unset ORACLE_HOME
    <oracle@localhost.localdomain> unset TNS_ADMIN

    Once the variable are unset change the user back to the root by typing in the following
    command at the prompt :--

    <oracle@localhost.localdomain> exit

    Next the xhost needs to be executed .This is done to disable the access control mechanism of
    the system.

    <System Prompt> xhost +

    Installing The Oracle Database 10g

    In order to begin the installation issue the following commands in case of Fedora :--

    <System Prompt> su oracle
    <oracle@localhost.localdomain> /media/cdrecorder/runInstaller

    After issuing these commands the Oracle Installation will begin.
    Thereafter go on following the instructions int installations.

    During the installation when the dialog box telling the completion of
    Database Configuration Assistant appears click on that the Password Management
    button and unock the following accounts :--
    · SCOTT
    · PM
    · IX
    · SH
    · OE
    · HR
    Then go in following the instructions and complete the installation of Database.

    Post installation tasks for the Oracle Database 10g

    Type in the following command :--

    <oracle@localhost.localdomain> kate /home/oracle/.bashrc

    Append the following lines

    export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/Db_1
    export PATH=$PATH:$ORACLE_HOME/bin

    Save and exit the file.

    Testing the Installation.

    Close any open Shell Windows.
    Open a new shell window.
    After logging in as oracle , type in the following commands:--

    <oracle@localhost.localdomain> sqlplus

    Enter the user name as scott and issue the query:--

    select * from dept;

    .................................to test the Installation.

    If some table is displayed as output then CONGRATS !! Your installation was successful .


    Sunday, February 11, 2007 6:13 PM