Friday 9 July 2010

Oracle 11Gr2 Bash_Profile & /etc/sysctl.conf

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

umask 022

ORACLE_BASE=/u01/app/oracle

PATH=$PATH:$HOME/bin

export ORACLE_BASE PATH

export PATH

set -o vi

ORACLE_HOSTNAME=bsq-grid.volume.co.uk;export ORACLE_HOSTNAME

ORACLE_UNQNAME=gridem;export ORACLE_UNQNAME

ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1;export ORACLE_HOME

#OMS_HOME=/u01/app/oracle/oracle/product/10.2.0/oms10g;export OMS_HOME

#AGENT_HOME=/u01/app/oracle/oracle/product/10.2.0/agent10g;export AGENT_HOME

LD_LIBRARY_PATH=$ORACLE_HOME/lib64:$ORACLE_HOME/lib;export LD_LIBRARY_PATH

##PATH=$PATH:$ORACLE_HOME/bin:/oracle/admin/dba/bin;export PATH

PATH=$PATH:$ORACLE_HOME/bin;export PATH

CLASSPATH=$ORACLE_HOME/JRE/lib:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;export CLASSPATH

ORACLE_TERM=xterm;export ORACLE_TERM

#NLS_LANG=American_America.WE8ISO8859P9;export NLS_LANG

#NLS_DATE_FORMAT='yyyy-mon-dd';export NLS_DATE_FORMAT

##NLS_DATE_FORMAT='yyyy-mon-dd:hh24:mi:ss';export NLS_DATE_FORMAT

#unset TNSADMIN

#unset TWO_TASK

. /home/oracle/.aliases

set EDITOR=vi

export PATH




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


#Oracle Requirements

#Hemesh Patel 7th July 2010

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

net.ipv4.tcp_wmem = 262144 262144 262144

net.ipv4.tcp_rmem = 4194304 4194304 4194304


No comments: