优品（O管理）HIS系统项目ORACLECRAC实施报告ORACLE12CRACHIS项目ORACLERAC实施报告1. 系统环境硬件：P824SanSwitch各两台，3PAR存储；软件：Oracle12C安装规划：1.1系统集成前规划机号机型主机名实例名网卡IP系统1HISDB1Hisdb_1Eth0192.168.0.11AIX7.1OracleClusterOracleSoftVIP192.168.0.16Eth1（心跳）200.100.100.12HISDB2Hisdb_1Eth0192.168.0.12AIX7.1OracleClusterOracleSoftVIP192.168.0.17Eth1（心跳）200.100.100.2SCANIP192.168.0.1820它其设置网关gateway192.168.0.201子网掩码netmask255.255.255.0DNS1.2.存储的划分ORACLE空间存储柜划分存储柜整列RAIDLUN容量文件格式用途1Array110110GASMOCR/VotingDisk210GASMOCR/VotingDisk310GASMOCR/VotingDisk41TBASMASMDisk51TBASMASMDisk61TBASMASMDisk71TBASMASMDisk8300GBASMORACLEArchielog9300GBASMORACLEArchielog2. 安装前的准备2.1. 系统补丁补丁列表如下：bos.adt.basebos.adt.libbos.adt.libmbos.perf.libperfstatbos.perf.perfstatbos.perf.proctoolsrsct.basic.rtersct.compat.clients.rte检查补丁文件。lslpp-lbos.adt.basebos.adt.libbos.adt.libmbos.perf.libperfstatbos.perf.perfstatbos.perf.proctoolsrsct.basic.rtersct.compat.clients.rte2.2. 修改系统参数VMOvmo-p-ominperm%=3vmo-p-omaxperm%=90vmo-p-omaxclient%=90vmo-p-olru_file_repage=0vmo-p-ostrict_maxclient=1vmo-p-ostrict_maxperm=0ConfigureNetworkTuningParametersno-p-oudp_sendspace=65536no-p-oudp_recvspace=262144no-p-otcp_sendspace=262144no-p-otcp_recvspace=262144no-p-orfc1323=1no-p-osb_max=2*655360no-r-oipqmaxlen=512修改磁盘属性chowngrid:asmadmin/dev/rhdisk1chowngrid:asmadmin/dev/rhdisk2chowngrid:asmadmin/dev/rhdisk3chowngrid:asmadmin/dev/rhdisk4chowngrid:asmadmin/dev/rhdisk5chowngrid:asmadmin/dev/rhdisk6chowngrid:asmadmin/dev/rhdisk7chowngrid:asmadmin/dev/rhdisk8chowngrid:asmadmin/dev/rhdisk9chmod660/dev/rhdisk1chmod660/dev/rhdisk2chmod660/dev/rhdisk3chmod660/dev/rhdisk4chmod660/dev/rhdisk5chmod660/dev/rhdisk6chmod660/dev/rhdisk7chmod660/dev/rhdisk8chmod660/dev/rhdisk9chdev-lhdisk1-areserve_policy=no_reservechdev-lhdisk2-areserve_policy=no_reservechdev-lhdisk3-areserve_policy=no_reservechdev-lhdisk4-areserve_policy=no_reservechdev-lhdisk5-areserve_policy=no_reservechdev-lhdisk6-areserve_policy=no_reservechdev-lhdisk7-areserve_policy=no_reservechdev-lhdisk8-areserve_policy=no_reservechdev-lhdisk9-areserve_policy=no_reserve/usr/sbin/chdev-lhdisk1-apv=clear/usr/sbin/chdev-lhdisk2-apv=clear/usr/sbin/chdev-lhdisk3-apv=clear/usr/sbin/chdev-lhdisk4-apv=clear/usr/sbin/chdev-lhdisk5-apv=clear/usr/sbin/chdev-lhdisk6-apv=clear/usr/sbin/chdev-lhdisk7-apv=clear/usr/sbin/chdev-lhdisk8-apv=clear/usr/sbin/chdev-lhdisk9-apv=clear系统连接数smittychgsysMaximumnumberofPROCESSESallowedperuser16384换页空间Smittychps增加换页空间修改/etc/hosts修改/etc/hosts192.168.0.11hisdb1192.168.0.16hisdb1vip192.168.0.12hisdb2200.100.100.2hisdb2priv192.168.0.17hisdb2vip192.168.0.18hisdb.scan.com192.168.0.19hisdb.scan.com192.168.0.20hisdb.scan.com200.100.100.1hisdb1priv2.3. 配置NTP#vi/etc/ntp.conf#broadcastclientserver172.16.10.15driftfile/etc/ntp.drifttracefile/etc/ntp.trace启动xntpd守护进程#startsrc-sxntpdxntpd状态查询,使用#lssrc-lsxntpd刚启动xntpd时,syspeer为insane,表明xntpd还没有完成同步启动xntpd守护进程#startsrc-sxntpdxntpd状态查询,使用#lssrc-lsxntpd2.4. 创建用户和组1） 创建用户及相应的目录创建组mkgroup-Aid=1000adms=rootoinstallmkgroup-Aid=1100adms=rootasmadminmkgroup-Aid=1200adms=rootdbamkgroup-Aid=1201adms=rootopermkgroup-Aid=1300adms=rootasmdbamkgroup-Aid=1301adms=rootasmoper创建用户mkuserid=1100pgrp=oinstallgroups=asmadmin,asmdba,asmoperhome=/home/gridgridmkuserid=1101pgrp=oinstallgroups=dba,asmdbahome=/home/oracleoraclechusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATEgridchusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATEoracle修改两用户权限default:fsize=-1core=2097151cpu=-1data=-1rss=-1stack=-1nofiles=-12）配置GRID用户环境变量#sugridexportORACLE_BASE=/oracle/app/oracleexportORACLE_HOME=/oracle/app/grid/product/12.1.0exportORACLE_SID=+ASM1exportNLS_LANG=AMERICAN_AMERICA.AL32UTF8exportNLS_DATE_FORMAT=yyyy-mm-ddhh24:mi:ssexportPATH=.:$PATH:$HOME/bin:$ORACLE_HOME/binexportPATH=$PATH:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexportPATH=$PATH:$ORACLE_BASE/common/oracle/binexportORACLE_PATH=$PATH:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/adminexportORACLE_TERM=xtermexportTNS_ADMIN=$ORACLE_HOME/network/adminexportORA_NLS10=$ORACLE_HOME/nls/dataexportLD_LIBRARY_PATH=$ORACLE_HOME/libexportLD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/oracm/libexportLD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/usr/lib:/usr/local/libexportCLASSPATH=$ORACLE_HOME/JREexportCLASSPATH=$CLASSPATH:$ORACLE_HOME/jlibexportCLASSPATH=$CLASSPATH:$ORACLE_HOME/rdbms/jlibexportCLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlibexportTHREADS_FLAG=nativee