HIS系统项目ORACLE12CRAC实施报告.docx
《HIS系统项目ORACLE12CRAC实施报告.docx》由会员分享,可在线阅读,更多相关《HIS系统项目ORACLE12CRAC实施报告.docx(48页珍藏版)》请在冰豆网上搜索。
HIS系统项目ORACLE12CRAC实施报告
HIS系统项目ORACLE12CRAC实施报告
系统环境
硬件:
P824SanSwitch各两台,3PAR储备;
软件:
Oracle12C
安装规划:
1.1系统集成前规划
机号
机型
主机名
实例名
网卡
IP
系统
1
HISDB1
Hisdb_1
Eth0
192.168.0.11
AIX7.1
OracleCluster
OracleSoft
VIP
192.168.0.16
Eth1(心跳)
200.100.100.1
2
HISDB2
Hisdb_1
Eth0
192.168.0.12
AIX7.1
OracleCluster
OracleSoft
VIP
192.168.0.17
Eth1(心跳)
200.100.100.2
SCANIP
192.168.0.18~20
它其设置
网关gateway
192.168.0.201
子网掩码netmask
255.255.255.0
DNS
1.2.储备的划分
ORACLE空间储备柜划分
储备柜
整列
RAID
LUN
容量
文件格式
用途
1
Array1
10
1
10G
ASM
OCR/VotingDisk
2
10G
ASM
OCR/VotingDisk
3
10G
ASM
OCR/VotingDisk
4
1TB
ASM
ASMDisk
5
1TB
ASM
ASMDisk
6
1TB
ASM
ASMDisk
7
1TB
ASM
ASMDisk
8
300GB
ASM
ORACLEArchielog
9
300gb
ASM
ORACLEArchielog
安装前的预备
系统补丁
补丁列表如下:
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.proctools
rsct.basic.rte
检查补丁文件。
修改系统参数
VMO
vmo-p-ominperm%=3
vmo-p-omaxperm%=90
vmo-p-omaxclient%=90
vmo-p-olru_file_repage=0
vmo-p-ostrict_maxclient=1
vmo-p-ostrict_maxperm=0
ConfigureNetworkTuningParameters
no-p-oudp_sendspace=65536
no-p-oudp_recvspace=262144
no-p-otcp_sendspace=262144
no-p-otcp_recvspace=262144
no-p-orfc1323=1
no-p-osb_max=2*655360
no-r-oipqmaxlen=512
修改磁盘属性
chowngrid:
asmadmin/dev/rhdisk1
chowngrid:
asmadmin/dev/rhdisk2
chowngrid:
asmadmin/dev/rhdisk3
chowngrid:
asmadmin/dev/rhdisk4
chowngrid:
asmadmin/dev/rhdisk5
chowngrid:
asmadmin/dev/rhdisk6
chowngrid:
asmadmin/dev/rhdisk7
chowngrid:
asmadmin/dev/rhdisk8
chowngrid:
asmadmin/dev/rhdisk9
chmod660/dev/rhdisk1
chmod660/dev/rhdisk2
chmod660/dev/rhdisk3
chmod660/dev/rhdisk4
chmod660/dev/rhdisk5
chmod660/dev/rhdisk6
chmod660/dev/rhdisk7
chmod660/dev/rhdisk8
chmod660/dev/rhdisk9
chdev-lhdisk1-areserve_policy=no_reserve
chdev-lhdisk2-areserve_policy=no_reserve
chdev-lhdisk3-areserve_policy=no_reserve
chdev-lhdisk4-areserve_policy=no_reserve
chdev-lhdisk5-areserve_policy=no_reserve
chdev-lhdisk6-areserve_policy=no_reserve
chdev-lhdisk7-areserve_policy=no_reserve
chdev-lhdisk8-areserve_policy=no_reserve
chdev-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
系统连接数
smittychgsys
MaximumnumberofPROCESSESallowedperuser[16384]
换页空间
Smittychps增加换页空间
修改/etc/hosts
修改/etc/hosts
192.168.0.11hisdb1
192.168.0.16hisdb1vip
192.168.0.12hisdb2
200.100.100.2hisdb2priv
192.168.0.17hisdb2vip
200.100.100.1hisdb1priv
配置NTP
#vi/etc/ntp.conf
#broadcastclient
server172.16.10.15
driftfile/etc/ntp.drift
tracefile/etc/ntp.trace
启动xntpd守护进程
#startsrc-sxntpd
xntpd状态查询,使用#lssrc-lsxntpd
刚启动xntpd时,syspeer为'insane',表明xntpd还没有完成同步
启动xntpd守护进程
#startsrc-sxntpd
xntpd状态查询,使用#lssrc-lsxntpd
创建用户和组
创建用户及相应的名目
创建组
mkgroup-'A'id='1000'adms='root'oinstall
mkgroup-'A'id='1100'adms='root'asmadmin
mkgroup-'A'id='1200'adms='root'dba
mkgroup-'A'id='1201'adms='root'oper
mkgroup-'A'id='1300'adms='root'asmdba
mkgroup-'A'id='1301'adms='root'asmoper
创建用户
mkuserid='1100'pgrp='oinstall'groups='asmadmin,asmdba,asmoper'home='/home/grid'grid
mkuserid='1101'pgrp='oinstall'groups='dba,asmdba'home='/home/oracle'oracle
chusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATEgrid
chusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATEoracle
修改两用户权限
default:
fsize=-1
core=2097151
cpu=-1
data=-1
rss=-1
stack=-1
nofiles=-1
2)配置GRID用户环境变量
#su–grid
exportORACLE_BASE=/oracle/app/oracle
exportORACLE_HOME=/oracle/app/grid/product/12.1.0
exportORACLE_SID=+ASM1
exportNLS_LANG=AMERICAN_AMERICA.AL32UTF8
exportNLS_DATE_FORMAT="yyyy-mm-ddhh24:
mi:
ss"
exportPATH=.:
${PATH}:
$HOME/bin:
$ORACLE_HOME/bin
exportPATH=${PATH}:
/usr/bin:
/bin:
/usr/bin/X11:
/usr/local/bin
exportPATH=${PATH}:
$ORACLE_BASE/common/oracle/bin
exportORACLE_PATH=${PATH}:
$ORACLE_BASE/common/oracle/sql:
.:
$ORACLE_HOME/rdbms/admin
exportORACLE_TERM=xterm
exportTNS_ADMIN=$ORACLE_HOME/network/admin
exportORA_NLS10=$ORACLE_HOME/nls/data
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib
exportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
$ORACLE_HOME/oracm/lib
exportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
/lib:
/usr/lib:
/usr/local/lib
exportCLASSPATH=$ORACLE_HOME/JRE
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/jlib
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/rdbms/jlib
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/network/jlib
exportTHREADS_FLAG=native
exportTEMP=/tmp
exportTMPDIR=/tmp
exportPS1=`hostname`:
'$PWD'"$"
3)配置Oracle用户环境变量;
#su–oracle
#more.profile(oracle环境变量)
exportORACLE_BASE=/oracle/app/oracle
exportORACLE_HOME=$ORACLE_BASE/product/12.1.0
exportORACLE_SID=020db1
exportORACLE_UNQNAME=testdb
exportNLS_LANG=AMERICAN_AMERICA.UTF8
exportNLS_DATE_FORMAT="yyyy-mm-ddhh24:
mi:
ss"
exportPATH=.:
${PATH}:
$HOME/bin:
$ORACLE_HOME/bin
exportPATH=${PATH}:
/usr/bin:
/bin:
/usr/bin/X11:
/usr/local/bin
exportPATH=${PATH}:
$ORACLE_BASE/common/oracle/bin
exportORACLE_PATH=${PATH}:
$ORACLE_BASE/common/oracle/sql:
.:
$ORACLE_HOME/rdbms/admin
exportORACLE_TERM=xterm
exportTNS_ADMIN=$ORACLE_HOME/network/admin
#exportORA_NLS10=$ORACLE_HOME/nls/data
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib
exportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
$ORACLE_HOME/oracm/lib
exportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:
/lib:
/usr/lib:
/usr/local/lib
exportCLASSPATH=$ORACLE_HOME/JRE
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/jlib
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/rdbms/jlib
exportCLASSPATH=${CLASSPATH}:
$ORACLE_HOME/network/jlib
exportTHREADS_FLAG=native
exportTEMP=/tmp
exportTMPDIR=/tmp
exportPS1=`hostname`:
'$PWD'"$"
安装前的检查
额外的检查
#bdf/home/grid
Ensureyouhaveatleast4.5GBofspaceforthegridinfrastructureforaclusterhome(Gridhome)ThisincludesOracleClusterwareandAutomaticStorageManagement(OracleASM)filesandlogfiles.
Grid存放空间大于10GB,oracle存放空间大于8GB
#/bdf/tmp(大于1G的TEMP空间)
Ensurethatyouhaveatleast1GBofspacein/tmp
#adddefaultgateway
确保系统有默认网关
两个用户配置SSH
Gridingrastrue会自动配置两节点的SSH,只是在实际安装中,可能会碰到不能自动安装的情形,我们能够通过手工安装解决这一咨询题
配置SSH的对等性
在所有节点配置SSH的对等性
在安装OracleRealApplicationclusters之前,必须先配置所有节点的SSH对等性。
因为在安装过程种OracleUniversalInstaller使用ssh和scp命令执行远程命令执行及copy的工作。
下面是具体的步骤:
以下步骤在所有节点上执行:
1.以oracle用户登陆
#su–oracle
2.在两个节点的oracle主名目分别创建.ssh名目,并给予权限。
#mkdir~/.ssh
#chmod755~/.ssh
3.在两个节点分别生成RSAkey
#/usr/bin/ssh-keygen-trsa
会显现如下提示:
■Acceptthedefaultlocationforthekeyfile.
■Enterandconfirmapassphrasethatisdifferentfromtheoracleuser’spassword.phrase
密码处直截了当回车即可
4.生成DSAkey
#/usr/bin/ssh-keygen-tdsa
显现如下提示:
■Acceptthedefaultlocationforthekeyfile.
■Enterandconfirmapassphrasethatisdifferentfromtheoracleuser’spassword.phrase
密码处直截了当回车即可
5.以oracle用户身份,在所有节点创建authorized_keys文件,并给予权限
#touch~/.ssh/authorized_keys
#cd~/.ssh
#ls
你应该能够看到你所创建的id_dsa.pub和id_rsa.pub和authorized_keys
6.在两个节点分别将id_dsa.pub和id_rsa.pub加入到authorized_keys
#su–grid
$mkdir-p~/.ssh
$chmod700~/.ssh
$/usr/bin/ssh-keygen-trsa
提示输入输入密码时,保持为空回车即可,使用空密码操作简单一些。
以下只在hisdb1上执行
$touch~/.ssh/authorized_keys
$sshhisdb2cat~/.ssh/id_rsa.pub>>~/.ssh/authorized_keys
$sshhisdb1cat~/.ssh/id_rsa.pub>>~/.ssh/authorized_keys
$scp~/.ssh/authorized_keyshisdb1:
.ssh/authorized_keys
以下只在2个节点上执行:
$chmod600~/.ssh/authorized_keys
当用户等效性建立完毕后,在两个RAC节点都执行下面的命令,来验证等
效性是否正确
6.以oracle用户身份,运行OracleUniversalInstaller的节点上执行如下命令,然后测试ssh的对等性。
#exec/usr/bin/ssh-agent$SHELL
节点1
#sshhisdb1date
#sshhisdb2date
节点2
#sshhisdb2date
#sshhisdb1date
如果都不需要密码,得到时刻后。
就讲明ssh对等性配置成功。
安装OracelGridInfrastrue
#su–grid
BourneorKornshell:
$DISPLAY=local_host:
0.0;exportDISPLAY
Cshell:
%setenvDISPLAYlocal_host:
0.0
安装选项:
安装类型选择:
选择语言:
配置SCAN:
配置Cluster节点信息:
配置SSH
选择特定的网络接口:
储备选择:
创建ASM磁盘组:
特定的治理组:
密码:
选择安装位置:
选择特定的OraInventory:
执行预安装检查:
安装汇总:
按提示执行脚步:
两台服务器分别运行root.sh
/oracle/app/oraInventory/orainstRoot.sh
Changingpermissionsof/oracle/app/oraInventory.
Addingread,writepermissionsforgroup.
Removingread,write,executepermissionsforworld.
Changinggroupnameof/oracle/app/oraInventorytooinstall.
Theexecutionofthescriptiscomplete.
#hostname
hisdb1
#/oracle/app/grid/product/12.1.0/root.sh
Performingrootuseroperation.
Thefollowingenvironmentvariablesaresetas:
ORACLE_OWNER=grid
ORACLE_HOME=/oracle/app/grid/product/12.1.0
Enterthefullpathnameofthelocalbindirectory:
[/usr/local/bin]:
Thecontentsof"dbhome"havenotchanged.Noneedtooverwrite.
Copyingoraenvto/usr/local/bin...
Copyingcoraenvto/usr/local/bin...
Creating/etc/oratabfile...
Entrieswillbeaddedtothe/etc/oratabfileasneededby
DatabaseConfigurationAssistantwhenadatabaseiscreated
Finishedrunninggenericpartofrootscript.
Nowproduct-specificrootactionswillbeperformed.
Usingconfigurationparameterfile:
/oracle/app/grid/product/12.1.0/crs/install/crsconfig_params
2015/11/0918:
04:
35CLSRSC-4001:
InstallingOracleTraceFileAnalyzer(TFA)Collector.
2015/11/0918:
05:
43CLSRSC-4002:
SuccessfullyinstalledOracleTraceFileAnalyzer(TFA)Collector.
2015/11/0918:
05:
45CLSRSC-363:
Userignoredprerequisitesduringinstallation
UsergridhastherequiredcapabilitiestorunCSSDinrealtime