《2022年HIS系统项目ORACLE12CRAC实施报告.doc》由会员分享，可在线阅读，更多相关《2022年HIS系统项目ORACLE12CRAC实施报告.doc（48页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、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（心跳）20
2、0.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 log9300GBASMO
3、RACLE Archie log2. 安装前的预备2.1. 系统补丁补丁列表如下：bos.adt.basebos.adt.libbos.adt.libmbos.perf.libperfstatbos.perf.perfstatbos.perf.proctoolsrsct.basic.rtersctpat.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 rsctpat.c
4、lients.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
5、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:asma
6、dmin /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 re
7、serve_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 hdis
8、k8 -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/us
9、r/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 hisd
10、b2priv192.168.0.17 hisdb2vip192.168.0.18 hisdb.scan192.168.0.19 hisdb.scan192.168.0.20 hisdb.scan200.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刚启动xntp
11、d时, 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 asmdba
12、mkgroup -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,
13、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. A
14、L32UTF8export 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_
15、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/lib:/usr/local/libexport CLASSPATH=$ORACLE_HOME/JREexport
16、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用户环境变量；#su oracle #more .profile （oracle 环境变量）export ORACLE_BAS
17、E=/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/binexport PATH=$PATH:/usr/bin:/bin:/usr/bin/X11:/usr/local
18、/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/dataexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport LD_LIBRARY_PAT
19、H=$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 CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlibexport TH
20、READS_FLAG=nativeexport TEMP=/tmpexport TMPDIR=/tmpexport PS1=hostname:$PWD$2.5. 安装前的检查1） 额外的检查#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 Automatic Storage Management (Oracle ASM) files and
21、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确保系统有默认网关2.6. 两个用户配置SSHGrid ingrastrue会自动配置两节点的SSH，不过在实际安装中，可能会碰到不能自动安装的情况，我们能够通过手工安装处理这一咨询题配置SSH的对等性在所有节点配置SSH的对等性在安装Oracle Real Application clusters之前,必须先配置所有节点的S
22、SH对等性。由于在安装过程种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 location for the key file. Enter and confirm a
23、 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. phrase密码处直截了当回车即可5. 以oracle用户身份，在所有节点创立autho
24、rized_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提示输入输入密码时，保持为空回车即可，使用空密码操作简单一些。以下只在 hisdb1 上执行$ touch /.ssh/authorized
25、_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 节点都执行下面的命令，来验证等效性是否正确6.以oracle用户身份，运转Oracle Universal Installer
26、的节点上执行如下命令，然后测试ssh的对等性。# exec /usr/bin/ssh-agent $SHELL节点1# ssh hisdb1 date# ssh hisdb2 date节点2# ssh hisdb2 date# ssh hisdb1 date假如都不需要密码，得到时间后。就说明ssh对等性配置成功。3. 安装Oracel Grid Infrastrue#su gridBourne or Korn shell:$ DISPLAY=local_host:0.0 ; export DISPLAYC shell:% setenv DISPLAY local_host:0.0安装选项：安
27、装类型选择：选择语言：配置SCAN：配置Cluster节点信息：配置SSH选择特定的网络接口：存储选择：创立ASM 磁盘组：特定的治理组：密码：选择安装位置：选择特定的OraInventory：执行预安装检查：安装汇总：按提示执行脚步： 两台效劳器分别运转root.sh/oracle/app/oraInventory/orainstRoot.shChanging permissions of /oracle/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissio
28、ns 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= grid ORACLE_HOME= /oracle/app/grid/pro
29、duct/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 to the /etc/oratab file as needed byDatab
30、ase 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 18:04:35 CLSRSC-4001: Installing Oracle T
31、race 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 modeOLR initialization
32、 - successful root wallet root wallet cert root cert export peer wallet profile reader wallet pa wallet peer wallet keys pa wallet keys peer cert request pa cert request peer cert pa cert peer root cert TP profile reader root cert TP pa root cert TP peer pa cert TP pa peer cert TP profile reader pa
33、cert TP profile reader peer cert TP peer user cert pa user cert2015/11/09 18:08:18 CLSRSC-330: Adding Clusterware entries to file /etc/inittabCRS-4133: Oracle High Availability Services has been stopped.CRS-4123: Oracle High Availability Services has been started.CRS-4133: Oracle High Availability S
34、ervices has been stopped.CRS-4123: Oracle High Availability Services has been started.CRS-2672: Attempting to start ora.evmd on hisdb1CRS-2672: Attempting to start ora.mdnsd on hisdb1CRS-2676: Start of ora.evmd on hisdb1 succeededCRS-2676: Start of ora.mdnsd on hisdb1 succeededCRS-2672: Attempting t
35、o start ora.gpnpd on hisdb1CRS-2676: Start of ora.gpnpd on hisdb1 succeededCRS-2672: Attempting to start ora.cssdmonitor on hisdb1CRS-2672: Attempting to start ora.gipcd on hisdb1CRS-2676: Start of ora.cssdmonitor on hisdb1 succeededCRS-2676: Start of ora.gipcd on hisdb1 succeededCRS-2672: Attemptin
36、g to start ora.cssd on hisdb1CRS-2672: Attempting to start ora.diskmon on hisdb1CRS-2676: Start of ora.diskmon on hisdb1 succeededCRS-2676: Start of ora.cssd on hisdb1 succeededASM created and started successfully.Disk Group crs created successfully.CRS-2672: Attempting to start ora.crf on hisdb1CRS
37、-2672: Attempting to start ora.storage on hisdb1CRS-2676: Start of ora.storage on hisdb1 succeededCRS-2676: Start of ora.crf on hisdb1 succeededCRS-2672: Attempting to start ora.crsd on hisdb1CRS-2676: Start of ora.crsd on hisdb1 succeededCRS-4256: Updating the profileSuccessful addition of voting d
38、isk 0561c51d65264f4dbf9229d3a6245172.Successful addition of voting disk b5d1f1c029154f96bf32985bf0b6e231.Successful addition of voting disk 5021e253d6654f6ebf4c39f4f462a31f.Successfully replaced voting disk group with +crs.CRS-4256: Updating the profileCRS-4266: Voting file(s) successfully replaced#
39、 STATE File Universal Id File Name Disk group- - - - - 1. ONLINE 0561c51d65264f4dbf9229d3a6245172 (/dev/rhdisk1) CRS 2. ONLINE b5d1f1c029154f96bf32985bf0b6e231 (/dev/rhdisk2) CRS 3. ONLINE 5021e253d6654f6ebf4c39f4f462a31f (/dev/rhdisk3) CRSLocated 3 voting disk(s).CRS-2791: Starting shutdown of Orac
40、le High Availability Services-managed resources on hisdb1CRS-2673: Attempting to stop ora.crsd on hisdb1CRS-2677: Stop of ora.crsd on hisdb1 succeededCRS-2673: Attempting to stop ora.storage on hisdb1CRS-2673: Attempting to stop ora.mdnsd on hisdb1CRS-2673: Attempting to stop ora.gpnpd on hisdb1CRS-
41、2673: Attempting to stop ora.drivers.acfs on hisdb1CRS-2677: Stop of ora.storage on hisdb1 succeededCRS-2673: Attempting to stop ora.crf on hisdb1CRS-2673: Attempting to stop ora.ctssd on hisdb1CRS-2673: Attempting to stop ora.evmd on hisdb1CRS-2673: Attempting to stop ora.asm on hisdb1CRS-2677: Sto
42、p of ora.drivers.acfs on hisdb1 succeededCRS-2677: Stop of ora.mdnsd on hisdb1 succeededCRS-2677: Stop of ora.gpnpd on hisdb1 succeededCRS-2677: Stop of ora.crf on hisdb1 succeededCRS-2677: Stop of ora.ctssd on hisdb1 succeededCRS-2677: Stop of ora.evmd on hisdb1 succeededCRS-2677: Stop of ora.asm o
43、n hisdb1 succeededCRS-2673: Attempting to stop ora.cluster_interconnect.haip on hisdb1CRS-2677: Stop of ora.cluster_interconnect.haip on hisdb1 succeededCRS-2673: Attempting to stop ora.cssd on hisdb1CRS-2677: Stop of ora.cssd on hisdb1 succeededCRS-2673: Attempting to stop ora.gipcd on hisdb1CRS-2677: Stop of ora.gipcd on hisdb1 succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on hisdb1 has completedCRS-4133: Oracle High Availability Services has been stopped.CRS-4123: Starting Oracle H