用户 说明

-----------------------------------------------------------------------------------------------

root rpm

-------------------------------------------------------

binutils-2.15.92.0.2-24

compat-libstdc++-33-3.2.3-47.3

elfutils-libelf-0.97.1-5

elfutils-libelf-devel-0.97.1-5

gcc-3.4.6-9 gcc-c++-3.4.6-9

glibc-2.3.4-2.39

glibc-2.3.4-2.39.i686.rpm

glibc-common-2.3.4-2.39

glibc-devel-2.3.4-2.39

libaio-0.3.105-2

libaio-devel-0.3.105-2

libgcc-3.4.6-9

libstdc++-3.4.6-9

libstdc++-devel-3.4.6-9

make-3.80-6.EL4

sysstat-5.0.5-16.rhel4

unixODBC-2.2.11-1.RHEL4.1

unixODBC-devel-2.2.11-1.RHEL4.1

xorg-x11-deprecated-libs-devel-6.8.2-1.EL.33

xorg-x11-devel-6.8.2-1.EL.33

root 配置内核参数

vi /etc/sysctl.conf

-------------------------------------------------

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.shmall = 2097152

kernel.sem = 256 32000 100 142

fs.file-max = 327679

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 262144

root 使设置生效

--------------------------------------------------

/sbin/sysctl -p

创建用户

--------------------------------------------------

groupadd oinstall

groupadd dba

useradd -g oinstall -G dba oracle

passwd oracle

添加oracle用户的限制参数

root vi /etc/security/limits.conf

--------------------------------------------------

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft nproc 2047

oracle hard nproc 16384

root vi /etc/pam.d/login

-------------------------------------------------------------

session required /lib/security/pam_limits.so

session required pam_limits.so

root vi /etc/profile

-------------------------------------------------------------

if [ $USER = "oracle" ]; then

if [ $SHELL = "" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

root 创建安装目录

--------------------------------------------------------------

mkdir -P d01

chown -R oracle:oinstall d01

chmod -R 775 d01

root 创建临时文件夹

---------------------------------------------------------------

sudo mkdir /d01/tmp

sudo chmod a+wr /d01/tmp

oracle 设置环境变量

vi .bash_profile

---------------------------------------------------------------

export PATH

export ORACLE_BASE=/d01/Oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1

export ORA_CRS_HOME=$ORACLE_BASE/crs

export ORACLE_PATH=$ORACLE_BASE/common/Oracle/sql:.:$ORACLE_HOME/rdbms/admin

export ORACLE_SID=orc1

export PATH=$ORACLE_HOME/BIN;$ORA_CRS_HOME/bin:${PATH}:$HOME/bin

export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

export ORACLE_TERM=xterm

export TNS_ADMIN=$ORACLE_HOME/network/admin

export ORA_NLS10=$ORACLE_HOME/nls/data

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/oracm/lib:$ORACLE_HOME/lib

export LIBPATH=$LIBPATH:$ORA_CRS_HOME/LIB:$oracle_home/LIB

export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/RDBMS/JLIB:$ORACLE_HOME/JLIB:$ORACLE_HOME/network/jlib:$ORACLE_HOME/JPE

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export LANG=AMERICAN_AMERICA.ZHS16GBK

oracle 解压缩安装文件

---------------------------------------------------------------

unzip xx.zip

oracle 安装

---------------------------------------------------------------

./runInstaller

oracle 数据库启动和关闭

--------------------------------------------------------------

sqlplus /nolog

startup [mount/nomount/open]

sqlplus shutdown immediate

oracle 监听进程的启动和关闭

--------------------------------------------------------------

lsnrctl [start/stop/status/reload/set/show/help/version][@more@]