Oracle 10g 10.0.1 on FC3 default intallation.
============================================
Summary: 
Install oracle software under /opt/oracle/ with data file directory under /u02/oracleData/. 
Please refer to http://www.puschitz.com/InstallingOracle10g.shtml for details. 

1. Change kernel parameters. Add these lines to /etc/sysctl.conf. Login as root:

   ==================================

   kernel.shmmax=2147483648
   kernel.sem=250 32000 100 128
   fs.file-max=65536
   net.ipv4.ip_local_port_range=1024 65000
   ==================================
   These parameters will take effect next time when system reboot.
   To activate these paramters, run this command.
   $sysctl -p

2. Create oracle account. Login as root:
   a. groupadd dba
   b. groupadd oinstall
   c. useradd oracle -g oinstall -G dba oracle
   d. passwd oracle 

3. Setup oracle user environment.Login as oracle:
   a. Add these two lines to .bash_profile
      ====================================
       export ORACLE_BASE=/opt/oracle
       export ORACLE_SID=oradb
       export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/Db_1
       PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

       #These two lines should be commented out after oracle installation.
       unset ORACLE_HOME
       unset TNS_ADMIN
      =====================================
 
4. Create oracle direcotries:
   a. mkdir -p /opt/oracle
   b. chown -R oracle.oinstall /opt/oracle
   c. mkdir -p /u02/oracleData 
   d. chown -R oracle.oinstall /u02/oracleData
   e. Edit /etc/redhat-release file to contains this line
      ===============================================
      Red Hat Enterprise Linux AS release 3 (Taroon)
      ===============================================
      This is necessary because 10g does not install on FC3 by default.

5. Install Oracle 10g. Login as oracle: I save my oracle downloaded file under
   /home/download/Oracle/10g/ship.db.lnx32.cpio.gz
   a. gunzip ship.db.lnx32.cpio.gz
   b. cpio -idmv < ship.db.lnx32.cpio
   c. cd Disk1
   e. ./runInstaller

6. Check off Create Starter Database.
   Select Basic Installation.
        Oracle Home Location = $ORACLE_HOME value.
        Installation Type = Enterprise Edition
        Unix DBA Group = dba
   Click Next
        Let inventory directory as default to /opt/oracele/oraInventory.
        OS group name = oinstall
   Click Next
        Run orainsRoot.sh as root.
   Click Continue
       You may see Checking for gcc-2.96 Failed. Make sure you have gcc greater
than 2.96 on your FC3. You should see gcc-3.4.2-6.fc3 if you run 
       rpm -qa |grep gcc.
        Check the check box to make this check as User Verified.
   Click Next
        Check Do not create a starter database.
   Click Next
   Click Install
         I don't see any problem in this process.
         Run root.sh file when prompted.
               Use /usr/local/bin as default value.
               When done, click OK on pop up window.
   Click Next and then Click Cancel to Exit.

7. When completed you comment out unset statement in .bash_profile for oracle.

8. END.



To start oracle using init script.
===================================
Example used here comes from http://staff.in2.hr/denis/oracle/10g1install_fedora3_en.html.

1. Copy this script and save it to a file in  /etc/rc.d/init.d/ora10.
=======================================================================
#!/bin/bash
#
# chkconfig: 35 95 1
# description: init script to start/stop oracle database 10g, TNS listener, EMS
#
# 
# match these values to your environment:
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10g
export ORACLE_TERM=xterm
export PATH=/home/oracle/bin:$ORACLE_HOME/bin:$PATH
export NLS_LANG='croatian_croatia.ee8iso8859p2'
export ORACLE_SID=orcl
export DISPLAY=localhost:0
export ORACLE_USER=oracle

# see how we are called:
case $1 in
    start)
    su - "$ORACLE_USER"<<EOO
    lsnrctl start
    sqlplus /nolog<<EOS
    connect / as sysdba
    startup
EOS
    emctl start dbconsole
EOO
    ;;

    stop)
    su - "$ORACLE_USER"<<EOO
    lsnrctl stop
    sqlplus /nolog<<EOS
    connect / as sysdba
    shutdown immediate
EOS
    emctl stop dbconsole
EOO
    ;;

    *)
    echo "Usage: $0 {start|stop}"
    ;;
esac
============================================================

2. Change permission of this file
   $chown root.root /etc/rc.d/init.d/ora10
   $chmod 755 /etc/rc.d/init.d/ora10
   
3. Install this script to be started by xinetd when startup.
   $chkconfig ora10 reset

4. END.