Fast Setup for Oracle Install on AIX

原创

alexatrebooting 2012-03-21 22:38:11 博主文章分类：Oracle ©著作权

文章标签 Oracle AIX Install Fast setup 文章分类 Oracle 数据库

©著作权归作者所有：来自51CTO博客作者alexatrebooting的原创作品，请联系作者获取转载授权，否则将追究法律责任

快速设置FOR Oracle 11gR2 在IBM 小型机 AIX 5.3、AIX6.1、AIX7.1上初始环境设置

使用方法：在AIX上创建一个文件，比如pre_install_ora.sh

then: sh pre_install_ora.sh

最后可使用vnc或xmanager开始Oracle软件安装了，避免了繁琐初始设置；

#!/usr/bin/ksh
# Copyright (C) 2004-2011 Alexatrebooting
# All Rights Reserved.
# Create by:alexatreboting
# Email: hu
# Update: 2011-12-1
# Usage:revise to executed,direct execute;
# description: Oracle 11g IBM Server install prepare script.
echo "Creat Oracle Group and User and Driectory and reivse Authorization"
mkgroup -'A' id='601' adms='root' oinstall
mkgroup -'A' id='602' adms='root' dba
mkgroup -'A' id='603' adms='root' oper
mkgroup -'A' id='604' adms='root' asmadmin
mkgroup -'A' id='605' adms='root' asmdba
mkgroup -'A' id='606' adms='root' asmoper
mkuser id='601' pgrp='oinstall' groups='asmadmin,asmdba,asmoper,dba,oper' home='/home/grid' grid
mkuser id='602' pgrp='oinstall' groups='dba,oper,asmdba' home='/home/oracle' oracle
/usr/bin/chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid
mkdir -p /u01/app/crs_base
mkdir -p /u01/soft
mkdir -p /u01/app/crs_home
mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R grid:oinstall /u01
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01
echo "revise oracle and grid password"
passwd oracle <<EOF
oracle
oracle
EOF
passwd grid <<EOF
grid
grid
EOF

echo "Create Grid SetEnv Script"
ENVFILE1=/home/grid/setenv
cat > $ENVFILE1 <<EOF
export ORACLE_HOSTNAME=`hostname`
export JAVA_HOME=/usr/local/java
export ORACLE_SID=+ASM #revise to your SID
export ORACLE_BASE=/u01/app/crs_base
export ORACLE_HOME=/u01/app/crs_home
export PATH=\$ORACLE_HOME/bin:\$JAVA_HOME/bin:\$PATH:/usr/local/bin/
export AIXTHREAD_SCOPE=S
#/usr/local/bin/bash
if [ -t 0 ]; then
stty intr ^C
fi
EOF

cat >> /home/grid/.profile <<EOF
# Load Grid 11g Env
. $ENVFILE1
EOF

echo "Create Oracle SetEnv Script"
ENVFILE2=/home/oracle/setenv
cat > $ENVFILE2 <<EOF
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/db_1
export GRID_HOME=/u01/app/crs_home
export ORACLE_OWNER=oracle
export ORACLE_SID=tdr1     #revise to your SID
export PATH=\$PATH:\$ORACLE_HOME/bin:\$GRID_HOME/bin:/sbin:/usr/sbin:/bin:/usr/local/bin
export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:\$ORACLE_HOME/rdbms/lib:/lib:/usr/lib
export CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib:\$ORACLE_HOME/network/jlib
export NLS_LANG=american_america.ZHS16GBK
export ORACLE_PATH=/home/oracle
export AIXTHREAD_SCOPE=S
#/usr/local/bin/bash
if [ -t 0 ]; then
stty intr ^C
fi
umask 022
#For the Bourne, Bash, or Korn shell, add lines similar to the following to the /etc/profile
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
        if [ $SHELL = "/bin/ksh" ]; then
              ulimit -p 16384
              ulimit -n 65536
        else
              ulimit -u 16384 -n 65536
        fi
        umask 022
fi
EOF

cat >> /home/oracle/.profile <<EOF
# Load Oracle 11g Env
. $ENVFILE2
EOF

echo "Create root SetEnv Script"
ENVFILE3=/setenv
cat > $ENVFILE3 <<EOF
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/db_1
export GRID_HOME=/u01/app/crs_home
export ORACLE_OWNER=oracle
export ORACLE_SID=YOUR_SID #revise to your SID
export PATH=\$PATH:\$ORACLE_HOME/bin:\$GRID_HOME/bin:/u01/app/crs_home/bin:/sbin:/usr/sbin:/bin:/usr/local/bin:.
EOF

cat >> /.profile <<EOF
# Load Oracle 11g Env
. $ENVFILE3
EOF

echo "Revise sys Parameter"
cp /etc/security/limits /etc/security/limits.`date +%Y%m%d%H%M `
sed s/'fsize = 2097151'/'fsize = -1'/ /etc/security/limits |sed s/'data = 262144'/'data = -1'/ |sed s/'rss = 65536'/'rss = -1'/ | sed s/'65536'/'-1'/ |sed s/'nofiles = 2000'/'nofiles = -1'/ >/tmp/limits.tmp
mv -f /tmp/limits.tmp /etc/security/limits
ioo -po aio_maxservers=80
ioo -po aio_minservers=40
chdev -l sys0 -a maxuproc=16384
chdev -l sys0 -a ncargs=256
vmo -p -o minperm%=3
vmo -p -o maxperm%=90 <<EOF
yes
EOF
vmo -p -o maxclient%=90 <<EOF
yes
EOF
vmo -p -o lru_file_repage=0 <<EOF
yes
EOF
vmo -p -o strict_maxclient=1 <<EOF
yes
EOF
vmo -p -o strict_maxperm=0 <<EOF
yes
EOF
echo "revise Network Parameter"
if ! grep -q 'add by oracle install' /etc/rc.net
then
   cat >>/etc/rc.net <<EOF
   #add by oracle install
if [ -f /usr/sbin/no ] ; then
   /usr/sbin/no -r -o ipqmaxlen=512
   /usr/sbin/no -o rfc1323=1
   /usr/sbin/no -p -o sb_max=1500000
   /usr/sbin/no -p -o udp_sendspace=135168
   /usr/sbin/no -p -o udp_recvspace=1351680
   /usr/sbin/no -p -o tcp_sendspace=65536
   /usr/sbin/no -p -o tcp_recvspace=65536
   /usr/sbin/no -p -o tcp_ephemeral_low=9000
   /usr/sbin/no -p -o tcp_ephemeral_high=65500
   /usr/sbin/no -p -o udp_ephemeral_low=9000
   /usr/sbin/no -p -o udp_ephemeral_high=65500
fi
EOF
fi
echo "after then,you need modify hosts ntp dns...base on your installation"