"Pulos do Gato"

Instalação

Criação de Oracle Base e permissões no padrão "OFA"

===============CORTE==================
#Arquivo: create_oracle_base.sh
sudo mkdir -p /u01/app/oracle
sudo chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app/oracle
===============CORTE==================

===============######==================

Setup dos parâmetros de Kernel

No caso do Oracle Enterprise Linux, editar o seguinte arquivo:
$ /etc/rc.d/rc.local

E inserir o seguinte conteúdo:
===============CORTE==================
# **********************************#
# Ilan Salviano - Oracle
# OracleAS 10g
# **********************************#
sysctl -w kernel.sem="256 32000 100 142"
sysctl -w kernel.shmmax="2147483648"
sysctl -w kernel.shmmni="4096"
sysctl -w kernel.shmall="2097152"
sysctl -w kernel.msgmni="2878"
sysctl -w kernel.msgmnb="65535"
sysctl -w kernel.msgmax="8192"
sysctl -w net.ipv4.ip_local_port_range="10000 65000"
sysctl -w fs.file-max="131072"
ulimit -n 65536
===============CORTE==================

Manutenção

Assassino ( o shell script matador)

O script abaixo eu criei para limpar processo presos que, após o usual "opmnctl shutdown"
ficam zumbis no sistema operacional.

===============CORTE==================
#Arquivo: assassino.sh
MIDDLE=`ps -ef | grep | grep | grep -v grep | wc -l `
INFRA=`ps -ef | grep | grep | grep -v grep | wc -l `
if [ "$MIDDLE" != "0" ]
then
kill -9 `ps -ef | grep | grep | grep -v grep | awk '{print $2}'`
fi
if [ "$INFRA" != "0" ]
then
kill -9 `ps -ef | grep | grep | grep -v grep | awk '{print $2}'`
fi
===============CORTE==================


===============######==================

Este script eu utilizo, geralmente na cron do servidor para limpar os logs mais comuns
que acabam por ocupar todo o espaço no file system. Very handy .....

#############################################
#
# CLEAN LOG
# This script has the simple job to clean all logs files
# which are know of growing progressively
#
# Dependecies:
# none
#
# Logs:
# /home/oracle/logs/cleanup.log
#
# Ilan Melo Salviano - Oracle
#############################################

DATA=`date +"%d/%m/%Y"`
HORA=`date +"%H:%M:%S"`

echo "Start cleaning OracleAS log files at $DATA $HORA" >> /home/oracle/logs/cleanup.log

# Clean TMP
rm -rf /tmp/*

# Clean OHS...
find /u01/app/oracle/products/oracleas1012/infra/Apache/Apache/logs -mtime +1 -type f -name 'error_log.*' -print -exec rm {} \;
find /u01/app/oracle/products/oracleas1012/infra/Apache/Apache/logs -mtime +1 -type f -name 'access_log.*' -print -exec rm {} \;
find /u01/app/oracle/products/oracleas1012/middle/Apache/Apache/logs -mtime +1 -type f -name 'error_log.*' -print -exec rm {} \;
find /u01/app/oracle/products/oracleas1012/middle/Apache/Apache/logs -mtime +1 -type f -name 'access_log.*' -print -exec rm {} \;

# Clean WebCache
find /u01/app/oracle/products/oracleas1012/middle/webcache/logs -mtime +1 -type f -name 'event_log.*' -print -exec rm {} \;
find /u01/app/oracle/products/oracleas1012/middle/webcache/logs -mtime +1 -type f -name 'access_log.*' -print -exec rm {} \;

# Clean Forms J2EE
> /u01/app/oracle/products/oracleas1012/middle/j2ee/OC4J_BI_Forms/log/OC4J_BI_Forms_default_island_1/default-web-access.log
> /u01/app/oracle/products/oracleas1012/middle/j2ee/OC4J_BI_Forms/application-deployments/formsapp/OC4J_BI_Forms_default_island_1/application.log

# Clean Reports
find /u01/app/oracle/products/oracleas1012/middle/reports/cache -mtime +1 -type f -name '*' -print -exec rm {} \;
> /u01/app/oracle/products/oracleas1012/middle/j2ee/OC4J_BI_Forms/application-deployments/reports/OC4J_BI_Forms_default_island_1/application.log

DATA=`date +"%d/%m/%Y"`
HORA=`date +"%H:%M:%S"`

echo "Stop cleaning OracleAS log files at $DATA $HORA" >> /home/oracle/logs/cleanup.log