{"id":1256,"date":"2016-07-18T09:09:25","date_gmt":"2016-07-18T01:09:25","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=1256"},"modified":"2016-07-18T09:09:25","modified_gmt":"2016-07-18T01:09:25","slug":"%e5%9c%a8virtualbox%e4%b8%ad%e5%ae%89%e8%a3%85oracle-12c-rac","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=1256","title":{"rendered":"\u5728VirtualBox\u4e2d\u5b89\u88c5Oracle 12c RAC"},"content":{"rendered":"
1.\u5b9e\u9a8c\u73af\u5883:<\/div>\n
\u00a0 \u00a0 1.OS:Oracle Linux Server release 6.6;<\/div>\n
\u00a0 \u00a0 2.Oracle:12.1.0.2.0;<\/div>\n
\u00a0 \u00a0 3.Node1:<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.hostname:node1.oracle.com;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 2.public ip:192.168.10.170(eth0);<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 3.private ip:191.168.20.170(eth1);<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 4.virtual ip:192.168.10.173;<\/div>\n
\u00a0 \u00a0 4.Node2:<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.hostname:node2.oracle.com;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 2.public ip:192.168.10.171(eth0);<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 3.private ip:191.168.20.171(eth1);<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 4.virtual ip:192.168.10.174;<\/div>\n
\u00a0 \u00a0 5.SCAN IP:192.168.10.177\/192.168.10.178\/192.168.10.179;<\/div>\n
2.\u914d\u7f6e\u7f51\u7edc\u73af\u5883,\u5b89\u88c5\u8f6f\u4ef6\u5305\u5e76\u8c03\u6574\u670d\u52a1\u5668\u7684\u65f6\u95f4\u548c\u53c2\u6570:<\/div>\n
\u00a0 \u00a0 1.\u8bbe\u7f6e\u670d\u52a1\u5668\u540d:hostname;<\/div>\n
\u00a0 \u00a0 2.\u4fee\u6539\/etc\/hosts,\/etc\/sysconfig\/network;<\/div>\n
\u00a0 \u00a0 3.\u4f7f\u7528ntp\u670d\u52a1\u5668\u4fdd\u6301\u65f6\u95f4\u540c\u6b65;<\/div>\n
\u00a0 \u00a0 4.\u8bbe\u7f6eIP\u5730\u5740;<\/div>\n
\u00a0 \u00a0 5.\u914d\u7f6eDNS\u670d\u52a1\u5668,\u5e76\u4fee\u6539\/etc\/resolv.conf\u914d\u7f6e\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 6.\u5b89\u88c5\u8f6f\u4ef6\u5305:yum -y install binutils* compat-lib* gcc* glibc* ksh make* sysstat* unixODBC* libgcc* libstdc++* libaio* libXext* libXtst* libX11* libXau* libxcb* libXi*;<\/div>\n
\u00a0 \u00a0 7.\u5206\u522b\u4fee\u6539\/etc\/sysctl.conf\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 8.\u5206\u522b\u4fee\u6539\/etc\/security\/limits.conf\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 9.\u4fee\u6539\/etc\/pam.d\/login\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 10.\u521b\u5efagrid\u548coracle\u7528\u6237\u53ca\u6dfb\u52a0\u76f8\u5e94\u7684\u73af\u5883\u53d8\u91cf;<\/div>\n
\u00a0 \u00a0 11.\u5173\u95ed\u9632\u706b\u5899\u548cSELinux;<\/div>\n
3.\u4f7f\u7528udev\u521b\u5efa\u5171\u4eab\u78c1\u76d8;<\/div>\n
4.\u5b89\u88c5GI;<\/div>\n
\u00a0 \u00a0 1.\u89e3\u538b\u8f6f\u4ef6;<\/div>\n
\u00a0 \u00a0 2.\u5b89\u88c5cvu\u76f8\u5173rpm\u5305:rpm -ivh \/tools\/grid\/rpm\/cvuqdisk-1.0.9-1.rpm;<\/div>\n
\u00a0 \u00a0 3.\u5b89\u88c5\u524d\u6821\u9a8c:\/tools\/grid\/runcluvfy.sh stage -pre crsinst -n node1,node2 -verbose;<\/div>\n
\u00a0 \u00a0 4.\u6700\u540e\u68c0\u67e5\u8d44\u6e90\u72b6\u6001:crsctl stat res -t;<\/div>\n
5.\u4f7f\u7528asmca\u547d\u4ee4\u521b\u5efa\u78c1\u76d8\u7ec4;<\/div>\n
\u00a0 \u00a0 1.\u521b\u5efaGI\u7684\u65f6\u5019\u5df2\u7ecf\u521b\u5efa\u4e86CRS\u78c1\u76d8\u7ec4;<\/div>\n
\u00a0 \u00a0 2.\u521b\u5efaDATA\u78c1\u76d8\u7ec4;<\/div>\n
\u00a0 \u00a0 3.\u521b\u5efaFRA\u78c1\u76d8\u7ec4;<\/div>\n
6.\u5b89\u88c5\u6570\u636e\u5e93\u8f6f\u4ef6;<\/div>\n
7.\u5b89\u88c5\u6570\u636e\u5e93;<\/div>\n
\u00a0 \u00a0 1.\u67e5\u770b\u8d44\u6e90\u72b6\u6001:crsctl stat res -t;<\/div>\n
\u00a0 \u00a0 2.\u67e5\u770bRAC\u6570\u636e\u5e93\u914d\u7f6e\u4fe1\u606f:srvctl config database -d ORCL\/srvctl status database -d ORCL\/srvctl status listener;<\/div>\n
<\/div>\n
———————– \u7f51\u7edc\u914d\u7f6e ———————–<\/div>\n
— \u4fee\u6539\u4e3b\u673a\u540d;<\/div>\n
hostname node1.oracle.com<\/div>\n
hostname node2.oracle.com<\/div>\n
<\/div>\n
— \u4fee\u6539\/etc\/hosts;<\/div>\n
127.0.0.1\u00a0 \u00a0localhost localhost.localdomain localhost4 localhost4.localdomain4<\/div>\n
::1\u00a0 \u00a0 \u00a0 \u00a0 \u00a0localhost localhost.localdomain localhost6 localhost6.localdomain6<\/div>\n
<\/div>\n
# Public IP<\/div>\n
192.168.10.170\u00a0 node1.oracle.com\u00a0 \u00a0 \u00a0 \u00a0 node1<\/div>\n
192.168.10.171\u00a0 node2.oracle.com\u00a0 \u00a0 \u00a0 \u00a0 node2<\/div>\n
<\/div>\n
# Private IP<\/div>\n
192.168.20.170\u00a0 node1-pri.oracle.com\u00a0 \u00a0 node1-pri<\/div>\n
192.168.20.171\u00a0 node2-pri.oracle.com\u00a0 \u00a0 node2-pri<\/div>\n
<\/div>\n
# VIP<\/div>\n
192.168.10.172\u00a0 node1-vip.oracle.com\u00a0 \u00a0 node1-vip<\/div>\n
192.168.10.173\u00a0 node2-vip.oracle.com\u00a0 \u00a0 node2-vip<\/div>\n
<\/div>\n
# Scan IP<\/div>\n
192.168.10.177\u00a0 rac-cluster-scan.oracle.com\u00a0 \u00a0 \u00a0 \u00a0 \u00a0rac-cluster-scan<\/div>\n
#192.168.10.178 rac-cluster-scan.oracle.com\u00a0 \u00a0 \u00a0 \u00a0 \u00a0rac-cluster-scan<\/div>\n
#192.168.10.179 rac-cluster-scan.oracle.com\u00a0 \u00a0 \u00a0 \u00a0 \u00a0rac-cluster-scan<\/div>\n
<\/div>\n
# DNS Server<\/div>\n
#192.168.10.180 rac-dns.oracle.com\u00a0 \u00a0 \u00a0 rac-dns<\/div>\n
<\/div>\n
— \u4fee\u6539\/etc\/sysconfig\/network;<\/div>\n
HOSTNAME=node1.oracle.com<\/div>\n
HOSTNAME=node2.oracle.com<\/div>\n
———————– \u7f51\u7edc\u914d\u7f6e ———————–<\/div>\n
<\/div>\n
———————– \u7cfb\u7edf\u53c2\u6570 ———————–<\/div>\n
— \u4fee\u6539\/etc\/sysctl.conf\u6587\u4ef6;<\/div>\n
fs.file-max = 6815744<\/div>\n
kernel.sem = 250 32000 100 128<\/div>\n
kernel.shmmni = 4096<\/div>\n
kernel.shmall = 1073741824<\/div>\n
kernel.shmmax = 4398046511104<\/div>\n
net.core.rmem_default = 262144<\/div>\n
net.core.rmem_max = 4194304<\/div>\n
net.core.wmem_default = 262144<\/div>\n
net.core.wmem_max = 1048576<\/div>\n
fs.aio-max-nr = 1048576<\/div>\n
net.ipv4.ip_local_port_range = 9000 65500<\/div>\n
> sysctl -p;<\/div>\n
<\/div>\n
— \u4fee\u6539\/etc\/security\/limits.conf\u6587\u4ef6;<\/div>\n
grid\u00a0 \u00a0 soft\u00a0 \u00a0 nproc\u00a0 \u00a02047<\/div>\n
grid\u00a0 \u00a0 hard\u00a0 \u00a0 nproc\u00a0 \u00a016384<\/div>\n
grid\u00a0 \u00a0 soft\u00a0 \u00a0 nofile\u00a0 4096<\/div>\n
grid\u00a0 \u00a0 hard\u00a0 \u00a0 nofile\u00a0 65536<\/div>\n
oracle\u00a0 soft\u00a0 \u00a0 nproc\u00a0 \u00a02047<\/div>\n
oracle\u00a0 hard\u00a0 \u00a0 nproc\u00a0 \u00a016384<\/div>\n
oracle\u00a0 soft\u00a0 \u00a0 nofile\u00a0 4096<\/div>\n
oracle\u00a0 hard\u00a0 \u00a0 nofile\u00a0 65536<\/div>\n
<\/div>\n
— \u4fee\u6539\/etc\/pam.d\/login\u6587\u4ef6;<\/div>\n
session required \/lib\/security\/pam_limits.so<\/div>\n
session required pam_limits.so<\/div>\n
———————– \u7cfb\u7edf\u53c2\u6570 ———————–<\/div>\n
<\/div>\n
———————– \u521b\u5efa\u7528\u6237 ———————–<\/div>\n
— \u521b\u5efa\u7528\u6237\u7ec4;<\/div>\n
groupadd -g 10001 oinstall<\/div>\n
groupadd -g 10002 dba<\/div>\n
groupadd -g 10003 oper<\/div>\n
groupadd -g 10004 backupdba<\/div>\n
groupadd -g 10005 dgdba<\/div>\n
groupadd -g 10006 kmdba<\/div>\n
groupadd -g 10007 asmdba<\/div>\n
groupadd -g 10008 asmoper<\/div>\n
groupadd -g 10009 asmadmin<\/div>\n
<\/div>\n
— \u521b\u5efa\u7528\u6237;<\/div>\n
useradd -u 10000 -g oinstall -G dba,oper,asmdba,backupdba,dgdba,kmdba oracle;<\/div>\n
useradd -u 10001 -g oinstall -G dba,asmdba,asmoper,asmadmin grid;<\/div>\n
<\/div>\n
— \u521b\u5efa\u8f6f\u4ef6\u76ee\u5f55;<\/div>\n
mkdir -p \/u01\/app\/grid;<\/div>\n
mkdir -p \/u01\/app\/12.1.0\/grid;<\/div>\n
mkdir -p \/u01\/app\/oracle\/product\/12.1.0\/db_1;<\/div>\n
chown -R grid:oinstall \/u01;<\/div>\n
chown -R oracle:oinstall \/u01\/app\/oracle;<\/div>\n
chmod -R 775 \/u01;<\/div>\n
<\/div>\n
— \u8bbe\u7f6egrid\u7528\u6237\u7684\u73af\u5883\u53d8\u91cf.bash_profile<\/div>\n
ORACLE_HOSTNAME=node1.oracle.com<\/div>\n
ORACLE_SID=+ASM1<\/div>\n
ORACLE_BASE=\/u01\/app\/grid<\/div>\n
ORACLE_HOME=\/u01\/app\/12.1.0\/grid<\/div>\n
PATH=$ORACLE_HOME\/bin:\/usr\/sbin:$PATH<\/div>\n
LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/usr\/lib:\/lib<\/div>\n
CLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib<\/div>\n
export ORACLE_HOSTNAME ORACLE_SID ORACLE_BASE ORACLE_HOME PATH LD_LIBRARY_PATH CLASSPATH<\/div>\n
alias sqlplus=’rlwrap sqlplus’<\/div>\n
<\/div>\n
— \u8bbe\u7f6eoracle\u7528\u6237\u7684\u73af\u5883\u53d8\u91cf.bash_profile<\/div>\n
ORACLE_HOSTNAME=node1.oracle.com<\/div>\n
ORACLE_SID=ORCL1<\/div>\n
ORACLE_UNQNAME=ORCL<\/div>\n
ORACLE_BASE=\/u01\/app\/oracle<\/div>\n
ORACLE_HOME=$ORACLE_BASE\/product\/12.1.0\/db_1<\/div>\n
PATH=$ORACLE_HOME\/bin:\/usr\/sbin:$PATH<\/div>\n
LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib<\/div>\n
CLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib<\/div>\n
export ORACLE_HOSTNAME ORACLE_SID ORACLE_UNQNAME ORACLE_BASE ORACLE_HOME PATH LD_LIBRARY_PATH CLASSPATH<\/div>\n
alias sqlplus=’rlwrap sqlplus’<\/div>\n
———————– \u521b\u5efa\u7528\u6237 ———————–<\/div>\n
<\/div>\n
———————– \u521b\u5efa\u5171\u4eab\u78c1\u76d8 ———————–<\/div>\n
— \u5728\u4e00\u4e2a\u865a\u62df\u673a\u4e2d\u521b\u5efa[\u56fa\u5b9a\u5927\u5c0f]\u7684\u865a\u62df\u78c1\u76d8;<\/div>\n
— \u7136\u540e\u5728[\u7ba1\u7406]->[\u865a\u62df\u4ecb\u8d28\u7ba1\u7406]\u754c\u9762,\u4fee\u865a\u62df\u78c1\u76d8\u7684\u7c7b\u578b\u4e3a[\u53ef\u5171\u4eab];<\/div>\n
— \u6dfb\u52a0\u5230\u53e6\u5916\u7684\u865a\u62df\u673a\u4e2d;<\/div>\n
———————– \u521b\u5efa\u5171\u4eab\u78c1\u76d8 ———————–<\/div>\n
<\/div>\n
———————– \u4f7f\u7528udev\u914d\u7f6e\u5171\u4eab\u78c1\u76d8 ———————–<\/div>\n
— \u751f\u6210udev\u89c4\u5219\u6587\u4ef6\u7684\u811a\u672c;<\/div>\n
for i in a b c d e f g h i j k l m n o p q r s t u v w x y z<\/div>\n
do<\/div>\n
echo “KERNEL==\\”sd*\\”, BUS==\\”scsi\\”, PROGRAM==\\”\/sbin\/scsi_id –whitelisted –replace-whitespace –device=\/dev\/\\$name\\”, RESULT==\\”`\/sbin\/scsi_id –whitelisted –replace-whitespace –device=\/dev\/sd$i`\\”, NAME=\\”asm-disk$i\\”, OWNER=\\”grid\\”, GROUP=\\”asmadmin\\”, MODE=\\”0660\\””<\/div>\n
done<\/div>\n
<\/div>\n
— \u68c0\u67e5\u662f\u5426\u5b89\u88c5udev;<\/div>\n
rpm -qa | grep udev<\/div>\n
<\/div>\n
— \u6dfb\u52a0\u89c4\u5219\u6587\u4ef6vi \/etc\/udev\/rules.d\/99-oracle-asmdevices.rules;(\u5185\u5bb9\u53ef\u4ee5\u901a\u8fc7\u811a\u672c\u751f\u6210)<\/div>\n
KERNEL==”sd*”, BUS==”scsi”, PROGRAM==”\/sbin\/scsi_id –whitelisted –replace-whitespace –device=\/dev\/$name”, RESULT==”1ATA_VBOX_HARDDISK_VBab81d7dc-431ca37f”, NAME=”asm-crs”, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″<\/div>\n
KERNEL==”sd*”, BUS==”scsi”, PROGRAM==”\/sbin\/scsi_id –whitelisted –replace-whitespace –device=\/dev\/$name”, RESULT==”1ATA_VBOX_HARDDISK_VBe8fa478f-cd38bd32″, NAME=”asm-data1″, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″<\/div>\n
KERNEL==”sd*”, BUS==”scsi”, PROGRAM==”\/sbin\/scsi_id –whitelisted –replace-whitespace –device=\/dev\/$name”, RESULT==”1ATA_VBOX_HARDDISK_VB57dac3e5-ff6636ce”, NAME=”asm-data2″, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″<\/div>\n
KERNEL==”sd*”, BUS==”scsi”, PROGRAM==”\/sbin\/scsi_id –whitelisted –replace-whitespace –device=\/dev\/$name”, RESULT==”1ATA_VBOX_HARDDISK_VB04158991-1baaa75c”, NAME=”asm-data3″, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″<\/div>\n
KERNEL==”sd*”, BUS==”scsi”, PROGRAM==”\/sbin\/scsi_id –whitelisted –replace-whitespace –device=\/dev\/$name”, RESULT==”1ATA_VBOX_HARDDISK_VB389c5a94-92168d11″, NAME=”asm-fra1″, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″<\/div>\n
KERNEL==”sd*”, BUS==”scsi”, PROGRAM==”\/sbin\/scsi_id –whitelisted –replace-whitespace –device=\/dev\/$name”, RESULT==”1ATA_VBOX_HARDDISK_VBbfb07df0-3eca3187″, NAME=”asm-fra2″, OWNER=”grid”, GROUP=”asmadmin”, MODE=”0660″<\/div>\n
<\/div>\n
— \u5c06\u8be5\u89c4\u5219\u6587\u4ef6\u62f7\u8d1d\u5230\u5176\u4ed6\u8282\u70b9\u4e0a;<\/div>\n
<\/div>\n
— \u5728\u6240\u6709\u8282\u70b9\u4e0a\u542f\u52a8udev\u670d\u52a1;<\/div>\n
\/sbin\/start_udev<\/div>\n
<\/div>\n
— \u68c0\u67e5\u6587\u4ef6;<\/div>\n
ll \/dev\/<\/div>\n
———————– \u4f7f\u7528udev\u914d\u7f6e\u5171\u4eab\u78c1\u76d8 ———————–<\/div>\n
<\/div>\n
———————–\u00a0RAC\u7684\u542f\u52a8\u548c\u5173\u95ed\u987a\u5e8f ———————–<\/div>\n
1.\u5173\u95edRAC:<\/div>\n
\u00a0 \u00a0 1.\u5173\u95ed\u6570\u636e\u5e93:\u505c\u6b62\u6240\u6709\u8282\u70b9\u4e0a\u7684\u5b9e\u4f8b[oracle@node1 ~]$ srvctl stop database -d ORCL;<\/div>\n
\u00a0 \u00a0 2.\u505c\u6b62OHAS(Oracle High Availability Services):[root@node1 ~]# $GRID_HOME\/crsctl stop has -f;<\/div>\n
\u00a0 \u00a0 3.\u505c\u6b62\u96c6\u7fa4\u670d\u52a1:root@node1 ~]# $GRID_HOME\/crsctl stop cluster [-all];<\/div>\n
2.\u542f\u52a8RAC,\u9ed8\u8ba4\u5f00\u673a\u4f1a\u81ea\u542f\u52a8,\u624b\u5de5\u542f\u52a8\u7684\u987a\u5e8f\u5982\u4e0b:<\/div>\n
\u00a0 \u00a0 1.\u542f\u52a8\u96c6\u7fa4:root@node1 ~]# $GRID_HOME\/crsctl start cluster [-all];<\/div>\n
\u00a0 \u00a0 2.\u542f\u52a8OHAS:root@node1 ~]# $GRID_HOME\/crsctl start has;<\/div>\n
\u00a0 \u00a0 3.\u542f\u52a8\u6570\u636e\u5e93:[oracle@node1 ~]$ srvctl start database -d ORCL;<\/div>\n
———————–\u00a0RAC\u7684\u542f\u52a8\u548c\u5173\u95ed\u987a\u5e8f ———————–<\/div>\n","protected":false},"excerpt":{"rendered":"

1.\u5b9e\u9a8c\u73af\u5883: \u00a0 \u00a0 1.OS:Oracle Linux Server release 6.6; \u00a0 \u00a0 2 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[36,34,40],"class_list":["post-1256","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-12c","tag-oracle","tag-rac"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1256"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1256\/revisions"}],"predecessor-version":[{"id":1257,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1256\/revisions\/1257"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1256"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}