{"id":6925,"date":"2023-10-23T10:54:01","date_gmt":"2023-10-23T01:54:01","guid":{"rendered":"https:\/\/www.climb.co.jp\/blog_dbmoto\/?p=6925"},"modified":"2025-04-02T18:31:55","modified_gmt":"2025-04-02T09:31:55","slug":"oracle-rac-one-node%e7%92%b0%e5%a2%83%e3%82%92%e6%a7%8b%e6%88%90%e3%81%97%e3%81%a6%e3%81%bf%e3%81%be%e3%81%97%e3%81%9f-%e3%82%b9%e3%83%86%e3%83%83%e3%83%972-oracle-grid-infrastructure%e3%82%a4","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/6925","title":{"rendered":"Oracle RAC One Node\u74b0\u5883\u3092\u69cb\u6210\u3057\u3066\u307f\u307e\u3057\u305f \u30b9\u30c6\u30c3\u30d72 Oracle Grid Infrastructure\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u6e96\u5099"},"content":{"rendered":"\n

\u524d\u56de\u306e\u8a18\u4e8b<\/a><\/strong>\u3067\u306f\u3001Oracle RAC One node<\/strong>\u3092\u69cb\u6210\u3059\u308b\u305f\u3081\u306eOracle Linux\u306e\u5c0e\u5165\u307e\u3067\u3092\u884c\u3044\u307e\u3057\u305f\u3002\u4eca\u56de\u306fOracle Linux\u306bOracle Grid Infrastructure<\/strong>\u3084Oracle DB<\/strong>\u3092\u5c0e\u5165\u3059\u308b\u305f\u3081\u306e\u6e96\u5099\u3092\u884c\u3063\u3066\u3044\u304d\u307e\u3059\u3002
\u203b\u6700\u5f8c\u306e\u74b0\u5883\u5909\u6570\u306e\u4f5c\u6210\u4ee5\u5916\u306f\u3001root\u30e6\u30fc\u30b6\u3067\u4f5c\u696d\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc
\u25bdOracle RAC One node\u69cb\u6210\u95a2\u9023\u30d6\u30ed\u30b0<\/strong>
\u3000\u30b9\u30c6\u30c3\u30d7\uff11\uff1aOracle Linux\u74b0\u5883\u306e\u5c0e\u5165<\/a><\/strong>
\u3000\u30b9\u30c6\u30c3\u30d7\uff12\uff1aOracle Grid Infrastructure\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u6e96\u5099 \u2190 \u4eca\u56de\u306e\u8a18\u4e8b
\u3000\u30b9\u30c6\u30c3\u30d7\uff13\uff1a\u5225Oracle\u30ce\u30fc\u30c9\u306e\u69cb\u6210\u3068\u5171\u6709\u30c7\u30a3\u30b9\u30af\u306e\u8a2d\u5b9a<\/a>
\u3000\u30b9\u30c6\u30c3\u30d7\uff14\uff1aOracle Grid Infrastructure\u306e\u5c0e\u5165<\/a><\/strong>
\u3000\u30b9\u30c6\u30c3\u30d7\uff15\uff1aOracle RAC One node\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210
<\/a><\/strong>\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc\u30fc<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

yum\u30b3\u30de\u30f3\u30c9\u306b\u3088\u308b\u5fc5\u8981\u306a\u30d1\u30c3\u30b1\u30fc\u30b8\u306e\u5c0e\u5165<\/strong><\/h2>\n\n\n\n

\u4e0b\u8a18yum\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3001\u5fc5\u8981\u306a\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u5c0e\u5165\u3057\u307e\u3059\u3002<\/p>\n\n\n

\nyum install -y bc*\nyum install -y binutils*\nyum install -y compat-libcap1*\nyum install -y compat-libstdc++*\nyum install -y elfutils-libelf*\nyum install -y fontconfig-devel*\nyum install -y glibc*\nyum install -y ksh*\nyum install -y libaio*\nyum install -y libXrender*\nyum install -y libXi*\nyum install -y libXtst*\nyum install -y libstdc++*\nyum install -y python*\nyum install -y targetcli*\nyum install -y gcc*\nyum install -y oracleasm\nyum install -y oracleasm-support\n<\/pre><\/div>\n\n\n
\u30ab\u30fc\u30cd\u30eb\u8a2d\u5b9a\u306e\u5909\u66f4<\/strong><\/h2>\n\n\n\n
\u4e0b\u8a18vi\u30b3\u30de\u30f3\u30c9\u304b\u3089\u3001Oracle\u7528\u306esysctl.conf\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3001\u30ab\u30fc\u30cd\u30eb\u30d1\u30e9\u30e1\u30fc\u30bf<\/strong>\u3092\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n\n\n
\nvi \/etc\/sysctl.d\/97-oracle-database-sysctl.conf\n\nfs.aio-max-nr = 1048576\nfs.file-max = 6815744\nkernel.shmall = 2097152\nkernel.shmmax = 5368709120\nkernel.shmmni = 4096\nkernel.sem = 250 32000 100 128\nnet.ipv4.ip_local_port_range = 9000 65500\nnet.core.rmem_default = 262144\nnet.core.rmem_max = 4194304\nnet.core.wmem_default = 262144\nnet.core.wmem_max = 1048576\nkernel.panic_on_oops = 1\n<\/pre><\/div>\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
\u305d\u306e\u5f8c\u3001\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3001\u8a2d\u5b9a\u3092\u53cd\u6620\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n
\n\/sbin\/sysctl --system\n\/sbin\/sysctl -p\n<\/pre><\/div>\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
SE Linux\u3084\u30d5\u30a1\u30a4\u30a2\u30a6\u30a9\u30fc\u30eb\u3001\u6642\u523b\u540c\u671f\u306e\u7121\u52b9\u5316<\/strong><\/h2>\n\n\n\n
\u5404\u7a2eOS\u5074\u306e\u65e2\u5b58\u8a2d\u5b9a\u3092\u7121\u52b9\u5316\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n
\u307e\u305a\u306f\u3001\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3067SE Linux<\/strong>\u3092\u505c\u6b62\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n
\nsetenforce 0\n<\/pre><\/div>\n\n\n
\u4e0b\u8a18vi\u30b3\u30de\u30f3\u30c9\u304b\u3089\u3001config\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304d\u3001\u300cSELINUX=disabled<\/strong>\u300d\u306b\u5909\u66f4\u3057\u3001\u81ea\u52d5\u8d77\u52d5\u3092\u7121\u52b9\u5316\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n
\nvi \/etc\/selinux\/config\n\nSELINUX=disabled\n<\/pre><\/div>\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u304b\u3089Firewalld\u3068avahi-daemon<\/strong>\u3092\u505c\u6b62\u3055\u305b\u307e\u3059\u3002<\/p>\n\n\n
\nsystemctl stop firewalld\nsystemctl disable firewalld\nsystemctl stop avahi-daemon\nsystemctl disable avahi-daemon\n<\/pre><\/div>\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u304b\u3089\u3001\u6642\u523b\u540c\u671f\u3092\u7121\u52b9\u5316<\/strong>\u3057\u307e\u3059\u3002<\/p>\n\n\n
\nsystemctl stop chronyd\nsystemctl disable chronyd\nmv \/etc\/chrony.conf \/etc\/chrony.conf.org\n<\/pre><\/div>\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
\u540d\u524d\u89e3\u6c7a\u306e\u305f\u3081\u306ehosts\u30d5\u30a1\u30a4\u30eb\u306e\u8a18\u8f09<\/strong><\/h2>\n\n\n\n
\u540d\u524d\u89e3\u6c7a\u306e\u305f\u3081\u3001hosts\u30d5\u30a1\u30a4\u30eb\u3078\u306e\u8a18\u8f09<\/strong>\u3092\u884c\u3044\u307e\u3059\u3002\u4eca\u56de\u306e\u74b0\u5883\u3067\u306f100\u306e\u30bb\u30b0\u30e1\u30f3\u30c8\u3092\u30d1\u30d6\u30ea\u30c3\u30af\u7528\u3001VIP\u7528\u3001SCAN\u7528\u306b\u3001111\u306e\u30bb\u30b0\u30e1\u30f3\u30c8\u3092\u30d7\u30e9\u30a4\u30d9\u30fc\u30c8(ASM)\u7528\u306b\u69cb\u6210\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u4e0b\u8a18\u306e\u7528\u306b\u8a2d\u5b9a\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n
\nvi \/etc\/hosts\n\n### Oracle Public IP\n192.168.100.131 ora01\n192.168.100.132 ora02\n\n### Oracle VIP\n192.168.100.133 ora01-vip\n192.168.100.134 ora02-vip\n\n### Oracle SCAN\n192.168.100.136 ora-scan\n192.168.100.137 ora-scan\n\n### Oracle Private IP\n193.168.111.31 ora01-pr\n193.168.111.32 ora02-pr\n<\/pre><\/div>\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
OS\u30b0\u30eb\u30fc\u30d7\u306e\u4f5c\u6210<\/strong><\/h2>\n\n\n\n
\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3088\u308a\u3001OS\u30b0\u30eb\u30fc\u30d7<\/strong>\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n
\ngroupadd -g 54321 oinstall\ngroupadd -g 54322 dba\ngroupadd -g 54323 backupdba\ngroupadd -g 54324 oper\ngroupadd -g 54325 dgdba\ngroupadd -g 54326 kmdba\ngroupadd -g 54327 asmdba\ngroupadd -g 54328 asmoper\ngroupadd -g 54329 asmadmin\ngroupadd -g 54330 racdba\n<\/pre><\/div>\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
grid\u30e6\u30fc\u30b6\u3068oracle\u30e6\u30fc\u30b6\u306e\u4f5c\u6210<\/strong><\/h2>\n\n\n\n
\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3088\u308a\u3001Oracle Grid Infrastructure\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306b\u4f7f\u7528\u3059\u308bgrid\u30e6\u30fc\u30b6<\/strong>\u3068\u3001Oracle DB\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306b\u4f7f\u7528\u3059\u308bOracle\u30e6\u30fc\u30b6<\/strong>\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n
\nuseradd -u 1500 -g oinstall -G  dba,asmdba,backupdba,dgdba,kmdba,racdba,asmadmin grid\nuseradd -u 1600 -g oinstall -G dba,backupdba,oper,dgdba,kmdba,asmdba,racdba oracle\n<\/pre><\/div>\n\n\n
\u4f5c\u6210\u5f8c\u3001\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3088\u308a\u5404\u30e6\u30fc\u30b6\u306b\u5bfe\u3057\u3066\u30d1\u30b9\u30ef\u30fc\u30c9\u3082\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n
\npasswd grid\npasswd oracle\n<\/pre><\/div>\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
\u5404\u30e6\u30fc\u30b6\u306e\u30ea\u30bd\u30fc\u30b9\u5236\u9650\u3068\u3001\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u4f5c\u6210<\/strong><\/h2>\n\n\n\n
\u4e0b\u8a18vi\u30b3\u30de\u30f3\u30c9\u3088\u308a\u3001\u5404\u30e6\u30fc\u30b6\u306e\u30ea\u30bd\u30fc\u30b9\u5236\u9650\u5024<\/strong>\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n\n\n
\nvi \/etc\/security\/limits.conf\n\noracle               soft    nofile  1024\noracle               hard    nofile  65536\noracle               soft    nproc   2047\noracle               hard    nproc   16384\noracle               soft    stack   12040\noracle               hard    stack   32768\noracle               soft    memlock   3145728\noracle               hard    memlock   3145728\ngrid                 soft    nproc   2047\ngrid                 hard    nproc   16384\ngrid                 soft    nofile  1024\ngrid                 hard    nofile  65536\ngrid                 soft    stack   12040\ngrid                 hard    stack   32768\ngrid                 soft    memlock   3145728\ngrid                 hard    memlock   3145728\n<\/pre><\/div>\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3088\u308a\u3001\u5404\u30e6\u30fc\u30b6\u306e\u4f5c\u696d\u30c7\u30a3\u30ec\u30af\u30c8\u30ea<\/strong>\u3082\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n\n\n
\nmkdir -p \/u01\/app\/19.0.0\/grid\nmkdir -p \/u01\/app\/grid\nchown -R grid:oinstall \/u01\nmkdir -p \/u01\/app\/oracle\nchown -R oracle:oinstall \/u01\/app\/oracle\nchmod -R 775 \/u01\n<\/pre><\/div>\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
\u5404\u30e6\u30fc\u30b6\u306e\u74b0\u5883\u5909\u6570\u306e\u4f5c\u6210<\/strong><\/h2>\n\n\n\n
\u5404\u30e6\u30fc\u30b6\u306e\u74b0\u5883\u5909\u6570\u3092\u8a2d\u5b9a<\/strong>\u3057\u307e\u3059\u3002
\u307e\u305a\u306f\u3001grid\u30e6\u30fc\u30b6<\/strong>\u306e\u8a2d\u5b9a\u3092\u884c\u3046\u305f\u3081\u3001su\u30b3\u30de\u30f3\u30c9\u3067grid\u30e6\u30fc\u30b6\u306b\u5909\u66f4<\/strong>\u3057\u305f\u5f8c\u3001\u4e0b\u8a18vi\u30b3\u30de\u30f3\u30c9\u3067\u8a2d\u5b9a\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n
\nsu - grid\nvi .bash_profile\n\numask 022\nexport LANG=C\nexport NLS_LANG=American_America.UTF8\nexport ORACLE_BASE=\/u01\/app\/grid\nexport ORACLE_HOME=\/u01\/app\/19.0.0\/grid\nexport ORACLE_SID=+ASM1\nexport PATH=$ORACLE_HOME\/bin:$ORACLE_HOME\/OPatch:$PATH\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:$LD_LIBRARY_PATH\n<\/pre><\/div>\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
\u6b21\u306b\u3001oracle\u30e6\u30fc\u30b6<\/strong>\u306e\u8a2d\u5b9a\u3092\u884c\u3046\u305f\u3081\u3001su\u30b3\u30de\u30f3\u30c9\u3067oracle\u30e6\u30fc\u30b6<\/strong>\u306b\u5909\u66f4<\/strong>\u3057\u305f\u5f8c\u3001\u4e0b\u8a18vi\u30b3\u30de\u30f3\u30c9\u3067\u8a2d\u5b9a\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n
\nsu - oracle\nvi .bash_profile\n\numask 022\nexport LANG=C\nexport NLS_LANG=American_America.UTF8\nxport ORACLE_BASE=\/u01\/app\/oracle\nexport ORACLE_HOME=\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\nexport PATH=$ORACLE_HOME\/bin:$PATH\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:$LD_LIBRARY_PATH\nexport ORACLE_SID=orcl_1\nexport ORACLE_UNQNAME=orcl\n<\/pre><\/div>\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
\u3053\u308c\u3067Oracle Grid Infrastructure<\/strong>\u3084Oracle DB<\/strong>\u3092\u5c0e\u5165\u3059\u308b\u305f\u3081\u306e\u524d\u6e96\u5099\u306f\u5b8c\u4e86\u3067\u3059\u3002\u6b21\u56de\u306e\u30d6\u30ed\u30b0<\/a><\/strong>\u3067\u306f\u3001\uff12\u53f0(\u30ce\u30fc\u30c9)\u76ee\u306eOracle Linux\u306e\u69cb\u6210\u3068\u3001\u5171\u6709\u30c7\u30a3\u30b9\u30af\u8a2d\u5b9a<\/strong>\u3092\u884c\u3063\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n
\u53c2\u8003\u30da\u30fc\u30b8\uff1ahttps:\/\/docs.oracle.com\/en\/operating-systems\/oracle-linux\/7\/install\/#Oracle-Linux-7<\/a><\/p>\n\n\n\n
<\/p>\n\n\n\n
<\/p>\n\n\n\n
<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"
\u524d\u56de\u306e\u8a18\u4e8b\u3067\u306f\u3001Oracle RAC One node\u3092\u69cb\u6210\u3059\u308b\u305f\u3081\u306eOracle Linux\u306e\u5c0e\u5165\u307e\u3067\u3092\u884c\u3044\u307e\u3057\u305f\u3002\u4eca\u56de\u306fOracle Linux\u306bOracle Grid Infrastructure\u3084Oracle D … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[34,55,354,23],"class_list":["post-6925","post","type-post","status-publish","format-standard","hentry","category-syniti","tag-oracle","tag-55","tag-354","tag-oracle-rac"],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/6925","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/comments?post=6925"}],"version-history":[{"count":42,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/6925\/revisions"}],"predecessor-version":[{"id":7891,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/6925\/revisions\/7891"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/media?parent=6925"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/categories?post=6925"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/tags?post=6925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}