Oracle Install

Oracle & PHP Installfest guide - Oracle 10gR2 on RHEL4 - OTN Night 2005
-----------------------------------------------------------------------
Installing Oracle 10g (10.2.0.1) on RHEL4

*** This guide is for test purposes only - not production ***

Boot from RHEL4 disc1
press enter for graphical install
 ** Need at least 512MB RAM / 2.5GB Space **
+ Automaticaly or Manually partition your hard drive with Disk Druid
 /tmp = 512MB ext3 fixed size
 /boot = 128MB ext3 fixed size
 swap = 1024MB fixed size
 / = fill to maximum allowable size

+ Accept defaults for GRUB boot loader, and configure networking.

+ Most Linux distros and RHEL4 ship with default security preferences locked down.
For testing purposes I typically turn off the firewall and disable SE Linux.

+ Set language preferences and root password

+ Select 'Customize software to be installed'
 - make sure the packages essential for installing Oracle are selected.
  Desktop : X Window System; Gnome or KDE
  Editors : at least one editor - vi etc.
  Graphical Internet : a web browser - firefox
  Development : Development Tools, and Compat Legacy Languages

For post-install configuration login as root
--------------------------------------------
+ create groups
 /usr/sbin/groupadd oinstall
 /usr/sbin/groupadd dba
 /usr/sbin/groupadd oper

+ create OS user oracle with group permissions and home /opt/oracle
 /usr/sbin/useradd -g oinstall -G dba,oper -d /opt/oracle oracle

+ set user oracle's password
 /usr/bin/passwd oracle

+ Append user oracle's bash profile with PATH and ORACLE:BASE,HOME and SID information
 vi /opt/oracle/.bash_profile

 umask 022
 PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
 LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib

 ORACLE_BASE=/opt/oracle
 ORACLE_HOME=$ORACLE_BASE/product/10gR2
 ORACLE_SID=orcl
 PATH=$ORACLE_HOME/bin:$PATH

 export PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME ORACLE_SID

+ Create the directory for the software installation and assign ownership to oracle:oinstall
 chown -R oracle:oinstall /opt
 chmod -R 775 /opt

+ Make sure the correct kernel parmeters are appended to sysctl.conf
 vi /etc/sysctl.conf (these can be easily copied from the Quick Installation Guide
                              for Linux x86 doc on the Oracle10g CD)
 kernel.shmall = 2097152
 kernel.shmmax = 2147483648
 kernel.shmmni = 4096
 kernel.sem = 250 32000 100 128
        net.core.rmem_default = 262144
 net.core.rmem_max = 262144
 net.core.wmem_default = 262144
 net.core.wmem_max = 262144
 fs.file-max = 65536
 net.ipv4.ip_local_port_range = 1024 65000

+ set the kernel parameters or reboot
 /sbin/sysctl -p

Login in to xwindows session as user oracle
-------------------------------------------
+ Mount the Oracle10g CD and run the installer
 mount /media/cdrom
 (cd $HOME && /media/cdrom/runInstaller)
 - follow the installer instructions 
 - use password mgmt to unlock DBuser scott & set password 'tiger'
+ open http://localhost.localdomain:1158/em in a browser or
 As root # vi /etc/oratab  change :N to :Y 
           # cp /etc/oratab /var/opt/oracle/oratab
+ This enables the oracle user to dbshut, dbstart and lsnrctl start 

Ref:

http://www.oracle-base.com/articles/11g/OracleDB11gR1InstallationOnEnterpriseLinux4and5.php 

http://www.oracle.com/technetwork/articles/smiley-rac10g-install-082032.html

http://www.oracle.com/technetwork/articles/smiley-10gdb-install-092939.html 

http://www.akadia.com/services/ora_linux_install_10g.html

http://www.oracle-base.com/articles/10g/OracleDB10gR2InstallationOnRHEL5.php

======

RAC

http://www.oracle-base.com/articles/10g/OracleDB10gR2RACInstallationOnCentos4UsingVMware.php

http://decipherinfosys.wordpress.com/2007/01/24/estimating-projecting-the-size-of-a-table-in-oracle/ 

http://anuj-singh.blogspot.com/2008/01/oracle-11g-installation-on-suse-103.html