{"id":916,"date":"2019-12-07T15:41:20","date_gmt":"2019-12-07T07:41:20","guid":{"rendered":"http:\/\/www.821121.com\/?p=916"},"modified":"2021-02-02T14:25:16","modified_gmt":"2021-02-02T06:25:16","slug":"oracle19crac%e5%ae%89%e8%a3%85%e6%96%87%e6%a1%a3%ef%bc%88%e4%b8%80%ef%bc%89","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=916","title":{"rendered":"Oracle19cRAC\u5b89\u88c5\u6587\u6863\uff08\u4e00\uff09"},"content":{"rendered":"<pre><code class=\"language-sql\">\u7cfb\u7edf\u73af\u5883\uff1a\nVMware Workstation14.5 +linux 7.6(64\u4f4d)+Oracle 19.3.0.0.0 \n\u4e24\u4e2a\u8282\u70b9mnt1(\u8282\u70b91)\u548cmnt2(\u8282\u70b92)\n\nhosts\uff1a\nvi \/etc\/hosts\n192.168.174.141 cat1\n192.168.174.142 cat2\n192.168.174.143 cat1vip\n192.168.174.144 cat2vip\n192.168.174.145 catscanip\n192.168.160.141 cat1priv\n192.168.160.142 cat2priv\n\n\u8282\u70b91\uff1a\nhostname:cat1  ip:192.168.174.141  scanip:192.168.174.145 catscanip   dbname=catdb   instance_name=catdb1\n\n\u8282\u70b92\uff1a\nhostname:cat1  ip:192.168.174.142   scanip:192.168.174.145 catscanip   dbname=catdb   instance_name=catdb2<\/code><\/pre>\n<pre><code class=\"language-sql\">0.\u5b89\u88c5\u90e8\u7f72\u524d\u68c0\u67e5\uff0c\u8be6\u60c5\u89c119_rac excel\u8868\u3002\n1.\u68c0\u67e5\u7f51\u7edc\uff0c\u6709\u4e24\u4e2a\u4e0d\u540c\u7684\u7f51\u6bb5,\u4e24\u4e2a\u9759\u6001IP.\nifconfig\n\u7f51\u53611\uff08public ip\uff09\uff1avi \/etc\/sysconfig\/network-scripts\/ifcfg-ens33     \nBOOTPROTO=static\nIPADDR=192.168.0.116\uff08\u586b\u4f60\u7684ip\uff09                   \nNETMASK=255.255.255.0  \uff08\u586b\u4f60\u7684\u63a9\u7801\u503c\uff09          \nGATEWAY=192.168.0.1    (\u9ed8\u8ba4\u7f51\u5173)\n\u7f51\u53612\uff08\u5fc3\u8df3ip\uff09\uff1avi \/etc\/sysconfig\/network-scripts\/ifcfg-ens34\nDEVICE=eth1\nTYPE=Ethernet\nONBOOT=yes\nNM_CONTROLLED=yes\nBOOTPROTO=static\nIPADDR=10.0.0.101\nNETMASK=255.255.255.0\n\nsystemctl restart network     \/\/\u91cd\u542f\u7f51\u7edc\n\n2.\u68c0\u67e5linux\u7cfb\u7edf\u7248\u672c,\u9700\u8981\u5728linux7.4\u7248\u672c\u4ee5\u4e0a,\u673a\u5668\u7684\u7cfb\u7edf\u8981\u540c\u6837\u7684\u3002\n cat \/etc\/redhat-release\n uname -r\n\n3.\u68c0\u67e5\u5b89\u88c5\u6240\u9700\u7684\u78c1\u76d8\n\n\/tmp\u76ee\u5f55\u5927\u5c0f\u81f3\u5c11\uff1a1GB\n\u5b89\u88c5Grid Infrastracture\u6240\u9700\u7a7a\u95f4\uff1a12GB\n\u5b89\u88c5Oracle Database\u6240\u9700\u7a7a\u95f4\uff1a7.3GB\n\u6b64\u5916\u5b89\u88c5\u8fc7\u7a0b\u4e2d\u5206\u6790\u3001\u6536\u96c6\u3001\u8ddf\u8e2a\u6587\u4ef6\u6240\u9700\u7a7a\u95f4\uff1a10GB\n\u5efa\u8bae\u603b\u5171\u81f3\u5c11100GB\uff08\u6b64\u5904\u4e0d\u5305\u542bASM\u6216NFS\u7684\u7a7a\u95f4\u9700\u6c42\uff09\n# df -h\n\n4.\u8c03\u6574\u597d\u65f6\u533a\u548c\u65f6\u95f4\ndate \nrm -rf \/etc\/localtime\nln -s \/usr\/share\/zoneinfo\/Asia\/Shanghai \/etc\/localtime\n\n5.\u68c0\u67e5iso\u955c\u50cf\u662f\u5426\u6302\u4e0a\u3002\nmount \/dev\/sr0 \/mnt\n\n6.\u5185\u5b58\u68c0\u67e5\n\u5185\u5b58\u5927\u5c0f\uff1a\u81f3\u5c118GB\nSwap\u5927\u5c0f\uff1a\n\u5f53\u5185\u5b58\u4e3a4GB-16GB\u65f6\uff0cSwap\u9700\u8981\u5927\u4e8e\u7b49\u4e8e\u7cfb\u7edf\u5185\u5b58\u3002\n\u5f53\u5185\u5b58\u5927\u4e8e16GB\u65f6\uff0cSwap\u7b49\u4e8e16GB\u5373\u53ef\u3002\n\n# grep MemTotal \/proc\/meminfo\n# grep SwapTotal \/proc\/meminfo\n<\/code><\/pre>\n<h1>1\u3001\u5b89\u88c5\u8f6f\u4ef6\u5305<\/h1>\n<pre><code class=\"language-sql\">mount  \/dev\/sr0 \/mnt\ncd \/etc\/yum.repos.d\/\nrm -rf *\n\nvi \/etc\/yum.repos.d\/ol.repo   \n[local-source]\nname=ol\nbaseurl=file:\/\/\/mnt\/\nebabled=1\ngpgcheck=0\ngpgkey=file:\/\/\/etc\/pki\/rpm-gpg\/RPM-GPG-KEY-oracle\n\n\u5b89\u88c5rpm\u4f9d\u8d56\u5305\n\nyum -y install bc gcc gcc-c++  binutils  make gdb cmake  glibc ksh elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc-devel libaio libaio-devel libXrender libXrender-devel libX11 libXau sysstat libXi libXtst libgcc librdmacm-devel libstdc++ libstdc++-devel libxcb net-tools nfs-utils compat-libcap1 compat-libstdc++  smartmontools  targetcli python python-configshell python-rtslib python-six  unixODBC unixODBC-devel\n\nyum install -y xterm\n\nlinux7\u7f3a\u5c11\u8be5\u5305\uff0c\u9700\u8981\u53bb\u7f51\u4e0a\u4e0b\u8f7d\u624b\u52a8\u5b89\u88c5\uff0c\u6216\u8005\u4e0d\u5b89\u88c5\u4e0d\u4f1a\u5f71\u54cd\u6570\u636e\u5e93\u7684\u4f7f\u7528\uff0c\u8be6\u60c5\u770bmos\u6587\u68632254198.1\uff0cMissing or Ignored package compat-libstdc++-33-3.2.3 causes Text Issues (\u6587\u6863 ID 2254198.1)\n\nls -l compat* elfutils* | awk -v rpmpackage=&quot;&quot; &#039;{rpmpackage=$NF&quot; &quot;rpmpackage}END{print &quot;yum -y localinstall &quot;rpmpackage}&#039; | bash\n\n\u65e0\u5b89\u88c5\u684c\u9762\uff1a\n\u5b89\u88c5\u684c\u9762\u7ec4\u4ef6\u5305 #yum -y groupinstall &quot;Server with GUI&quot;      \\\\ \u5b89\u88c5\u56fe\u5f62\u5316\u7a0b\u5e8f\n\u542f\u52a8\u684c\u9762\u2014\u2014start<\/code><\/pre>\n<h1>2\u3001\u521b\u5efa\u7528\u6237\u3001\u7ec4\u3001\u76ee\u5f55<\/h1>\n<pre><code class=\"language-sql\">groupadd -g 54321 oinstall  \ngroupadd -g 54322 dba  \ngroupadd -g 54323 oper  \ngroupadd -g 54324 backupdba  \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\nuseradd -u 54321 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle  \nuseradd -u 54322 -g oinstall -G asmadmin,asmdba,asmoper,dba grid\npasswd oracle\npasswd grid\n\nmkdir -p \/u01\/app\/19.3.0\/grid\nmkdir -p \/u01\/app\/grid\nmkdir -p \/u01\/app\/oracle\nmkdir -p \/u01\/app\/oracle\/product\/19.3.0\/db_1\n\nchown -R grid:oinstall \/u01\nchown -R oracle:oinstall \/u01\/app\/oracle\nchmod -R 775 \/u01\/\n\nmkdir -p \/u01\/app\/oraInventory\nchown -R grid:oinstall \/u01\/app\/oraInventory\nchmod -R 775 \/u01\/app\/oraInventory\n\n\u4f5c\u7528  \u8def\u5f84\ngrid_home   \/u01\/app\/19.3.0\/grid\ngrid_base   \/u01\/app\/grid\noracle_base \/u01\/app\/oracle\nOracle_home \/u01\/app\/oracle\/product\/19.3.0\/db_1<\/code><\/pre>\n<h1>3\u3001\u914d\u7f6e\u5171\u4eab\u78c1\u76d8\uff08\u591a\u8def\u5f84+udev\uff09<\/h1>\n<pre><code class=\"language-sql\">\u914d\u7f6emultipath\u52a0udev\n\u5efa\u7acb\u5171\u4eab\u78c1\u76d8\uff08\u865a\u62df\u673a\uff09\n\u5207\u6362\u5230vmware\u5b89\u88c5\u76ee\u5f55    cd D:\\VMware\\vmware\ncmd  \u547d\u4ee4\n.\\vmware-vdiskmanager.exe -c -s 10G -a lsilogic -t 2 &quot;D:\\VMware\\vmware\\sharedisks\\19c\\OCR.vmdk&quot;\n.\\vmware-vdiskmanager.exe -c -s 40G -a lsilogic -t 2 &quot;D:\\VMware\\vmware\\sharedisks\\19c\\DATA.vmdk&quot;\n.\\vmware-vdiskmanager.exe -c -s 10G -a lsilogic -t 2 &quot;D:\\VMware\\vmware\\sharedisks\\19c\\ARCH.vmdk&quot;\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\nscsi1.present = &quot;TRUE&quot;\nscsi1.virtualDev = &quot;lsilogic&quot;\nscsi1.sharedBus = &quot;virtual&quot;\n\nscsi1:1.present = &quot;TRUE&quot;\nscsi1:1.mode = &quot;independent-persistent&quot;\nscsi1:1.filename = &quot;D:\\VMware\\vmware\\sharedisks\\19c\\OCR.vmdk&quot;\nscsi1:1.deviceType = &quot;Disk&quot;\n\nscsi1:2.present = &quot;TRUE&quot;\nscsi1:2.mode = &quot;independent-persistent&quot;\nscsi1:2.filename = &quot;D:\\VMware\\vmware\\sharedisks\\19c\\DATA.vmdk&quot;\nscsi1:2.deviceType = &quot;Disk&quot;\n\nscsi1:3.present = &quot;TRUE&quot;\nscsi1:3.mode = &quot;independent-persistent&quot;\nscsi1:3.filename = &quot;D:\\VMware\\vmware\\sharedisks\\19c\\ARCH.vmdk&quot;\nscsi1:3.deviceType = &quot;Disk&quot; \n\ndisk.locking = &quot;false&quot;\ndiskLib.dataCacheMaxSize = &quot;0&quot;\ndiskLib.dataCacheMaxReadAheadSize = &quot;0&quot;\ndiskLib.DataCacheMinReadAheadSize = &quot;0&quot;\ndiskLib.dataCachePageSize = &quot;4096&quot;\ndiskLib.maxUnsyncedWrites = &quot;0&quot;\n\n 1.\u53cc\u8282\u70b9\u5b89\u88c5multipath\u7684\u5305,\u5148\u540e\u987a\u5e8f\u4e0d\u80fd\u4e71\uff1a\nrpm -ivh device-mapper-multipath-libs-0.4.9-123.el7.x86_64.rpm\nrpm -ivh device-mapper-multipath-0.4.9-123.el7.x86_64.rpm\n\n2.\u542f\u52a8multipath\uff08rac1\u3001rac2\u90fd\u8dd1\uff09\nmodprobe dm-multipath\nmodprobe dm-round-robin\n\n3.\u5f00\u673a\u81ea\u542f\u52a8\nsystemctl enable multipathd.service\n\nsystemctl list-unit-files | grep multi\nmultipathd.service                            enabled \nmulti-user.target                             static  \n\n4.\u542f\u52a8multipath\u670d\u52a1\uff1a\nservice multipathd start\n\n5.\u591a\u8def\u5f84\u914d\u7f6e\uff08rac\u3001rac2\uff09\noracle RAC\u6240\u9700\u591a\u8def\u5f84\u914d\u7f6e\u8981\u70b9\u662f\u4e00\u4e2aRAC\u8282\u70b9\u4e00\u4e2aRAC\u8282\u70b9\u4e00\u6b21\u6267\u884c\u5982\u4e0b\u64cd\u4f5c\uff08\u5982\u679c\u9700\u8981\u518d\u6dfb\u52a0\u4f7f\u7528\u591a\u8def\u5f84\u7684\u5b58\u50a8\uff0c\u4e5f\u9700\u9075\u5faa\u5982\u4e0b\u6b65\u9aa4\uff09\uff1a\nservice multipathd stop\nmultipath -F\n\n\u83b7\u53d6wwid\uff1a\n\u5728 Linux 7\u4e0b\uff0c\u53ef\u4ee5\u4f7f\u7528\u5982\u4e0b\u547d\u4ee4\uff1a\n# \/usr\/lib\/udev\/scsi_id -g -u \/dev\/sdb    360050768018187d15000000000000039\n \/usr\/lib\/udev\/scsi_id -g -u \/dev\/sdc     360050768018187d1500000000000003a\n \/usr\/lib\/udev\/scsi_id -g -u \/dev\/sdd     360050768018187d15000000000000038\n\n \u5148\u67e5\u770b\u662f\u5426\u5b58\u5728\/etc\/multipath.conf\uff0c\u4e0d\u5b58\u5728\n\u65b9\u6cd51:\u521b\u5efa\u914d\u7f6e\u6587\u4ef6\uff1acp \/etc\/multipath_bak.conf   \/etc\/multipath.conf\nvi \/etc\/multipath.conf\n\ndefaults {\nuser_friendly_names yes\n}\n\ndevices {\ndevice {  \nvendor &quot;(COMPAQ|HP)&quot;\nproduct &quot;HSV1[01]1|HSV2[01]0|HSV300|HSV4[05]0&quot;\n#getuid_callout &quot;\/lib\/udev\/scsi_id --whitelisted --device=\/dev\/%n&quot;\nfeatures &quot;0&quot;\nhardware_handler &quot;0&quot;\npath_selector &quot;round-robin 0&quot;\npath_grouping_policy group_by_prio\nfailback immediate\nrr_weight uniform\nno_path_retry 12\nrr_min_io 1000\npath_checker tur\nprio alua\n}\n}\n\nmultipaths {\n\n        multipath {                                                                              \n                wwid                    360050768018187d15000000000000039\n                alias                   ARCH\n                path_grouping_policy    multibus\n                path_selector           &quot;round-robin 0&quot;\n                failback                immediate\n                rr_weight               priorities\n                no_path_retry           queue\n    }\n       multipath {                                                                              \n                wwid                    360050768018187d1500000000000003a\n                alias                   OCR\n                path_grouping_policy    multibus\n                path_selector           &quot;round-robin 0&quot;\n                failback                immediate\n                rr_weight               priorities\n                no_path_retry           queue\n    }\n       multipath {                                                                              \n                wwid                    360050768018187d15000000000000038\n                alias                   DATA\n                path_grouping_policy    multibus\n                path_selector           &quot;round-robin 0&quot;\n                failback                immediate\n                rr_weight               priorities\n                no_path_retry           queue\n    }\n}\n\nblacklist {\n        devnode &quot;^(sda|ram|raw|loop|fd|md|dm-|sr|scd|st)[0-9]*&quot;\n        devnode &quot;^hd[a-z]&quot;\n        devnode &quot;^asm\/*&quot;         # Here\n        devnode &quot;ofsctl&quot;             # Here\n}\n\n#\u542f\u52a8\u591a\u8def\u5f84\uff1a\nservice multipathd restart\n\n\u542f\u52a8multipath\u914d\u7f6e\u540e\uff0c\u4f1a\u5728\/dev\/mapper\u4e0b\u751f\u6210\u591a\u8def\u5f84\u903b\u8f91\u76d8\ncd \/dev\/mapper\nll\n#\u67e5\u770b\u591a\u8def\u5f84\u7684\u72b6\u6001\uff1amultipath -ll\n\n---\u9a8c\u8bc1\u6743\u9650\n ls -l \/dev\/dm-*\n---\u9a8c\u8bc1\u547d\u540d\u7ed3\u679c\nls -l \/dev\/mapper\/*\nudev\u6b65\u9aa4\uff1a\n1.\u67e5\u770b\u78c1\u76d8UUID\nlsscsi -i\n\n2.\u7f16\u8f91 UDEV Rules File\nvi \/etc\/udev\/rules.d\/99-oracle-asmdevices.rules\nKERNEL==&quot;dm-*&quot;,ENV{DM_UUID}==&quot;mpath-360050768018187d15000000000000039&quot;,SYMLINK+=&quot;asm_ARCH&quot;,OWNER=&quot;grid&quot;,GROUP=&quot;asmadmin&quot;,MODE=&quot;0660&quot;\nKERNEL==&quot;dm-*&quot;,ENV{DM_UUID}==&quot;mpath-360050768018187d1500000000000003a&quot;,SYMLINK+=&quot;asm_OCR&quot;,OWNER=&quot;grid&quot;,GROUP=&quot;asmadmin&quot;,MODE=&quot;0660&quot;\nKERNEL==&quot;dm-*&quot;,ENV{DM_UUID}==&quot;mpath-360050768018187d15000000000000038&quot;,SYMLINK+=&quot;asm_DATA&quot;,OWNER=&quot;grid&quot;,GROUP=&quot;asmadmin&quot;,MODE=&quot;0660&quot;\n\n3.scp rules\u6587\u4ef6\u81f3\u5176\u4ed6\u8282\u70b9\nscp \/etc\/udev\/rules.d\/99-oracle-asmdevices.rules node2:\/etc\/udev\/rules.d\/\n\n4. \u91cd\u65b0\u52a0\u8f7drules\u6587\u4ef6\nudevadm control --reload-rules\nudevadm trigger\n\n5.\u67e5\u770b\u7ed1\u5b9a\u540e\u8bbe\u5907\u4fe1\u606f\n[root@test1 rules.d]# ls -l \/dev\/asm*\nlrwxrwxrwx 1 root root 4 Aug 20 14:42 \/dev\/asm_test1 -&gt; dm-2\nlrwxrwxrwx 1 root root 4 Aug 20 14:42 \/dev\/asm_test2 -&gt; dm-3\nlrwxrwxrwx 1 root root 4 Aug 20 14:42 \/dev\/asm_test3 -&gt; dm-4\nlrwxrwxrwx 1 root root 4 Aug 20 14:42 \/dev\/asm_test4 -&gt; dm-5\nlrwxrwxrwx 1 root root 4 Aug 20 14:42 \/dev\/asm_test5 -&gt; dm-6\nlrwxrwxrwx 1 root root 4 Aug 20 14:42 \/dev\/asm_test6 -&gt; dm-7\n\n[root@test1 rules.d]# ls -l \/dev\/dm-*\nbrw-rw---- 1 grid asmadmin 253, 2 Aug 20 14:42 \/dev\/dm-2\nbrw-rw---- 1 grid asmadmin 253, 3 Aug 20 14:42 \/dev\/dm-3\nbrw-rw---- 1 grid asmadmin 253, 4 Aug 20 14:42 \/dev\/dm-4\nbrw-rw---- 1 grid asmadmin 253, 5 Aug 20 14:42 \/dev\/dm-5\nbrw-rw---- 1 grid asmadmin 253, 6 Aug 20 14:42 \/dev\/dm-6\nbrw-rw---- 1 grid asmadmin 253, 7 Aug 20 14:42 \/dev\/dm-7  <\/code><\/pre>\n<h1>4\u3001\u914d\u7f6e\u7cfb\u7edf\u53c2\u6570<\/h1>\n<h2>4.1\u4fee\u6539\u4e3b\u673a\u540d<\/h2>\n<pre><code class=\"language-sql\">vi \/etc\/hosts\n192.168.174.141 cat1\n192.168.174.142 cat2\n192.168.174.143 cat1vip\n192.168.174.144 cat2vip\n192.168.174.145 catscanip\n192.168.160.141 cat1priv\n192.168.160.142 cat2priv\n\nvi \/etc\/hostname\ncat1 cat2\n\nhostname cat1\nhostname cat2<\/code><\/pre>\n<h2>4.2\u914d\u7f6e\u7cfb\u7edf\u6587\u4ef6<\/h2>\n<pre><code class=\"language-sql\">--\/etc\/security\/limits.conf \u662f Linux \u8d44\u6e90\u4f7f\u7528\u914d\u7f6e\u6587\u4ef6\uff0c\u7528\u6765\u9650\u5236\u7528\u6237\u5bf9\u7cfb\u7edf\u8d44\u6e90\u7684\u4f7f\u7528 \n--https:\/\/www.cnblogs.com\/pzk7788\/p\/7250723.html\n\nvi \/etc\/security\/limits.conf\n\u6dfb\u52a0\ngrid soft nofile 1024\ngrid hard nofile 65536\ngrid soft stack 10240\ngrid hard stack 32768\ngrid soft nproc 16384\ngrid hard nproc 16384\n\noracle soft nofile 1024\noracle hard nofile 65536\noracle soft stack 10240\noracle hard stack 32768\noracle soft nproc 16384\noracle hard nproc 16384\nroot soft nproc 2047\n\nvi \/etc\/pam.d\/login \u6dfb\u52a0\uff1a\nsession required pam_limits.so \n\n\u8bbe\u7f6e\u5185\u6838\u53c2\u6570\uff0c\u7f16\u8f91\u6587\u4ef6\u5e76\u4f7f\u4e4b\u751f\u6548\uff0c\u5176\u503c\u4e0d\u5c0f\u4e8e\u5982\u4e0b\u8bbe\u7f6e\u3002\n\u4ee5\u4e0b\u662f\u53c2\u8003\u5185\u5bb9\nvi \/etc\/sysctl.conf\n#for oracle 19c rac \nfs.aio-max-nr = 4194304\nfs.file-max = 6815744\n####kernel setting\nkernel.shmall = 4194304\nkernel.shmmax = 16106127360\nkernel.shmmni = 4096\nkernel.sem = 250 32000 100 128\nkernel.panic_on_oops = 1\nkernel.panic = 10\n#### Net Setting\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 = 4194304\n####Memory Setting\nvm.vfs_cache_pressure=200 \nvm.swappiness=10\nvm.min_free_kbytes=102400\n#vm.nr_hugepages=10\n\n\u914d\u7f6e\u751f\u6548\uff0c\u5728\u5168\u90e8\u8282\u70b9\u64cd\u4f5c\nsysctl -p\n\nvi \/etc\/profile\u6dfb\u52a0\uff1a\nif [ $USER = &quot;oracle&quot; ] || [ $USER = &quot;grid&quot; ] ; then\n    if [ $SHELL = &quot;\/bin\/ksh&quot; ]; then\n       ulimit -u 16384\n       ulimit -n 65536\n    else\n       ulimit -u 16384 -n 65536\n    fi\nfi\n<\/code><\/pre>\n<h2>4.3\u7981\u7528SELinux\u3001\u9632\u706b\u5899\u3001NTP\u3001chrony\u670d\u52a1\u3001avahi-daemon<\/h2>\n<pre><code class=\"language-sql\">SELinux\u5efa\u8bae\u7981\u7528\u6b64\u529f\u80fd\u3002\nvi \/etc\/selinux\/config\nSELINUX=disabled\n\u9700\u8981\u91cd\u542f\u3002\n\u9632\u706b\u5899\u7981\u7528\uff1a\nsystemctl disable firewalld\nsystemctl stop firewalld\nsystemctl stop firewalld.service\nsystemctl disable firewalld.service\n\n\u9a8c\u8bc1\uff1a\nsystemctl list-unit-files | grep fire\n\u5173\u95edNTP:\nsystemctl stop ntpd.service\nsystemctl disable ntpd.service\nmv \/etc\/ntp.conf \/etc\/ntp.conf.orig\nsystemctl status ntpd\n\u25cf ntpd.service - Network Time Service\n   Loaded: loaded (\/usr\/lib\/systemd\/system\/ntpd.service; disabled; vendor preset: disabled)\n   Active: inactive (dead)\n\u5173\u95edchrony\u670d\u52a1\uff0c\u79fb\u9664chrony\u914d\u7f6e\u6587\u4ef6\u3002\nsystemctl list-unit-files|grep chronyd\nsystemctl status chronyd\n\nsystemctl disable chronyd\nsystemctl stop chronyd\n\nmv \/etc\/chrony.conf \/etc\/chrony.conf_bak\n\u5173\u95edavahi-daemon\nsystemctl stop avahi-daemon\nsystemctl disable avahi-daemon\n<\/code><\/pre>\n<h2>4.4 oracle\u3001grid\u7528\u6237\u73af\u5883\u53d8\u91cf\u914d\u7f6e<\/h2>\n<pre><code class=\"language-sql\">oracle\u7528\u6237\uff0c2\u4e2a\u8282\u70b9\u4e0a\u914d\u7f6e\uff1a\nvi ~\/.bash_profile  \u7f16\u8f91\u540esource ~\/.bash_profile\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\/19.3.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\nexport NLS_LANG=AMERICAN_AMERICA.UTF8\n\ngrid\u7528\u6237\uff0c2\u4e2a\u8282\u70b9\u4e0a\u914d\u7f6e\uff1a\nvi ~\/.bash_profile  \u7f16\u8f91\u540esource ~\/.bash_profile\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\/app\/19.3.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\nexport NLS_LANG=AMERICAN_AMERICA.UTF8<\/code><\/pre>\n<h2>4.5 \u914d\u7f6ezeroconf<\/h2>\n<pre><code class=\"language-sql\">vi \/etc\/sysconfig\/network\nNOZEROCONF=yes <\/code><\/pre>\n<h2>4.6 \u7981\u7528\u900f\u660e\u5927\u9875\uff08Transparent HugePages\uff09<\/h2>\n<pre><code class=\"language-sql\">cat \/sys\/kernel\/mm\/transparent_hugepage\/enabled   \/\/\u67e5\u770b\u72b6\u6001\n\nvi \/etc\/default\/grub\nGRUB_TIMEOUT=5\nGRUB_DISTRIBUTOR=&quot;$(sed &#039;s, release .*$,,g&#039; \/etc\/system-release)&quot;\nGRUB_DEFAULT=saved\nGRUB_DISABLE_SUBMENU=true\nGRUB_TERMINAL_OUTPUT=&quot;console&quot;\nGRUB_CMDLINE_LINUX=&quot;rhgb quiet transparent_hugepage=never&quot;\nGRUB_DISABLE_RECOVERY=&quot;true&quot;\n\n\u6267\u884c\u751f\u6548\u547d\u4ee4 grub2-mkconfig -o \/boot\/grub2\/grub.cfg\n\n\u91cd\u542fOS\u540e\u786e\u8ba4\u662f\u5426\u751f\u6548\n[root@test12c1 ~]# cat \/sys\/kernel\/mm\/transparent_hugepage\/enabled\nalways madvise [never] <\/code><\/pre>\n<h2>4.7 \u8bbe\u7f6eDisk I\/O Scheduler deadline<\/h2>\n<pre><code class=\"language-sql\">\u4e3a\u4e86\u83b7\u5f97Oracle ASM\u7684\u6700\u4f73\u6027\u80fd\uff0cOracle\u5efa\u8bae\u60a8\u4f7f\u7528Deadline I \/ O Scheduler\n\u78c1\u76d8I \/ O\u8c03\u5ea6\u7a0b\u5e8f\u5bf9\u78c1\u76d8I \/ O\u7684\u8bf7\u6c42\u8fdb\u884c\u91cd\u65b0\u6392\u5e8f\uff0c\u5ef6\u8fdf\u6216\u5408\u5e76\uff0c\u4ee5\u5b9e\u73b0\u66f4\u9ad8\u7684\u541e\u5410\u91cf\u548c\u66f4\u4f4e\u7684\u5ef6\u8fdf\u3002Linux\u6709\u591a\u4e2a\u78c1\u76d8I \/ O\u8c03\u5ea6\u7a0b\u5e8f\u53ef\u7528\uff0c\u5305\u62ecDeadline\uff0cNoop\uff0cAnticipatory\u548cCompletely Fair Queuing\uff08CFQ\uff09\u3002\nvi \/etc\/udev\/rules.d\/60-oracle-schedulers.rules\n\u6dfb\u52a0\u5982\u4e0b\u5185\u5bb9\nACTION==&quot;add|change&quot;, KERNEL==&quot;sd[a-z]&quot;, ATTR{queue\/rotational}==&quot;0&quot;, ATTR{queue\/scheduler}=&quot;deadline&quot;\n\n\u8fd0\u884c\u751f\u6548\nudevadm control --reload-rules <\/code><\/pre>\n<h2>4.8 \u914d\u7f6e\/dev\/shm\u5927\u5c0f<\/h2>\n<pre><code class=\"language-sql\">\u4e0d\u914d\u7f6e\u4f1a\u62a5\u9519ORA-00845,\u7b80\u5355\u8001\u8bf4\u5c31\u662fMEMORY_MAX_TARGET\u7684\u8bbe\u7f6e\u4e0d\u80fd\u8d85\u8fc7 \/dev\/shm\u7684\u5927\u5c0f\u3002\nvi \/etc\/fstab\ntmpfs \/dev\/shm tmpfs defaults,size=2G 0 0\n\n\u91cd\u65b0\u6302\u8f7d\uff1a\nmount -o remount \/dev\/shm\n\u9a8c\u8bc1\uff1a   df -h\n<\/code><\/pre>\n<h2>4.9 \u5173\u95edTHP\u53caNUMA(\u7c7b\u4f3c\u5173\u95ed\u900f\u660e\u5927\u9875\u64cd\u4f5c\uff0c\u53ef\u7565\u8fc7\u3002)<\/h2>\n<pre><code class=\"language-sql\">vi  \/etc\/default\/grub\n\u5728GRUB_CMDLINE_LINUX\u6dfb\u52a0\u4e0b\u5217\u9009\u9879\uff0c\u7528\u4e8e\u5173\u95edTHP\u548cNUMA\ntransparent_hugepage=never numa=off\n\u7f16\u8bd1\u5e76\u91cd\u542f\u4e3b\u673a     \ngrub2-mkconfig -o \/boot\/grub2\/grub.cfg\ngrub2-mkconfig -o \/boot\/efi\/EFI\/redhat\/grub.cfg<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\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":[49,51],"tags":[],"class_list":["post-916","post","type-post","status-publish","format-standard","hentry","category-oracle-19c","category--oracle-19c"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/916","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=916"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/916\/revisions"}],"predecessor-version":[{"id":917,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/916\/revisions\/917"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=916"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=916"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}