{"id":772,"date":"2020-05-01T17:00:06","date_gmt":"2020-05-01T09:00:06","guid":{"rendered":"http:\/\/www.821121.com\/?p=772"},"modified":"2020-12-11T09:52:17","modified_gmt":"2020-12-11T01:52:17","slug":"oracle12-2-0-1rac%e5%9c%a8linux6%e4%b8%8a%e9%83%a8%e7%bd%b2%e4%b8%80","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=772","title":{"rendered":"Oracle12.2.0.1RAC\u5728linux6\u4e0a\u90e8\u7f72(\u4e00)"},"content":{"rendered":"
\u7cfb\u7edf\u73af\u5883\uff1a\nVMware Workstation14.5 +linux 6.8(64\u4f4d)+Oracle 11.2.0.4.0 \n\u4e24\u4e2a\u8282\u70b9test12c1(\u8282\u70b91)\u548ctest12c2(\u8282\u70b92)\n\nvi \/etc\/hosts\n10.0.100.21 test12c1\n10.0.100.22 test12c2\n10.0.100.31 test12c1-vip\n10.0.100.32 test12c2-vip\n10.0.100.20 test-scan\n1.1.1.1 test12c1-priv\n1.1.1.2 test12c2-priv\n\n\u8282\u70b91\uff1a\nhostname:test12c1  ip:10.0.100.21   scanip:10.0.100.20  dbname=test   instance_name=test1\n\n\u8282\u70b92\uff1a\nhostname:test12c2  ip:10.0.100.22   scanip:10.0.100.20   dbname=test   instance_name=test2<\/code><\/pre>\n
0\u3001\u5b89\u88c5\u524d\u68c0\u67e5\u4e0e\u9700\u77e5\uff1a<\/h1>\n
1\u3001\u6bcf\u4e2a\u8282\u70b9\u81f3\u5c118G\u7684\u5185\u5b58\uff0c\u68c0\u67e5\u65f6\u95f4\u3001\u65f6\u533a\uff0c\u51e0\u4e2a\u8282\u70b9\u7684\u7f51\u5361\u540d\u8981\u4e00\u6837\u3002\n2\u3001\u4e34\u65f6\u7a7a\u95f4\/tmp\u81f3\u5c111G\n3\u3001GI\u81f3\u5c11\u9700\u898112 G\u7684\u7a7a\u95f4\uff0cOracle\u5efa\u8bae\u5206\u914d100 GB\u6765\u4e3a\u8865\u4e01\u63d0\u4f9b\u66f4\u591a\u7a7a\u95f4\u3002\nOracle\u6570\u636e\u5e93\u4f01\u4e1a\u7248\u81f3\u5c11\u9700\u89819 GB\u3002OCR\u7a7a\u95f4\u81f3\u5c11\u898139G\uff08extend\uff09\u3002\n4\u3001\u9700\u8981\u7684rpm\u89c1\nhttps:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/cwlin\/operating-system-requirements-for-x86-64-linux-platforms.html#GUID-3F647617-7FF5-4EE4-BBA8-9A5E3EEC888F\n5\u3001\u5173\u95edTransparent HugePages\nhttps:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/cwlin\/disabling-transparent-hugepages.html#GUID-02E9147D-D565-4AF8-B12A-8E6E9F74BEEA\n\u5728Red Hat Enterprise Linux 6\uff0cRed Hat Enterprise Linux 7\uff0cSUSE 11\uff0cOracle Linux 6\u548cOracle Linux 7\u4e2d\u9ed8\u8ba4\u542f\u7528Transparent HugePages\u5185\u5b58\uff0c\u800c\u65e9\u671f\u7248\u672c\u7684Oracle Linux\u4f7f\u7528Unbreakable Enterprise Kernel 2\uff08UEK2\uff09\u5185\u6838\u3002Transparent HugePages\u4f1a\u5728\u8fd0\u884c\u65f6\u5bfc\u81f4\u5185\u5b58\u5206\u914d\u5ef6\u8fdf\u3002\u4e3a\u907f\u514d\u6027\u80fd\u95ee\u9898\uff0cOracle\u5efa\u8bae\u60a8\u5728\u6240\u6709Oracle\u6570\u636e\u5e93\u670d\u52a1\u5668\u4e0a\u7981\u7528\u900f\u660e\u8d85\u5927\u9875\u9762\u3002Oracle\u5efa\u8bae\u60a8\u6539\u7528\u6807\u51c6\u7684HugePages\u6765\u63d0\u9ad8\u6027\u80fd\u3002\n6\u300116G\u4ee5\u4e0a\u5927\u5185\u5b58\u5f00\u542fHugePages<\/code><\/pre>\n
\u4ee5\u4e0b\u4e3a\u5728\u7b14\u8bb0\u672c\u7684\u865a\u62df\u673a\u4e0a\u5b89\u88c5\uff0c\u8d44\u6e90\u6709\u9650\u3002<\/p>\n
1\u3001\u5b89\u88c5rpm\u5305\uff082\u4e2a\u8282\u70b9\u90fd\u8981\u914d\u7f6e\uff09<\/h1>\n
\u914d\u7f6eyum\u6e90\nmount  \/dev\/cdrom \/mnt\n\nvi \/etc\/yum.repos.d\/ol.repo\n[local-source]\nname=ol\nbaseurl=file:\/\/\/mnt\/\nenabled=1\ngpgcheck=0\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-oracle\n\n\u5b89\u88c5rpm\n\nyum install xterm bc* binutils* compat-l* e2fsprog*  glibc-2.*  glibc-de*  ksh* libgcc-4*  libstdc+*  libaio-0* libaio-d* libXtst-* libX11-1*  libXau-1* libxcb-1* libXi-1.*  make-3.8* net-tool* nfs-util* sysstat-* smartmontools* gcc-c++* xorg-x11-xauth\n<\/code><\/pre>\n
\u5177\u4f53\u89c1\u5b98\u65b9\u6587\u6863\uff1a<\/p>\n
https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/cwlin\/operating-system-requirements-for-x86-64-linux-platforms.html#GUID-3F647617-7FF5-4EE4-BBA8-9A5E3EEC888F\n\u5305\u542b\nbc\nbinutils-2.20.51.0.2-5.36.el6 (x86_64)\ncompat-libcap1-1.10-1 (x86_64)\ncompat-libstdc++-33-3.2.3-69.el6 (x86_64)\ncompat-libstdc++-33-3.2.3-69.el6 (i686)\ne2fsprogs-1.41.12-14.el6 (x86_64)\ne2fsprogs-libs-1.41.12-14.el6 (x86_64)\nglibc-2.12-1.7.el6 (i686)\nglibc-2.12-1.7.el6 (x86_64)\nglibc-devel-2.12-1.7.el6 (x86_64)\nglibc-devel-2.12-1.7.el6 (i686)\nksh\nlibgcc-4.4.4-13.el6 (i686)\nlibgcc-4.4.4-13.el6 (x86_64)\nlibstdc++-4.4.4-13.el6 (x86_64)\nlibstdc++-4.4.4-13.el6 (i686)\nlibstdc++-devel-4.4.4-13.el6 (x86_64)\nlibstdc++-devel-4.4.4-13.el6 (i686)\nlibaio-0.3.107-10.el6 (x86_64)\nlibaio-0.3.107-10.el6 (i686)\nlibaio-devel-0.3.107-10.el6 (x86_64)\nlibaio-devel-0.3.107-10.el6 (i686)\nlibXtst-1.0.99.2 (x86_64)\nlibXtst-1.0.99.2 (i686)\nlibX11-1.5.0-4.el6 (i686)\nlibX11-1.5.0-4.el6 (x86_64)\nlibXau-1.0.6-4.el6 (i686)\nlibXau-1.0.6-4.el6 (x86_64)\nlibxcb-1.8.1-1.el6 (i686)\nlibxcb-1.8.1-1.el6 (x86_64)\nlibXi-1.3 (x86_64)\nlibXi-1.3 (i686)\nmake-3.81-19.el6\nnet-tools-1.60-110.el6_2.x86_64 (for Oracle RAC and Oracle Clusterware)\nnfs-utils-1.2.3-15.0.1 (for Oracle ACFS)\nsysstat-9.0.4-11.el6 (x86_64)\nsmartmontools-5.43-1.el6.x86_64<\/code><\/pre>\n
2\u3001\u521b\u5efa\u7528\u6237\u3001\u76ee\u5f55\uff082\u4e2a\u8282\u70b9\u90fd\u8981\u914d\u7f6e\uff09<\/h1>\n
groupadd -g 1005 oinstall\ngroupadd -g 1001 dba\ngroupadd -g 1002 asmadmin\ngroupadd -g 1003 asmdba\ngroupadd -g 1004 asmoper\nuseradd -u 1100 -g oinstall -G asmadmin,asmdba,asmoper,dba grid\nuseradd -u 1101 -g oinstall -G dba,asmdba,asmadmin,asmoper oracle\n\nmkdir -p \/u01\/12.2.0\/grid \nmkdir -p \/u01\/app\/grid\nchown -R grid:oinstall \/u01\/12.2.0\/grid\nchown -R grid:oinstall \/u01\/app\/grid  \nchmod -R 775 \/u01\/12.2.0\/grid  \n\nmkdir -p \/u01\/app\/oracle \nmkdir \/u01\/app\/oracle\/cfgtoollogs  \nchown -R oracle:oinstall \/u01\/app\/oracle \nchmod -R 775 \/u01\/app\/oracle  \n\nmkdir -p \/u01\/app\/oracle\/product\/12.2.0\/db_1 \nchown -R oracle:oinstall \/u01\/app\/oracle\/product\/12.2.0\/db_1 \nchmod -R 775 \/u01\/app\/oracle\/product\/12.2.0\/db_1 \n\nmkdir -p \/u01\/app\/oraInventory\nchown -R grid:oinstall \/u01\/app\/oraInventory\nchmod -R 775 \/u01\/app\/oraInventory<\/code><\/pre>\n
3\u3001\u521b\u5efa\u5171\u4eab\u78c1\u76d8\uff082\u4e2a\u8282\u70b9\u90fd\u8981\u914d\u7f6e\uff09<\/h1>\n
\u865a\u62df\u673a\u521b\u5efa\u5171\u4eab\u76d8\uff1a\nvmware-vdiskmanager.exe -c -s 39Gb -a lsilogic -t 2 "E:\\Virtual Machines\\sharedisk\\ocr.vmdk"\nvmware-vdiskmanager.exe -c -s 15Gb -a lsilogic -t 2 "E:\\Virtual Machines\\sharedisk\\data.vmdk"\nvmware-vdiskmanager.exe -c -s 5Gb -a lsilogic -t 2 "E:\\Virtual Machines\\sharedisk\\arch.vmdk"\n\u5206\u522b\u6253\u5f00\u4e24\u53f0\u865a\u62df\u673a\u76ee\u5f55\u4e2d\u7684vmx\u6587\u4ef6\uff0c\u5728\u6700\u540e\u4e00\u884c\u6dfb\u52a0\uff1a\n\nscsi1.present = "TRUE"\nscsi1.virtualDev = "lsilogic"\nscsi1.sharedBus = "virtual"\n\nscsi1:1.present = "TRUE"\nscsi1:1.mode = "independent-persistent"\nscsi1:1.filename = "E:\\Virtual Machines\\sharedisk\\ocr.vmdk"\n\nscsi1:2.present = "TRUE"\nscsi1:2.mode = "independent-persistent"\nscsi1:2.filename = "E:\\Virtual Machines\\sharedisk\\data.vmdk"\n\nscsi1:3.present = "TRUE"\nscsi1:3.mode = "independent-persistent"\nscsi1:3.filename = "E:\\Virtual Machines\\sharedisk\\arch.vmdk"\n\ndisk.locking = "false"\ndiskLib.dataCacheMaxSize = "0"\ndiskLib.dataCacheMaxReadAheadSize = "0"\ndiskLib.DataCacheMinReadAheadSize = "0"\ndiskLib.dataCachePageSize = "4096"\ndiskLib.maxUnsyncedWrites = "0"<\/code><\/pre>\n
4\u3001\u64cd\u4f5c\u7cfb\u7edf\u914d\u7f6e\u4fee\u6539\uff082\u4e2a\u8282\u70b9\u90fd\u8981\u914d\u7f6e\uff09<\/h1>\n
4.1\u914d\u7f6e\u4e3b\u673a\u4fe1\u606f<\/h2>\n
vi \/etc\/hosts\n\n10.0.100.21 test12c1\n10.0.100.22 test12c2\n\n10.0.100.31 test12c1-vip\n10.0.100.32 test12c2-vip\n\n10.0.100.20 test-scan\n\n1.1.1.1 test12c1-priv\n1.1.1.2 test12c2-priv<\/code><\/pre>\n
4.2\u914d\u7f6e\u7cfb\u7edf\u53c2\u6570<\/h2>\n
\u4fee\u6539\u5185\u6838\u53c2\u6570\nvi \/etc\/sysctl.conf\n\n# for oracle\nfs.aio-max-nr = 1048576\nfs.file-max = 6815744\nkernel.shmall = 1364702 #\u7269\u7406\u5185\u5b58\/4k,See Note: 301830.1 for more information.\nkernel.shmmax = 2794909696 #\u7269\u7406\u5185\u5b58*0.6 (or higher at customer's discretion - see Note:567506.1)\nkernel.shmmni = 4096\nkernel.sem = 250 32000 100 128\nkernel.panic_on_oops = 1\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 = 1048586\nvm.swappiness=10\n\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\u751f\u6548\uff1a\nsysctl -p\n\n\u52a0\u8f7dpam_limits.so\u6a21\u5757\nvi \/etc\/pam.d\/login\nsession required pam_limits.so\n\n\u4fee\u6539\u7528\u6237\u53c2\u6570\nvi \/etc\/profile\nif [ $USER = "oracle" ] || [ $USER = "grid" ] ; then\n    if [ $SHELL = "\/bin\/ksh" ]; then\n       ulimit -u 16384\n       ulimit -n 65536\n    else\n       ulimit -u 16384 -n 65536\n    fi\nfi\n\nvi \/etc\/security\/limits.conf\ngrid soft nofile 1024\ngrid hard nofile 65536\ngrid soft stack 10240\ngrid hard stack 32768\ngrid soft nproc 2047\ngrid hard nproc 16384\n\noracle soft nofile 1024\noracle hard nofile 65536\noracle soft stack 10240\noracle hard stack 32768\noracle soft nproc 2047\noracle hard nproc 16384\nroot soft nproc 2047\n\n* soft memlock 157286400  #90% RAM FOR HUGEPAGES \u5355\u4f4d\u662fk\n* hard memlock 157286400  #90% RAM FOR HUGEPAGES \u5355\u4f4d\u662fk\n<\/code><\/pre>\n
4.3\u5173\u95ed\u9632\u706b\u5899<\/h2>\n
vi \/etc\/selinux\/config\nSELINUX=disabled\n\u9700\u8981\u91cd\u542f\u3002\n\nservice iptables stop\nchkconfig iptables off<\/code><\/pre>\n
4.4\u5173\u95edNTP<\/h2>\n
service ntpd stop\nchkconfig ntpd off\nrm -rf \/etc\/ntpd.conf \nrm -rf \/var\/run\/ntpd.pid<\/code><\/pre>\n
4.5\u914d\u7f6essh\u4e92\u4fe1<\/h2>\n
ssh\u751f\u6210\u516c\u94a5\/\u79c1\u94a5 \uff08oracle\u3001grid\u7528\u6237\uff09\nssh-keygen -t rsa -P ''\n\u8f93\u5165\u5185\u5bb9\u76f4\u63a5\u6309\u56de\u8f66\ncd ~\/.ssh\ncat id_rsa.pub\n\u5c062\u4e2a\u8282\u70b9id_rsa.pub\u7684\u5185\u5bb9\uff0c\u590d\u5236\u51fa\u6765\u5199\u5165\u52302\u4e2a\u8282\u70b9\u7684authorized_keys\u6587\u4ef6\u4e2d\ncd ~\/.ssh\nvi authorized_keys\n\u57282\u4e2a\u8282\u70b9\u5206\u522b\u6d4b\u8bd5ssh\u8054\u901a\u6027\uff08oracle\u3001grid\u7528\u6237\u90fd\u8981\uff09\nssh 10.0.100.21\n\u63d0\u793a\u8f93\u5165yes\nexit\nssh 10.0.200.22\n\u63d0\u793a\u8f93\u5165yes\nexit<\/code><\/pre>\n
4.6 oracle\u3001grid\u7528\u6237\u73af\u5883\u53d8\u91cf\u914d\u7f6e<\/h2>\n
Grid\u7528\u6237\u73af\u5883\u53d8\u91cf\uff1a\nexport TMP=\/tmp\nexport TMPDIR=$TMP\nexport ORACLE_SID=+ASM1  # RAC1\n#export ORACLE_SID=+ASM2  # RAC2\nexport ORACLE_BASE=\/u01\/app\/grid\nexport ORACLE_HOME=\/u01\/12.2.0\/grid\/\nexport PATH=\/usr\/sbin:$PATH\nexport PATH=$ORACLE_HOME\/bin:$PATH\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib\nexport CLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib\numask 022\n\noracle\u7528\u6237\u73af\u5883\u53d8\u91cf\uff1a\n\nexport TMP=\/tmp \nexport TMPDIR=$TMP \nexport ORACLE_SID=test1 #\u8282\u70b92\u6539\u4e3atest2\nexport ORACLE_BASE=\/u01\/app\/oracle \nexport ORACLE_HOME=$ORACLE_BASE\/product\/12.2.0\/db_1\nexport TNS_ADMIN=$ORACLE_HOME\/network\/admin \nexport PATH=\/usr\/sbin:$PATH \nexport PATH=$ORACLE_HOME\/bin:$PATH \nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib \nexport CLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib \numask 022\n<\/code><\/pre>\n
4.7\u914d\u7f6ezeroconf<\/h2>\n
vi \/etc\/sysconfig\/network\nNOZEROCONF=yes\n<\/code><\/pre>\n
4.8\u53d6\u6d88\u900f\u660e\u5927\u9875\uff08Transparent HugePages\uff09<\/h2>\n
vi \/etc\/grub.conf \n\u6dfb\u52a0\u5230\u6587\u4ef6\u4e2d\u7684\u5185\u6838\u5f15\u5bfc\u884c\u4e2d\uff0c\u4f8b\u5982\uff1a\nkernel \/vmlinuz-2.6.32-642.el6.x86_64 ro root=\/dev\/mapper\/vg_test12c1-lv_root rd_NO_LUKS rd_NO_MD crashkernel=auto LANG=zh_CN.UTF-8 rd_LVM_LV=vg_test12c1\/lv_swap rd_LVM_LV=vg_test12c1\/lv_root  KEYBOARDTYPE=pc KEYTABLE=us rd_NO_DM rhgb quiet transparent_hugepage=never\n\n\u91cd\u542fOS\u540e\u786e\u8ba4\u662f\u5426\u751f\u6548\n[root@test12c1 ~]# cat \/sys\/kernel\/mm\/redhat_transparent_hugepage\/enabled\nalways madvise [never]<\/code><\/pre>\n
4.9\u8bbe\u7f6eDisk I\/O Scheduler deadline<\/h2>\n
vi \/etc\/udev\/rules.d\/60-oracle-schedulers.rules\n\u6dfb\u52a0\u5982\u4e0b\u5185\u5bb9\nACTION=="add|change", KERNEL=="sd[a-z]", ATTR{queue\/rotational}=="0", ATTR{queue\/scheduler}="deadline"\n\u8fd0\u884c\u751f\u6548\nudevadm control --reload-rules<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u7cfb\u7edf\u73af\u5883\uff1a VMware Workstation1<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,38],"tags":[],"class_list":["post-772","post","type-post","status-publish","format-standard","hentry","category-oracle-12c","category--oracle-12c"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/772","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=772"}],"version-history":[{"count":2,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/772\/revisions"}],"predecessor-version":[{"id":842,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/772\/revisions\/842"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=772"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}