HIS系统项目ORACLE12CRAC实施报告VIP专享VIP免费

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.18~20它其设置网关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系统连接数smittychgsysMaximumnumberofPROCESSESallowedperuser[16384]换页空间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-'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'a...