Adding Oracle Command line history

Adding Oracle Command line history

Oracle 11g on Redhat 6.2

These are the simplified instructions I use for setting up a Oracle Instance on Redhat 6 (They are ased on

As root

yum install compat-libstdc++-33.x86_64 binutils elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel glibc-headers gcc gcc-c++ libaio-devel libaio libgcc libstdc++ libstdc++ make sysstat unixODBC unixODBC-devel unzip 

groupadd oinstall
groupadd dba
useradd -m -g oinstall -G dba -s /bin/bash oracle
passwd oracle

 vi /etc/sysctl.conf

Add the following to the end

kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
sysctl -p
vi /etc/security/limits.conf

Add the following to the end

oracle soft nproc  2047
oracle hard nproc  16384
oracle soft nofile 1024
oracle hard nofile 65536
vi /etc/pam.d/login
Add the following to the end

session required /lib64/security/
session required
vi /etc/profile.d/

Add the following to the end


if [ $USER = “oracle” ]; then
  if [ $SHELL = “/bin/ksh” ]; then
    ulimit -p 16384
    ulimit -n 65536
    ulimit -u 16384 -n 65536

chmod +x /etc/profile.d/

mkdir -p /opt/app/oracle/product/11.2.0
chown -R oracle:oinstall /opt/app
chmod -R 775 /opt/app
As oracle
vi .bash_profile

Add the following to the end

umask 022

export TMPDIR=$TMP
export ORACLE_BASE=/opt/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

Now run the installer
Oracle 11g on Redhat 6.2