Red Hat Enterprise Linux 4.0 U4 X86_64下安裝Oracle10.2.0.1(64bit) [簡易版]

硬體環境:

DELL PE2950

8G Mem

Red Hat Linux 版本:

Red Hat Enterprise Linux AS release 4 (Nahant Update 4)

Kernel 2.6.9-42.ELsmp on an x86_64

Red Hat Enterprise Linux 4.0 U4: 打包

binutils-2.15.92.0.2-10.EL4

compat-db-4.1.25-9

control-center-2.8.0-12

gcc-3.4.3-9.EL4

gcc-c++-3.4.3-9.EL4

glibc-2.3.4-2

glibc-common-2.3.4-2

gnome-libs-1.4.1.2.90-44.1

libstdc++-3.4.3-9.EL4

libstdc++-devel-3.4.3-9.EL4

make-3.80-5

pdksh-5.2.14-30

sysstat-5.0.5-1

xscreensaver-4.18-5.rhel4.2

libaio-devel-0.3.105-2.x86_64.rpm

libaio-0.3.105-2.x86_64.rpm

配置Kernel Parameter .

修改檔案 /etc/sysctl.conf

kernel.shmall = 2097152

kernel.shmmax = 4294967296 # Half the size of physical memory (in bytes)

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

Oracle使用者環境變數設定:

修改 /home/oracle/.bash_profile

加入oracle使用者的環境變數 .

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:/bin:/sbin:/usr/bin:/usr/sbin

BASH_ENV=$HOME/.BASHRC

export BASH_ENV PATH

unset USERNAME

# Set Oracle Environment

ORACLE_HOME=/u01/product/oracle;export ORACLE_HOME

ORACLE_SID=wind;export ORACLE_SID

ORACLE_OWNER=oracle;export ORACLE_OWNER

ORACLE_BASE=/u01/product;export ORACLE_BASE

ORACLE_TERM=vt100;export ORACLE_TERM

#NLS_LANG='traditional chinese_taiwan'.ZHT16BIG5;export NLS_LANG

LD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH

set -u

PS1=`hostname`'$';export PS1

EDITOR=/bin/vi; export EDITOR

JAVA_HOME=/usr/local/java;export JAVA_HOME

ORA_NLS33=/u01/product/oracle/ocommon/nls/admin/data;export ORA_NLS33

CLASSPATH=/u01/product/oracle/jdbc/lib/classesl11.zip:/usr/local/java;

export DISPLAY=127.0.0.1:0.0

export LD_ASSUME_KERNEL=2.6.9

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

alias ll='ls -l';

alias ls='ls --color';

alias his='history';

Add the following lines to the /etc/security/limits.conf file:

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

Add or edit the following line in the /etc/pam.d/login file, if it does not

already exist:

session required pam_limits.so

Oracle : 暫時設定記憶體大小

SGA : 3G

Shared_Pool_Size : 500 M

PGA : 500 M .