oracle 12c r2 RAC配置手册.docx
- 文档编号:23529599
- 上传时间:2023-05-18
- 格式:DOCX
- 页数:55
- 大小:1.70MB
oracle 12c r2 RAC配置手册.docx
《oracle 12c r2 RAC配置手册.docx》由会员分享,可在线阅读,更多相关《oracle 12c r2 RAC配置手册.docx(55页珍藏版)》请在冰豆网上搜索。
oracle12cr2RAC配置手册
ORACLE12CR2RealApplicationClusterInstallationGuide
朱海清
StarTimesSoftwareTechnologyCo.,Ltd
ASM磁盘空间最低要求
12CR2相比前一版本,OCR的磁盘占用需求有了明显增长。
为了方便操作,设置如下:
External:
1个卷x40G
Normal:
3个卷x30G
Hight:
5个卷x25G
Flex:
3个卷x30G
OCR+VOLTING+MGMT存储通常放到一个磁盘组,且选择Normal的冗余方式,也即最少3块asm磁盘80G空间。
操作系统安装
操作系统安装时把“ServerwithGUI“和”CompatibilityLibraries”勾上,其他都不用选择。
版本采用CentOS7、RHEL7或者OracleLinux7
安装oracle预安装包
yuminstall-yoracle-rdbms-server-12cR1-preinstall
创建用户和组
oracle用户和dba、oinstall组已经在上一步创建完毕。
rac所有节点的oracle用户和grid用户的uid和gid必须一致,所以创建的时候最好制定uid和gid。
groupadd--gid54323asmdba
groupadd--gid54324asmoper
groupadd--gid54325asmadmin
groupadd--gid54326oper
groupadd--gid54327backupdba
groupadd--gid54328dgdba
groupadd--gid54329kmdba
usermod--uid54321--gidoinstall--groupsdba,oper,asmdba,asmoper,backupdba,dgdba,kmdbaoracle
useradd--uid54322--gidoinstall--groupsdba,asmadmin,asmdba,asmopergrid
安装目录
mkdir-p/u01/app/12.2.0/grid
mkdir-p/u01/app/grid
mkdir-p/u01/app/oracle
chown-Rgrid:
oinstall/u01
chownoracle:
oinstall/u01/app/oracle
chmod-R775/u01/
用户环境变量
grid环境变量
cat<
ORACLE_SID=+ASM1
ORACLE_HOME=/u01/12.2.0/grid
PATH=$ORACLE_HOME/bin:
$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:
/lib:
/usr/lib
CLASSPATH=$ORACLE_HOME/JRE:
$ORACLE_HOME/jlib:
$ORACLE_HOME/rdbms/jlib
exportORACLE_SIDCLASSPATHORACLE_HOMELD_LIBRARY_PATHPATH
EOF
在节点2,ORACLE_SID=+ASM2
oracle环境变量
cat<
ORACLE_SID=starboss1
ORACLE_HOME=/u01/app/oracle/product/12.2.0/db_1
ORACLE_HOSTNAME=rac01
PATH=$ORACLE_HOME/bin:
$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:
/lib:
/usr/lib
CLASSPATH=$ORACLE_HOME/JRE:
$ORACLE_HOME/jlib:
$ORACLE_HOME/rdbms/jlib
exportORACLE_SIDORACLE_HOMEORACLE_HOSTNAMEPATHLD_LIBRARY_PATHCLASSPATH
EOF
在节点2,ORACLE_SID=starboss2,ORACLE_HOSTNAME=rac02
修改logind.conf
#vi/etc/systemd/logind.conf
RemoveIPC=no
#systemctldaemon-reload
#systemctlrestartsystemcd-logind
加载pam_limits.so模块
echo"sessionrequiredpam_limits.so">>/etc/pam.d/login
禁用selinux
setenforce0
vi/etc/sysconfig/selinux
禁用防火墙
#systemctlstopfirewalld&&systemctldisablefirewalld
修改ulimit
cat<
oraclesoftnproc16384
oraclehardnproc16384
oraclesoftnofile1024
oraclehardnofile65536
oraclesoftstack10240
oraclehardstack32768
gridsoftnproc16384
gridhardnproc16384
gridsoftnofile1024
gridhardnofile65536
gridsoftstack10240
gridhardstack32768
EOF
创建自定义的ulimit
cat<
if[$USER="oracle"];then
if[$SHELL="/bin/ksh"];then
ulimit-u16384
ulimit-n65536
else
ulimit-u16384-n65536
fi
fi
if[$USER="grid"];then
if[$SHELL="/bin/ksh"];then
ulimit-u16384
ulimit-n65536
else
ulimit-u16384-n65536
fi
fi
EOF
修改共享内存分区大小
将如下参数添加到/etc/fstab,具体大小数值根据实际情况调整,因为这个数值和物理内存以及MEMORY_TARGET有关。
echo“shm/dev/shmtmpfssize=12g00”>>/etc/fstab
修改后,只需重新对shm进行挂载即可:
mount-oremount/dev/shm
多路径
#yuminstalldevice-mapper-multipath
#cp/usr/share/doc/device-mapper-multipath-0.4.9/multipath.conf/etc/
获取scsiid
#/usr/lib/udev/scsi_id--whitelisted--replace-whitespace–-device=/dev/sda
#vi/etc/multipath.conf
multipaths{
multipath{
wwid36000d310012522000000000000000006
aliasvol01
}
multipath{
wwid36000d310012522000000000000000005
aliasvol02
}
}
#systemctlstartmultipathd.service
#multipath-ll
配置磁盘
ASMlib方式
安装ASMLib
OracleLinux7
yuminstall-ykmod-oracleasm
CentOS7
yuminstall-yhttp:
//mirror.centos.org/centos/7/os/x86_64/Packages/kmod-oracleasm-2.0.8-17.el7.centos.x86_64.rpm
yuminstall-y
yuminstall-yhttp:
//public-
其他版本下载:
ASM磁盘配置
12CR2中对磁盘组空间要求比12CR1更大。
[root@rac01~]#/etc/init.d/oracleasmconfigure-i
ConfiguringtheOracleASMlibrarydriver.
Thiswillconfiguretheon-bootpropertiesoftheOracleASMlibrary
driver.Thefollowingquestionswilldeterminewhetherthedriveris
loadedonbootandwhatpermissionsitwillhave.Thecurrentvalues
willbeshowninbrackets('[]').Hitting
answerwillkeepthatcurrentvalue.Ctrl-Cwillabort.
Defaultusertoownthedriverinterface[]:
grid
Defaultgrouptoownthedriverinterface[]:
asmadmin
StartOracleASMlibrarydriveronboot(y/n)[n]:
y
ScanforOracleASMdisksonboot(y/n)[y]:
y
WritingOracleASMlibrarydriverconfiguration:
done
InitializingtheOracleASMLibdriver:
[OK]
ScanningthesystemforOracleASMLibdisks:
[OK]
[root@rac01~]#reboot
用fdisk在共享磁盘上创建主分区:
[root@rac01~]#fdisk/dev/sdd
Welcometofdisk(util-linux2.23.2).
Changeswillremaininmemoryonly,untilyoudecidetowritethem.
Becarefulbeforeusingthewritecommand.
Devicedoesnotcontainarecognizedpartitiontable
BuildinganewDOSdisklabelwithdiskidentifier0x86f899a0.
Command(mforhelp):
n
Partitiontype:
pprimary(0primary,0extended,4free)
eextended
Select(defaultp):
p
Partitionnumber(1-4,default1):
Firstsector(2048-39976959,default2048):
Usingdefaultvalue2048
Lastsector,+sectorsor+size{K,M,G}(2048-39976959,default39976959):
Usingdefaultvalue39976959
Partition1oftypeLinuxandofsize19.1GiBisset
Command(mforhelp):
w
Thepartitiontablehasbeenaltered!
Callingioctl()tore-readpartitiontable.
Syncingdisks.
在集群的任意节点创建asm磁盘:
[root@rac01~]#/etc/init.d/oracleasmcreatediskOCR01/dev/sdd1
Markingdisk"OCR01"asanASMdisk:
[OK]
[root@rac01~]#/etc/init.d/oracleasmcreatediskOCR02/dev/sde1
Markingdisk"OCR02"asanASMdisk:
[OK]
[root@rac01~]#/etc/init.d/oracleasmcreatediskOCR03/dev/sdf1
Markingdisk"OCR03"asanASMdisk:
[OK]
[root@rac01~]#/etc/init.d/oracleasmcreatediskDATA01/dev/sdb1
Markingdisk"DATA01"asanASMdisk:
[OK]
[root@rac01~]#/etc/init.d/oracleasmcreatediskDATA02/dev/sdc1
Markingdisk"DATA02"asanASMdisk:
[OK]
分别两个节点执行:
[root@rac01~]#/etc/init.d/oracleasmscandisks
[root@rac01~]#/etc/init.d/oracleasmlistdisks
注:
如果需要清空磁盘,重新部署asm,需要使用dd命令,如:
ddif=/dev/zeroof=/dev/sdb1bs=8192count=128000
UDEV方式
参考:
https:
//oracle-
确认在所有RAC节点上已经安装了必要的UDEV包
[root@rh2~]#rpm-qa|grepudev
udev-095-14.21.el5
CentOS6/OracleLinux6/RHEL6
1.通过scsi_id获取设备的块设备的唯一标识名,假设系统上已有LUNsdc-sdp
foriincdefghijklmnop;
do
echo"sd$i""`scsi_id-g-u-s/block/sd$i`";
done
sdc1IET_00010001
sdd1IET_00010002
sde1IET_00010003
sdf1IET_00010004
以上列出于块设备名对应的唯一标识名
2.创建必要的UDEV配置文件,
首先切换到配置文件目录
[root@rh2~]#cd/etc/udev/rules.d
定义必要的规则配置文件
[root@rh2rules.d]#touch99-oracle-asmdevices.rules
[root@rh2rules.d]#cat99-oracle-asmdevices.rules
KERNEL=="sd*",BUS=="scsi",PROGRAM=="/sbin/scsi_id-g-u-s%p",RESULT=="1IET_00010001",NAME="ocr1",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="sd*",BUS=="scsi",PROGRAM=="/sbin/scsi_id-g-u-s%p",RESULT=="1IET_00010002",NAME="ocr2",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="sd*",BUS=="scsi",PROGRAM=="/sbin/scsi_id-g-u-s%p",RESULT=="1IET_00010003",NAME="asm-disk1",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="sd*",BUS=="scsi",PROGRAM=="/sbin/scsi_id-g-u-s%p",RESULT=="1IET_00010004",NAME="asm-disk2",OWNER="grid",GROUP="asmadmin",MODE="0660"
Result为/sbin/scsi_id-g-u-s%p的输出,按顺序填入刚才获取的唯一标识名即可
OWNER一般为grid,GROUP为asmadmin,MODE即为磁盘读写权限,采用0660即可
NAME为UDEV映射后的设备名,
建议为OCR和VOTEDISK创建独立的DISKGROUP,为了容易区分将该DISKGROUP专用的设备命名为ocr1..ocrn的形式
其余磁盘可以根据其实际用途或磁盘组名来命名
3.将该规则文件拷贝到其他节点上
[root@rh2rules.d]#scp99-oracle-asmdevices.rulesOther_node:
/etc/udev/rules.d
4.在所有节点上启动udev服务,或者重启服务器即可
[root@rh2rules.d]#/sbin/udevcontrolreload_rules
[root@rh2rules.d]#/sbin/start_udev
Startingudev:
[OK]
5.检查设备是否到位
[root@rh2rules.d]#cd/dev
[root@rh2dev]#ls-locr*
brw-rw----1gridasmadmin8,32Jul1017:
31ocr1
brw-rw----1gridasmadmin8,48Jul1017:
31ocr2
[root@rh2dev]#ls-lasm-disk*
brw-rw----1gridasmadmin8,64Jul1017:
31asm-disk1
brw-rw----1gridasmadmin8,80Jul1017:
31asm-disk2
brw-rw----1gridasmadmin8,96Jul1017:
31asm-disk3
brw-rw----1gridasmadmin8,112Jul1017:
31asm-disk4
CentOS7/OracleLinux7/RHEL7
获取块设备id
#/usr/lib/udev/scsi_id-g-u-d/dev/sdb1
14f504e46494c45526a75744363422d796357662d4b436a65
#/usr/lib/udev/scsi_id-g-u-d/dev/sdc1
14f504e46494c455254535a7a414d2d62494b6f2d5a6f6a42
#/usr/lib/udev/scsi_id-g-u-d/dev/sdd1
14f504e46494c45526566324e626c2d4770654c2d6b443064
#/usr/lib/udev/scsi_id-g-u-d/dev/sde1
14f504e46494c455266326e7547552d384953442d6135576a
#/usr/lib/udev/scsi_id-g-u-d/dev/sdf1
14f504e46494c4552774263526f742d534a75392d36374f69
创建参数文件
touch/etc/scsi_id.config
options=-g
#cat/etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd?
1",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id-g-u-d/dev/$parent",RESULT=="14f504e46494c45526a75744363422d796357662d4b436a65",SYMLINK+="asm-disk1",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="sd?
1",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id-g-u-d/dev/$parent",RESULT=="14f504e46494c455254535a7a414d2d62494b6f2d5a6f6a42",SYMLINK+="asm-disk2",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="sd?
1",SUBSYSTEM=="block",PROGRAM=="/usr/lib/udev/scsi_id-g-u-d/dev/$parent",RESULT=="14f504e46494c45526566324e626c2d4770654c2d6b443064",SYMLINK+="asm-disk3",
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- oracle 12c r2 RAC配置手册 12 RAC 配置 手册