Ricardo Proni

Quanto menos programas, menos problemas.

Adoro a instalação mínima do OEL (Oracle Enterprise Linux) 6. Este tipo de instalação existia na fonte (RHEL – Red Hat Enterprise Linux) na versão 4, mas sumiu na 5, para voltar na 6. Esta instalação vem até sem unzip, por isso os pacotes adicionais aos pré-requisitos do Oracle Database 11gR2.
Atenção aos parâmetros de kernel, eles podem ser diferentes para cada máquina.

<pre>
[root@OracleDG01 ~]# cat OraclePreReqs.sh
mount /dev/sr0 /mnt
cd /mnt/Packages
yum -y localinstall yum-utils-*.el6.noarch*
yum-complete-transaction
yum -y localinstall unzip-*.el6.x86_64.rpm sysstat-*.el6.x86_64* elfutils-libelf-devel-*.el6.x86_64* gcc-4.4.*.el6.x86_64* libaio-devel-*-10.el6.* kernel-uek-headers-*.el6uek.x86_64* compat-libstdc++-33-*.el6.* libstdc++-devel-*.el6.x86_64* libaio-*.el6.* glibc-headers-*.el6.x86_64* gcc-c++-4.*.el6.x86_64* cloog-ppl-*.el6.x86_64* libgomp-*.el6.x86_64* glibc-devel-*.el6.* ppl-*.el6.x86_64* cpp-*.el6.x86_64* mpfr-*.el6.x86_64* make-*.el6.x86_64* libgcc-*.el6.* libstdc++-*.el6.* binutils-2.*.el6.x86_64.rpm elfutils-libelf-*.el6.x86_64.rpm glibc-2.*.el6.* glibc-common-2.*.el6.x86_64.rpm nss-softokn-freebl-*.el6.* openssh-clients-*.el6.x86_64.rpm libedit-*.el6.x86_64.rpm perl-5.*.el6_1.1.x86_64.rpm perl-Module-Pluggable-*.el6_1.1.x86_64.rpm perl-libs-*.x86_64.rpm perl-Pod-Simple-*.el6_1.1.x86_64.rpm perl-Pod-Escapes-*.el6_1.1.x86_64.rpm perl-version-*.x86_64.rpm kernel-uek-devel-*.el6uek.x86_64.rpm
yum-complete-transaction
yum -y localinstall sysstat-*.el6.x86_64* elfutils-libelf-devel-*.el6.x86_64* gcc-4.4.*.el6.x86_64* libaio-devel-*-10.el6.* kernel-uek-headers-*.el6uek.x86_64* compat-libstdc++-33-*.el6.* libstdc++-devel-*.el6.x86_64* libaio-*.el6.* glibc-headers-*.el6.x86_64* gcc-c++-4.*.el6.x86_64* cloog-ppl-*.el6.x86_64* libgomp-*.el6.x86_64* glibc-devel-*.el6.* ppl-*.el6.x86_64* cpp-*.el6.x86_64* mpfr-*.el6.x86_64* make-*.el6.x86_64* libgcc-*.el6.* libstdc++-*.el6.* binutils-2.*.el6.x86_64.rpm elfutils-libelf-*.el6.x86_64.rpm glibc-2.*.el6.* glibc-common-2.*.el6.x86_64.rpm nss-softokn-freebl-*.el6.* openssh-clients-*.el6.x86_64.rpm libedit-*.el6.x86_64.rpm perl-5.*.el6_1.1.x86_64.rpm perl-Module-Pluggable-*.el6_1.1.x86_64.rpm perl-libs-*.x86_64.rpm perl-Pod-Simple-*.el6_1.1.x86_64.rpm perl-Pod-Escapes-*.el6_1.1.x86_64.rpm perl-version-*.x86_64.rpm kernel-uek-devel-*.el6uek.x86_64.rpmcd
cd
umount /mnt

echo “fs.aio-max-nr = 1048576″ >> /etc/sysctl.conf
echo “fs.file-max = 6815744″ >> /etc/sysctl.conf
echo “kernel.shmmni = 4096″ >> /etc/sysctl.conf
echo “kernel.sem = 250 32000 100 128″ >> /etc/sysctl.conf
echo “net.ipv4.ip_local_port_range = 9000 65500″ >> /etc/sysctl.conf
echo “net.core.rmem_default=262144″ >> /etc/sysctl.conf
echo “net.core.rmem_max=4194304″ >> /etc/sysctl.conf
echo “net.core.wmem_default=262144″ >> /etc/sysctl.conf
echo “net.core.wmem_max=1048586″ >> /etc/sysctl.conf
echo “oracle soft nproc 2047″ >> /etc/security/limits.conf
echo “oracle hard nproc 16384″ >> /etc/security/limits.conf
echo “oracle soft nofile 1024″ >> /etc/security/limits.conf
echo “oracle hard nofile 65536″ >> /etc/security/limits.conf
chkconfig iptables off
chkconfig lvm2-monitor off
chkconfig auditd off
chkconfig ip6tables off
chkconfig restorecond off
groupadd -g 1000 oinstall
groupadd -g 1200 dba
groupadd -g 1300 oper
useradd -u 1100 -g oinstall -G dba oracle
mkdir -p /u01/app/oracle/product/11.2.0/db_1
mkdir -p /u01/oradata
chown -R oracle:oinstall /u01/
chmod -R 775 /u01
echo “export TMP=/tmp” >> /home/oracle/.bash_profile
echo “export TMPDIR=$TMP” >> /home/oracle/.bash_profile
echo “export ORACLE_HOSTNAME=nerv01.localdomain” >> /home/oracle/.bash_profile
echo “export ORACLE_UNQNAME=ORCL” >> /home/oracle/.bash_profile
echo “export ORACLE_BASE=/u01/app/oracle” >> /home/oracle/.bash_profile
echo “export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1″ >> /home/oracle/.bash_profile
echo “export GRID_HOME=/u01/app/11.2.0/grid” >> /home/oracle/.bash_profile
echo “export ORACLE_SID=ORCL” >> /home/oracle/.bash_profile
echo “export ORACLE_TERM=xterm” >> /home/oracle/.bash_profile
echo “export PATH=/usr/sbin:$PATH” >> /home/oracle/.bash_profile
echo “export PATH=$ORACLE_HOME/bin:$GRID_HOME/bin:$PATH” >> /home/oracle/.bash_profile
echo “export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib” >> /home/oracle/.bash_profile
echo “export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib” >> /home/oracle/.bash_profile
echo “if [ $USER = "oracle" ]; then” >> /home/oracle/.bash_profile
echo “if [ $SHELL = "/bin/ksh" ]; then” >> /home/oracle/.bash_profile
echo “ulimit -p 16384″ >> /home/oracle/.bash_profile
echo “ulimit -n 65536″ >> /home/oracle/.bash_profile
echo “else” >> /home/oracle/.bash_profile
echo “ulimit -u 16384 -n 65536″ >> /home/oracle/.bash_profile
echo “fi” >> /home/oracle/.bash_profile
echo “fi” >> /home/oracle/.bash_profile
chown oracle:oinstall /home/oracle/.bash_profile
passwd oracle
</pre>