The Blog of Nenad

Requirements
------------
The system must meet the following minimum hardware requirements:
* At least 1024 MB of physical RAM
* The following table shows the relationship between the available RAM and the required swap space.
Available RAM Swap Space Required
Between 1024 MB and 2048 MB 1.5 times the size of RAM
Between 2049 MB and 8192 MB Equal to the size of RAM
More than 8192 MB 0.75 times the size of RAM
* 400 MB of disk space in the /tmp directory
* Between 1.5 GB and 3.5 GB of disk space for the Oracle software, depending on the installation type
* 1.2 GB of disk space for a preconfigured database that uses file system storage (optional)


Pre-Install
-----------
NOTE: Tasks to perform as root user
- Check Hardware Requirements:
1. To determine the physical RAM size, enter the following command:
# grep MemTotal /proc/meminfo
2. To determine the size of the configured swap space, enter the following command:
# grep SwapTotal /proc/meminfo
3. To determine the amount of free disk space available in the /tmp directory, enter the following command:
# df -k /tmp
4. To determine the amount of free disk space available on the system, enter the following command:
# df -H
5. To determine whether the system architecture can run the software, enter the following command:
# grep "model name" /proc/cpuinfo
- Check Software Requirements
6. To determine which version of the operating system is installed, enter the following command:
# cat /etc/issue
7. To determine whether the required kernel is installed, enter the following command :
# uname -r
8. To determine whether the required packages are installed, enter commands similar to the following:
# rpm -q
The following packages (or later versions) must be installed:
make-3.79.1
gcc-3.2.3-34
glibc-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
openmotif21-2.1.30-8 (*)
setarch-1.3-1
If packages are not installed then install them from:
* From RedHat AS3 Disk 2
$ cd /mnt/cdrom/RedHat/RPMS
$ rpm -Uvh setarch-1.3-1.i386.rpm
* From RedHat AS3 Disk 3
$ cd /mnt/cdrom/RedHat/RPMS
$ rpm -Uvh openmotif21-2.1.30-8.i386.rpm
$ rpm -Uvh compat-glibc-7.x-2.2.4.32.5.i386.rpm \
compat-gcc-7.3-2.96.122.i386.rpm \
compat-gcc-c++-7.3-2.96.122.i386.rpm \
compat-libstdc++-7.3-2.96.122.i386.rpm \
compat-libstdc++-devel-7.3-2.96.122.i386.rpm \
compat-db-4.0.14-5.i386.rpm
NOTE: (RHEL 4.0) cdrom drive is acesible through mount point /media and NOT /mnt/cdrom
NOTE: (RHEL 4.0) Needed also is libaio-0.0.96.i386.rpm (From RedHat AS4 Disk 3)
9. Creating Required Operating System Groups and Users. If necessary, enter the following commands to create the oinstall and dba groups:
# groupadd oinstall
# groupadd dba
10. To determine whether the oracle user exists and belongs to the correct groups, enter the following command:
# id oracle
If necessary, complete one of the following actions:
- If the oracle user exists, but its primary group is not oinstall or it is not a member of the dba group, then enter the following command:
# /usr/sbin/usermod -g oinstall -G dba oracle
- If the oracle user does not exist, enter the following command to create it:
# /usr/sbin/useradd -g oinstall -G dba -u 501 oracle
This command creates the oracle user and specifies oinstall as the primary group and dba as the secondary group.
11. Enter the following command to set the password of the oracle user:
# passwd oracle
12. Configuring Kernel Parameters
12a. If the value of any kernel parameter is different from the recommended value, then complete the following steps: Using any text editor, create or edit the /etc/sysctl.conf file and add or edit lines similar to the following:
Note: Include lines only for the kernel parameter values that you want to change. For the semaphore parameters (kernel.sem), you must specify all four values. However, if any of the current values are larger than the recommended value, specify the larger value.
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
12b. Apply new kernel settings to current session with :
# sysctl -p
12c. Run the following command to check the current kernel parameters have been sucessfully changed:
# sysctl -a
13. Set Shell Limits for the oracle User
13a. Set Shell Limits for the oracle User - Bourne or Bash Shell Limit:
Add the following lines to /etc/security/limits.conf file where -> represents the tab character:
* -> -> soft -> nproc -> -> 16384
* -> -> hard -> nproc -> -> 16384
* -> -> soft -> nofile -> -> 65536
* -> -> hard -> nofile -> -> 65536
13b. Add the following line to the /etc/pam.d/login file, if it does not already exist:
session required /lib/security/pam_limits.so
13c.Next, depending on the oracle user's default shell, make the following changes
to the default shell start-up file:
- For the Bourne, Bash, or Korn shell, add the following lines to the /etc/profile file:
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 16384
else
ulimit -u 16384 -n 16384
fi
fi
- For the C or tcsh shell, add the following lines to the /etc/csh.login file:
if ( $USER == "oracle" ) then
limit maxproc 16384
limit descriptors 16384
endif
14. Create the directories in which the Oracle software will be installed:
# mkdir -p /u01/app/oracle/product/10gr2
# chown -R oracle.oinstall /u01
NOTE: Tasks to perform as oracle user
15. Unset variables
$ unset ORACLE_HOME
$ unset TNS_ADMIN

Installation
------------
Start Oracle Universal Installer and install only Oracle software.

Post-Install
------------
1. Edit .bash_profile and add
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
2. If when starting listener with
$ lsnrctl start
you get "Linux error 29: Illegal Seek" then edit listener.ora and add line
SUBSCRIBE_FOR_NODE_DOWN_EVENT_=OFF