Oracle 11g 安装脚本

用户 说明
-----------------------------------------------------------------------------------------------

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@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8069778/viewspace-1015636/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8069778/viewspace-1015636/