ORACLE12C RAC HIS项目ORACLE RAC实施报告1. 系统环境硬件： P824 San Switch 各两台，3PAR存储； 软件：Oracle 12C安装规划：1.1 系统集成前规划机号机型主机名实例名网卡IP系统1HISDB1Hisdb_1Eth0192.168.0.11AIX7.1Oracle ClusterOracle SoftVIP192.168.0.16Eth1（心跳）200.100.100.12HISDB2Hisdb_1Eth0192.168.0.12AIX7.1Oracle ClusterOracle SoftVIP192.168.0.17Eth1（心跳）200.100.100.2SCAN IP192.168.0.1820它其设置网关gateway192.168.0.201子网掩码netmask255.255.255.0DNS1.2. 存储的划分ORACLE 空间存储柜划分存储柜整列RAIDLUN容量文件格式用途1Array110110GASMOCR/Voting Disk210GASMOCR/Voting Disk310GASMOCR/Voting Disk41TBASMASM Disk51TBASMASM Disk61TBASMASM Disk71TBASMASM Disk8300GBASMORACLE Archie log9300GBASMORACLE Archie log2. 安装前的准备2.1. 系统补丁补丁列表如下：bos.adt.basebos.adt.libbos.adt.libmbos.perf.libperfstatbos.perf.perfstatbos.perf.proctoolsrsct.basic.rtersct.compat.clients.rte检查补丁文件。lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools rsct.basic.rte rsct.compat.clients.rte 2.2. 修改系统参数VMOvmo -p -o minperm%=3vmo -p -o maxperm%=90vmo -p -o maxclient%=90vmo -p -o lru_file_repage=0vmo -p -o strict_maxclient=1vmo -p -o strict_maxperm=0Configure Network Tuning Parametersno -p -o udp_sendspace=65536no -p -o udp_recvspace=262144no -p -o tcp_sendspace=262144no -p -o tcp_recvspace=262144no -p -o rfc1323=1 no -p -o sb_max=2*655360 no -r -o ipqmaxlen=512 修改磁盘属性chown grid:asmadmin /dev/rhdisk1chown grid:asmadmin /dev/rhdisk2chown grid:asmadmin /dev/rhdisk3chown grid:asmadmin /dev/rhdisk4chown grid:asmadmin /dev/rhdisk5chown grid:asmadmin /dev/rhdisk6chown grid:asmadmin /dev/rhdisk7chown grid:asmadmin /dev/rhdisk8chown grid:asmadmin /dev/rhdisk9chmod 660 /dev/rhdisk1chmod 660 /dev/rhdisk2chmod 660 /dev/rhdisk3chmod 660 /dev/rhdisk4chmod 660 /dev/rhdisk5chmod 660 /dev/rhdisk6chmod 660 /dev/rhdisk7chmod 660 /dev/rhdisk8chmod 660 /dev/rhdisk9chdev -l hdisk1 -a reserve_policy=no_reservechdev -l hdisk2 -a reserve_policy=no_reservechdev -l hdisk3 -a reserve_policy=no_reservechdev -l hdisk4 -a reserve_policy=no_reservechdev -l hdisk5 -a reserve_policy=no_reservechdev -l hdisk6 -a reserve_policy=no_reservechdev -l hdisk7 -a reserve_policy=no_reservechdev -l hdisk8 -a reserve_policy=no_reservechdev -l hdisk9 -a reserve_policy=no_reserve/usr/sbin/chdev -l hdisk1 -a pv=clear/usr/sbin/chdev -l hdisk2 -a pv=clear/usr/sbin/chdev -l hdisk3 -a pv=clear/usr/sbin/chdev -l hdisk4 -a pv=clear/usr/sbin/chdev -l hdisk5 -a pv=clear/usr/sbin/chdev -l hdisk6 -a pv=clear/usr/sbin/chdev -l hdisk7 -a pv=clear/usr/sbin/chdev -l hdisk8 -a pv=clear/usr/sbin/chdev -l hdisk9 -a pv=clear系统连接数smitty chgsysMaximum number of PROCESSES allowed per user 16384换页空间Smitty chps 增加换页空间修改/etc/hosts修改/etc/hosts192.168.0.11 hisdb1192.168.0.16 hisdb1vip192.168.0.12 hisdb2200.100.100.2 hisdb2priv192.168.0.17 hisdb2vip192.168.0.18 hisdb.scan.com192.168.0.19 hisdb.scan.com192.168.0.20 hisdb.scan.com200.100.100.1 hisdb1priv2.3. 配置NTP#vi /etc/ntp.conf#broadcastclientserver 172.16.10.15driftfile /etc/ntp.drifttracefile /etc/ntp.trace启动xntpd守护进程# startsrc -s xntpdxntpd 状态查询 , 使用 #lssrc -ls xntpd刚启动xntpd时, sys peer 为 insane, 表明xntpd还没有完成同步启动xntpd守护进程# startsrc -s xntpdxntpd 状态查询 , 使用 #lssrc -ls xntpd2.4. 创建用户和组1） 创建用户及相应的目录创建组mkgroup -A id=1000 adms=root oinstallmkgroup -A id=1100 adms=root asmadminmkgroup -A id=1200 adms=root dbamkgroup -A id=1201 adms=root opermkgroup -A id=1300 adms=root asmdbamkgroup -A id=1301 adms=root asmoper创建用户mkuser id=1100 pgrp=oinstall groups=asmadmin,asmdba,asmoper home=/home/grid gridmkuser id=1101 pgrp=oinstall groups=dba,asmdba home=/home/oracle oraclechuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE gridchuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle修改两用户权限default: fsize = -1 core = 2097151 cpu = -1 data = -1 rss = -1 stack = -1 nofiles = -12）配置GRID用户环境变量#su grid export ORACLE_BASE=/oracle/app/oracleexport ORACLE_HOME=/oracle/app/grid/product/12.1.0export ORACLE_SID=+ASM1export NLS_LANG=AMERICAN_AMERICA. AL32UTF8export NLS_DATE_FORMAT=yyyy-mm-dd hh24:mi:ssexport PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/binexport PATH=$PATH:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexport PATH=$PATH:$ORACLE_BASE/common/oracle/binexport ORACLE_PATH=$PATH:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/adminexport ORACLE_TERM=xtermexport TNS_ADMIN=$ORACLE_HOME/network/adminexport ORA_NLS10=$ORACLE_HOME/nls/dataexport LD_LIBRARY_PATH=$ORACLE_HO