Debian 32位Oracle安裝

--安裝環境包

apt-get install gcc make binutils libmotif3 lesstif2 rpm libaio1 libdb3 awk(mawk,original-awk,gawk) libc6-dev libc6
apt-get install gcc-3.3 g++-3.3 libstdc++5
------------------------------------------------------------------------
libmotif3 下載包：libmotif3_2.2.3-1_i386.deb
dpkg -i
-----------------------------------------------------------------------
 
--建立幾個連結
# ln -s /usr/bin/awk /bin/awk
# ln -s /usr/bin/basename /bin/basename
# ln -s /usr/bin/rpm /bin/rpm
# ln -s /etc /etc/rc.d    # Required for root.sh

--建立使用者：
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba  -m oracle
usermod -g oinstall -G dba oracle

查詢grep nobody /etc/group
# groupadd nobody
查詢nobody使用者
# id nobody
# useradd -g nobody nobody
如果有nobody
# usermod -g nobody nobody

--建立資料夾：

mkdir -p /oracle/app/oracle
mkdir -p /oradata
chown -R oracle:oinstall /oracle/app/oracle /oradata
chmod -R 775 /oracle/app/oracle /oradata

--/etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

備註：shmmax核心引數定義單個共享記憶體段的最大值，要大於Oracle SGA
--檢視實體記憶體: grep MemTotal /proc/meminfo
--檢視SWAP空間: grep SwapTotal /proc/meminfo
執行/sbin/sysctl -p使修改生效

--/etc/security/limits.conf
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384

--/etc/pam.d/login
session  required  /lib/security/pam_limits.so

--/etc/profile
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
--設定環境變數：
.bash_profile
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/local/lib
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

--執行：
DISPLAY:0.0
# source .bash_profile
# ./runinstaller -ignoreSysPrereqs