快速 CentOS6.3 配置安装 Oracle11gR2 命令集

===============================================
cat /etc/sysconfig/network-scripts/ifcfg-eth0

vi  /etc/sysconfig/network-scripts/ifcfg-eth0



DEVICE="eth0"
BOOTPROTO="static"
ONBOOT=yes
TYPE="Ethernet"
HWADDR=D4:3D:7E:13:38:83
IPADDR=223.223.80.241
NETMASK="255.255.255.0"
GATEWAY="223.223.80.190"
DNS1="202.102.134.68"
DOMAIN="218.56.57.58"
NAME=eth0

================================================
service iptables stop
chkconfig iptables off

================================================
vi /etc/selinux/config   
SELINUX=disabled
================================================

/usr/sbin/groupadd oinstall 
/usr/sbin/groupadd dba 
/usr/sbin/useradd -g oinstall -G dba oracle 
================================================
passwd oracle 
id nobody  
================================================
vi  /etc/oraInst.loc 

inventory_loc=/u01/oraInventory 
inst_group=oinstall 
================================================

/usr/sbin/usermod -g oinstall -G dba oracle 
/usr/sbin/useradd -g oinstall -G dba oracle 

================================================

rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-

devel 
glibc glibc-common glibc-devel glibc-headers gcc 
gcc-c++ libaio libaio-devel libgcc libstdc++ 
libstdc++-devel make sysstat unixODBC unixODBC-devel 

================================================
vi /etc/sysctl.conf 
 
fs.file-max = 6815744 
fs.aio-max-nr = 1048576 
kernel.shmall = 2097152 
kernel.shmmax = 2147483648 
kernel.shmmni = 4096 
kernel.sem = 250 32000 100 128 
net.ipv4.ip_local_port_range = 9000 65500 
net.core.rmem_default = 4194304 
net.core.rmem_max = 4194304 
net.core.wmem_default = 262144 
net.core.wmem_max = 1048576

================================================
/sbin/sysctl -p 

================================================
vi  /etc/security/limits.conf 


oracle           soft    nproc   2047 
oracle           hard    nproc   16384 
oracle           soft    nofile  1024 
oracle           hard    nofile  65536 

================================================
vi  /etc/pam.d/login 

session    required     /lib/security/pam_limits.so 
session    required     pam_limits.so 

================================================
vi /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

================================================
su - oracle 

vi .bash_profile 


umask 022
export ORACLE_BASE=/u01
export ORACLE_HOME=$ORACLE_BASE/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=YMS
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"

================================================
 
 mkdir -p /u01/ 
 mkdir -p /u01/app/
 chown -R oracle:oinstall /u01/app/ 
 chmod -R 777 /u01/
 
==================================================
listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST =223.223.80.241)(PORT = 1521))
    )
  ) 
    

SID_LIST_LISTENER = 
   (SID_LIST = 
     (SID_DESC =
       (SID_NAME = PLSExtProc)
       (ORACLE_HOME =/u01/app/product/11.2.0)
       (PROGRAM = extproc)
     ) 
     (SID_DESC =
       (GLOBAL_DBNAME =YMS)
       (ORACLE_HOME =/u01/app/product/11.2.0)
       (SID_NAME = YMS)
      )
   )

ADR_BASE_LISTENER = /u01

=====================================================
vi /etc/hosts
223.223.80.241  sdsmart