Debian Oracle Server Kurulumu

vim /etc/shorewall/rules
	#fw
	ACCEPT          fw                      net             icmp	
	# net
	ACCEPT          net                     fw              tcp     1521
	ACCEPT          net                     fw              tcp     22
	HTTP/ACCEPT     net                     fw
	Ping/ACCEPT     net                     fw

vim /etc/default/shorewall
	startup=1

vim /etc/sysctl.conf
	kernel.sem = 250 32000 100 128
	kernel.shmmax = 2147483648
	net.ipv4.ip_local_port_range = 9000 65000
	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
	fs.file-max = 6815744

cat > /etc/init.d/oracle-shm <<-EOF
#! /bin/sh
# /etc/init.d/oracle-shm
#
#
case "\$1" in
  start)
    echo "Starting script /etc/init.d/oracle-shm"
    # Run only once at system startup
    if [ -e /dev/shm/.oracle-shm ]; then
      echo "/dev/shm is already mounted, nothing to do"
    else
      mkdir /var/lock/subsys 2>/dev/null
      touch /var/lock/subsys/listener
      rm /dev/shm 2>/dev/null
      mkdir /dev/shm 2>/dev/null
      mount -t tmpfs shmfs -o size=16384m /dev/shm
      touch /dev/shm/.oracle-shm
      #rm -f /dev/shm
      #mkdir /dev/shm
      #mount -t tmpfs shmfs -o size=2048m /dev/shm
      #touch /dev/shm/.oracle-shm
    fi
    ;;
  stop)
    echo "Stopping script /etc/init.d/oracle-shm"
    echo "Nothing to do"
    ;;
  *)
    echo "Usage: /etc/init.d/oracle-shm {start|stop}"
    exit 1
    ;;
esac
#
### BEGIN INIT INFO
# Provides:          oracle-shm
# Required-Start:    $remote_fs $syslog
# Required-Stop:     $remote_fs $syslog
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6 
# Description:       Fix to allow Oracle 11g use AMM.
### END INIT INFO
EOF

cat > /sbin/chkconfig <<-EOF
#!/bin/bash
# Oracle 11gR2 XE installer chkconfig hack for Debian based Linux (by dude)
# Only run once.
echo "Simulating /sbin/chkconfig..."
if [[ ! \`tail -n1 /etc/init.d/oracle-xe | grep INIT\` ]]; then
cat >> /etc/init.d/oracle-xe <<-EOM
#
### BEGIN INIT INFO
# Provides:                  OracleXE
# Required-Start:        \$remote_fs \$syslog
# Required-Stop:        \$remote_fs \$syslog
# Default-Start:            2 3 4 5
# Default-Stop:            0 1 6
# Short-Description:   Oracle 11g Express Edition
### END INIT INFO
EOM
fi
update-rc.d oracle-xe defaults 80 01
EOF

vim .bashrc
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export PATH=$ORACLE_HOME/bin:$PATH