软件Oracle 12C 安装规划 1.1 系统集成前规划 机号 机型 主机名 实例名 网卡 IP 系统 1 HISDB1 Hisdb_1 Eth0 192.168.0.11 AIX7.1 Oracle Cluster Oracle Soft VIP 192.168.0.16 Eth1（心跳） 200.100.100.1 2 HISDB2 Hisdb_1 Eth0 192.168.0.12 AIX7.1 Oracle Cluster Oracle Soft VIP 192.168.0.17 Eth1（心跳） 200.100.100.2 SCAN IP 192.168.0.1820 它其设置 网关gateway 192.168.0.201 子网掩码netmask 255.255.255.0 DNS 1.2. 存储的划分 ORACLE 空间存储柜划分 存储柜 整列 RAID LUN 容量 文件格式 用途 1 Array1 10 1 10G ASM OCR/Voting Disk 2 10G ASM OCR/Voting Disk 3 10G ASM OCR/Voting Disk 4 1TB ASM ASM Disk 5 1TB ASM ASM Disk 6 1TB ASM ASM Disk 7 1TB ASM ASM Disk 8 300GB ASM ORACLE Archie log 9 300GB ASM ORACLE Archie log 2. 安装前的准备 2.1. 系统补丁 补丁列表如下 bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools rsct.basic.rte pat.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 pat.clients.rte 2.2. 修改系统参数 VMO vmo -p -o minperm3 vmo -p -o maxperm90 vmo -p -o maxclient90 vmo -p -o lru_file_repage0 vmo -p -o strict_maxclient1 vmo -p -o strict_maxperm0 Configure Network Tuning Parameters no -p -o udp_sendspace65536 no -p -o udp_recvspace262144 no -p -o tcp_sendspace262144 no -p -o tcp_recvspace262144 no -p -o rfc13231 no -p -o sb_max2*655360 no -r -o ipqmaxlen512 修改磁盘属性 chown gridasmadmin /dev/rhdisk1 chown gridasmadmin /dev/rhdisk2 chown gridasmadmin /dev/rhdisk3 chown gridasmadmin /dev/rhdisk4 chown gridasmadmin /dev/rhdisk5 chown gridasmadmin /dev/rhdisk6 chown gridasmadmin /dev/rhdisk7 chown gridasmadmin /dev/rhdisk8 chown gridasmadmin /dev/rhdisk9 chmod 660 /dev/rhdisk1 chmod 660 /dev/rhdisk2 chmod 660 /dev/rhdisk3 chmod 660 /dev/rhdisk4 chmod 660 /dev/rhdisk5 chmod 660 /dev/rhdisk6 chmod 660 /dev/rhdisk7 chmod 660 /dev/rhdisk8 chmod 660 /dev/rhdisk9 chdev -l hdisk1 -a reserve_policyno_reserve chdev -l hdisk2 -a reserve_policyno_reserve chdev -l hdisk3 -a reserve_policyno_reserve chdev -l hdisk4 -a reserve_policyno_reserve chdev -l hdisk5 -a reserve_policyno_reserve chdev -l hdisk6 -a reserve_policyno_reserve chdev -l hdisk7 -a reserve_policyno_reserve chdev -l hdisk8 -a reserve_policyno_reserve chdev -l hdisk9 -a reserve_policyno_reserve /usr/sbin/chdev -l hdisk1 -a pvclear /usr/sbin/chdev -l hdisk2 -a pvclear /usr/sbin/chdev -l hdisk3 -a pvclear /usr/sbin/chdev -l hdisk4 -a pvclear /usr/sbin/chdev -l hdisk5 -a pvclear /usr/sbin/chdev -l hdisk6 -a pvclear /usr/sbin/chdev -l hdisk7 -a pvclear /usr/sbin/chdev -l hdisk8 -a pvclear /usr/sbin/chdev -l hdisk9 -a pvclear 系统连接数 smitty chgsys Maximum number of PROCESSES allowed per user [16384] 换页空间 Smitty chps 增加换页空间 修改/etc/hosts 修改/etc/hosts 192.168.0.11 hisdb1 192.168.0.16 hisdb1vip 192.168.0.12 hisdb2 200.100.100.2 hisdb2priv 192.168.0.17 hisdb2vip 192.168.0.18 192.168.0.19 192.168.0.20 200.100.100.1 hisdb1priv 2.3. 配置NTP vi /etc/ntp.conf broadcastclient server 172.16.10.15 driftfile /etc/ntp.drift tracefile /etc/ntp.trace 启动xntpd守护进程 startsrc -s xntpd xntpd 状态查询 , 使用 lssrc -ls xntpd 刚启动xntpd时, sys peer 为 insane, 表明xntpd还没有完成同步 启动xntpd守护进程 startsrc -s xntpd xntpd 状态查询 , 使用 lssrc -ls xntpd 2.4. 创建用户和组 1） 创建用户及相应的目录 创建组 mkgroup -A id1000 admsroot oinstall mkgroup -A id1100 admsroot asmadmin mkgroup -A id1200 admsroot dba mkgroup -A id1201 admsroot oper mkgroup -A id1300 admsroot asmdba mkgroup -A id1301 admsroot asmoper 创建用户 mkuser id1100 pgrpoinstall groupsasmadmin,asmdba,asmoper home/home/grid grid mkuser id1101 pgrpoinstall groupsdba,asmdba home/home/oracle oracle chuser capabilitiesCAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid chuser capabilitiesCAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle 修改两用户权限 default fsize -1 core 2097151 cpu -1 data -1 rss -1 stack -1 nofiles -1 2）配置GRID用户环境变量 su – grid export ORACLE_BASE/oracle/app/oracle export ORACLE_HOME/oracle/app/grid/product/12.1.0 export ORACLE_SIDASM1 export NLS_LANGAMERICAN_AMERICA. AL32UTF8 export NLS_DATE_AT“yyyy-mm-dd hh24miss“ export PATH.{PATH}HOME/binORACLE_HOME/bin export PATH{PATH}/usr/bin/bin/usr/bin/X11/usr/local/bin export PATH{PATH}ORACLE_BASE/common/oracle/bin export ORACLE_PATH{PATH}ORACLE_BASE/common/oracle/sql.ORACLE_HOME/rdbms/admin export ORACLE_TERMxterm export TNS_ADMINORACLE_HOME/network/admin export ORA_NLS10ORACLE_HOME/nls/data