HIS系统项目ORACLE12CRAC实施报告.docx

1、HIS系统项目ORACLE12CRAC实施报告HIS系统项目ORACLE12CRAC实施报告系统环境硬件： 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.17

2、Eth1（心跳）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 log

3、9300gbASMORACLE Archie log安装前的预备系统补丁补丁列表如下：bos.adt.basebos.adt.libbos.adt.libmbos.perf.libperfstatbos.perf.perfstatbos.perf.proctoolsrsct.basic.rte检查补丁文件。修改系统参数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_m

4、axperm=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

5、 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/

6、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 -

7、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/chd

8、ev -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

9、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 hisdb2vip200.100.100.1 hisdb1priv配置NTP#vi /etc/ntp.conf#broadcastclientserver 172.16.10.15driftfile /etc/ntp.drifttracefile /etc/ntp.trace启动xnt

10、pd守护进程# startsrc -s xntpdxntpd 状态查询 , 使用 #lssrc -ls xntpd刚启动xntpd时, sys peer 为 insane, 表明xntpd还没有完成同步启动xntpd守护进程# startsrc -s xntpdxntpd 状态查询 , 使用 #lssrc -ls xntpd创建用户和组创建用户及相应的名目创建组mkgroup -A id=1000 adms=root oinstallmkgroup -A id=1100 adms=root asmadminmkgroup -A id=1200 adms=root dbamkgroup -A i

11、d=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_VM

12、M,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.0ex

13、port 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/co

14、mmon/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_HOME/libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/oracm/libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/usr/li

15、b:/usr/local/libexport CLASSPATH=$ORACLE_HOME/JREexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/jlibexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/rdbms/jlibexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlibexport THREADS_FLAG=nativeexport TEMP=/tmpexport TMPDIR=/tmpexport PS1=hostname:$PWD$3）配置Oracle用户环境变量；

16、#su oracle #more .profile （oracle 环境变量）export ORACLE_BASE=/oracle/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/12.1.0export ORACLE_SID=020db1export ORACLE_UNQNAME=testdbexport NLS_LANG=AMERICAN_AMERICA.UTF8export NLS_DATE_FORMAT=yyyy-mm-dd hh24:mi:ssexport PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bi

17、nexport 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/admin#export ORA_NLS10=$ORACLE_HOME/nls/dataexpo

18、rt LD_LIBRARY_PATH=$ORACLE_HOME/libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/oracm/libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/usr/lib:/usr/local/libexport CLASSPATH=$ORACLE_HOME/JREexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/jlibexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/rdbms/jlibexport

19、 CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlibexport THREADS_FLAG=nativeexport TEMP=/tmpexport TMPDIR=/tmpexport PS1=hostname:$PWD$安装前的检查额外的检查#bdf /home/grid Ensure you have at least 4.5 GB of space for the grid infrastructure for a cluster home (Grid home) This includes Oracle Clusterware and Auto

20、matic Storage Management (Oracle ASM) files and log files.Grid 存放空间大于10GB，oracle存放空间大于8GB#/bdf /tmp （大于1G的TEMP空间）Ensure that you have at least 1 GB of space in /tmp#add default gateway确保系统有默认网关两个用户配置SSHGrid ingrastrue会自动配置两节点的SSH，只是在实际安装中，可能会碰到不能自动安装的情形，我们能够通过手工安装解决这一咨询题配置SSH的对等性在所有节点配置SSH的对等性在安装Ora

21、cle Real Application clusters之前,必须先配置所有节点的SSH对等性。因为在安装过程种Oracle Universal Installer 使用ssh和scp命令执行远程命令执行及copy的工作。下面是具体的步骤：以下步骤在所有节点上执行：1.以oracle用户登陆# su oracle2.在两个节点的oracle主名目分别创建.ssh名目，并给予权限。# mkdir /.ssh# chmod 755 /.ssh3. 在两个节点分别生成RSA key# /usr/bin/ssh-keygen -t rsa会显现如下提示: Accept the default loc

22、ation for the key file. Enter and confirm a pass phrase that is different from the oracle users password. phrase密码处直截了当回车即可4. 生成DSA key# /usr/bin/ssh-keygen -t dsa显现如下提示: Accept the default location for the key file. Enter and confirm a pass phrase that is different from the oracle users password. p

23、hrase密码处直截了当回车即可5. 以oracle用户身份，在所有节点创建authorized_keys文件，并给予权限# touch /.ssh/authorized_keys# cd /.ssh# ls你应该能够看到你所创建的id_dsa.pub 和id_rsa.pub和authorized_keys6.在两个节点分别将id_dsa.pub 和id_rsa.pub加入到authorized_keys#su grid$ mkdir -p /.ssh$ chmod 700 /.ssh$ /usr/bin/ssh-keygen -t rsa提示输入输入密码时，保持为空回车即可，使用空密码操作简

24、单一些。以下只在 hisdb1 上执行$ touch /.ssh/authorized_keys$ ssh hisdb2 cat /.ssh/id_rsa.pub /.ssh/authorized_keys$ ssh hisdb1 cat /.ssh/id_rsa.pub /.ssh/authorized_keys$ scp /.ssh/authorized_keys hisdb1:.ssh/authorized_keys以下只在 2 个节点上执行：$ chmod 600 /.ssh/authorized_keys当用户等效性建立完毕后，在两个 RAC 节点都执行下面的命令，来验证等效性是否正

25、确6.以oracle用户身份，运行Oracle Universal Installer的节点上执行如下命令，然后测试ssh的对等性。# exec /usr/bin/ssh-agent $SHELL节点1# ssh hisdb1 date# ssh hisdb2 date节点2# ssh hisdb2 date# ssh hisdb1 date如果都不需要密码，得到时刻后。就讲明ssh对等性配置成功。安装Oracel Grid Infrastrue#su gridBourne or Korn shell:$ DISPLAY=local_host:0.0 ; export DISPLAYC she

26、ll:% setenv DISPLAY local_host:0.0安装选项：安装类型选择：选择语言：配置SCAN：配置Cluster节点信息：配置SSH选择特定的网络接口：储备选择：创建ASM 磁盘组：特定的治理组：密码：选择安装位置：选择特定的OraInventory：执行预安装检查：安装汇总：按提示执行脚步： 两台服务器分别运行root.sh/oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for gro

27、up.Removing read,write,execute permissions for world.Changing groupname of /oracle/app/oraInventory to oinstall.The execution of the script is complete.# hostnamehisdb1# /oracle/app/grid/product/12.1.0/root.shPerforming root user operation.The following environment variables are set as: ORACLE_OWNER

28、= grid ORACLE_HOME= /oracle/app/grid/product/12.1.0Enter the full pathname of the local bin directory: /usr/local/bin:The contents of dbhome have not changed. No need to overwrite. Copying oraenv to /usr/local/bin . Copying coraenv to /usr/local/bin .Creating /etc/oratab file.Entries will be added t

29、o the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Using configuration parameter file: /oracle/app/grid/product/12.1.0/crs/install/ crsconfig_params2015/11/09 1

30、8:04:35 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Col lector.2015/11/09 18:05:43 CLSRSC-4002: Successfully installed Oracle Trace File Analyz er (TFA) Collector.2015/11/09 18:05:45 CLSRSC-363: User ignored prerequisites during installationUser grid has the required capabilities to run CSSD in realtime