Conspect Oracle Installation

//Users and group
Make user: oracle
Make group: oinstall (oracle, apache), dba (oracle)
oinstall group exists
# more /etc/oraInst.loc
dba group exists
# grep dba /etc/group
oracle user exists and belongs to the correct groups, its primary group is oinstall 
# id oracle
nobody user exists
# id nobody

Install only as user oracle.



//Memory check:
RAM size
# grep MemTotal /proc/meminfo
swap space
# grep SwapTotal /proc/meminfo
or
$ /sbin/swapon -s
RAM and swap space
# free
shared memory
# df -k /dev/shm/
disk space in /tmp
# df -k /tmp
view mounted file systems:
# df -k
Check Random Access Memory
$ /usr/sbin/dmesg | grep "Physical:"


$ DISPLAY=workstation_name:0.0
$ export DISPLAY
//Check X11
$ xclock


//Distribution and version of Linux
# cat /proc/version

//Kernel
# uname -r

//Package ckeck
# rpm -q package_name

//Install ODBC Driver Manager for UNIX
????



change kernel parameters
# /sbin/sysctl -p


Add in the /etc/security/limits.conf file:
oracle           soft    nproc   2047
oracle           hard    nproc   16384
oracle           soft    nofile  1024
oracle           hard    nofile  65536

Add to the /etc/pam.d/login file, if it does not already exist:
session    required     /lib/security/pam_limits.so
session    required     pam_limits.so


Add to the /etc/profile
if [ $USER = "oracle" ]; then
        if [ $SHELL = "/bin/ksh" ]; then
              ulimit -p 16384
              ulimit -n 65536
        else
              ulimit -u 16384 -n 65536
        fi
fi


If the ORACLE_SID, ORACLE_HOME, or ORACLE_BASE environment variable is set in the file,
then remove the corresponding lines from the file.



unmask 022








//Create subdirectories
For example:
# mkdir -p /u01/app/
# chown -R oracle:oinstall /u01/app/
# chmod -R 775 /u01/app/

//Mount DVD
$ su root
# umount /cdrom (if authmount)
# mkdir /cdrom  (if not exist)
# mount -t iso9660 /dev/cdrom /cdrom
# exit




_STEP____________________________
ipcs - seting memory, semafor
Entry: root
Entry: proc/sys/kernel
Run: cat sem
Format: SEMMSL SEMMNS SEMOPM SEMMNI
Write in file sem: 250 32000 100 128 (f.e. # echo 250 32000 100 128 > sem)




_STEP____________________________
General memory parameters:
# echo 2147483648 > shmmax
# echo 4096 > shmmni
# echo 2097152 > shmall
Write this in etc/init.d

shmall 2097152 /proc/sys/kernel/shmall 
shmmax 250 /proc/sys/kernel/shmmax (Half the size of the physical memory)
shmmni 4096 /proc/sys/kernel/shmmni 
ip_local_port_range 1024 /proc/sys/net/ipv4/ip_local_port_range (Minimum: 1024 Maximum: 65000)
rmem_default 4194304 /proc/sys/net/core/rmem_default
rmem_max 4194304 /proc/sys/net/core/rmem_max
wmem_default 262144 /proc/sys/net/core/wmem_default 
wmem_max 262144 /proc/sys/net/core/wmem_max 



_STEP____________________________
Setting File Handlres:
# echo 65536 /proc/sys/fs/file-max
ulimit -n 65536

_STEP____________________________
Socket in /proc/sys/net/ipv4/ip_local_port_range
# echo 1024 65000 /proc/sys/net/ipv4/ip_local_port_change

_STEP____________________________
Process limit fot users: 
ulimit -u 16384