联系：手机/微信(+86 17813235971) QQ(107644445)
标题：安全漏洞扫描结果让人无语
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
对于安全公司对oracle漏洞扫描的结果的准确性一直不太认可,前几天有客户linux 平台11.2.0.4的数据库打上了210420的patch,结果xx安全厂商扫描之后,依旧有大量安全漏洞,我随机对其中的两个高危漏洞进行分析,结果发现主要有:已经修复的漏洞继续报,漏洞对应数据库版本和实际数据库不符
数据库库的补丁信息
联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
| 19.0.0.0 | |||
| Description | OJVMUpdate | OJVM+DBUpdate | OJVM+GIUpdate |
| JUL2021(19.12.0.0.210720) | 32876380 | 32900021 | 32900083 |
| APR2021(19.11.0.0.210420) | 32399816 | 32578972 | 32578973 |
| JAN2021(19.10.0.0.210119) | 32067171 | 32126828 | 32126842 |
| OCT2020(19.9.0.0.201020) | 31668882 | 31720396 | 31720429 |
| JUL2020(19.8.0.0.200714) | 31219897 | 31326362 | 31326369 |
| APR2020(19.7.0.0.200414) | 30805684 | 30783543 | 30783556 |
| JAN2020(19.6.0.0.200114) | 30484981 | 30463595 | 30463609 |
| OCT2019(19.5.0.0.191015) | 30128191 | 30133124 | 30133178 |
| JUL2019(19.4.0.0.190716) | 29774421 | 29699079 | 29699097 |
| APR2019(19.3.0.0.190416) | 29548437 | 29621253 | 29621299 |
| 19.0.0.0 | |||
| Description | DatabaseUpdate | GIUpdate | WindowsBundlePatch |
| JUL2021(19.12.0.0.0) | 32904851 | 32895426 | 32832237 |
| APR2021(19.11.0.0.0) | 32545013 | 32545008 | 32409154 |
| JAN2021(19.10.0.0.0) | 32218454 | 32226239 | 32062765 |
| OCT2020(19.9.0.0.0) | 31771877 | 31750108 | 31719903 |
| JUL2020(19.8.0.0.0) | 31281355 | 31305339 | 31247621 |
| APR2020(19.7.0.0.0) | 30869156 | 30899722 | 30901317 |
| JAN2020(19.6.0.0.0) | 30557433 | 30501910 | 30445947 |
| OCT2019(19.5.0.0.0) | 30125133 | 30116789 | 30151705 |
| JUL2019(19.4.0.0.0) | 29834717 | 29708769 | NA |
| APR2019(19.3.0.0.0) | 29517242 | 29517302 | NA |
| 18.0.0.0 | |||
| Description | OJVMUpdate | OJVM+DBUpdate | OJVM+GIUpdate |
| APR2021(18.14.0.0.210420) | 32552752 | 32579022 | 32579024 |
| JAN2021(18.13.0.0.210119) | 32119939 | 32126855 | 32126862 |
| OCT2020(18.12.0.0.201020) | 31668892 | 31720435 | 31720457 |
| JUL2020(18.11.0.0.200714) | 31219909 | 31326374 | 31326376 |
| APR2020(18.10.0.0.200414) | 30805598 | 30783603 | 30783607 |
| JAN2020(18.9.0.0.200114) | 30501926 | 30463620 | 30463635 |
| OCT2019(18.8.0.0.191015) | 30133603 | 30133203 | 30133246 |
| JUL2091(18.7.0.0.190716) | 29774410 | 29699112 | 29699160 |
| APR2019(18.6.0.0.190416) | 29249584 | 29249695 | 29251992 |
| JAN2019(18.5.0.0.190115) | 28790647 | 28980087 | 28980105 |
| OCT2018(18.4.0.0.181016) | 28502229 | 28689117 | 28689122 |
| JUL2018(18.3.0.0.180717) | 27923415 | 28317326 | 28317346 |
| APR2018(18.2.0.0.180417) | 27636900 | 27726465 | 27726470 |
| 18.0.0.0 | |||
| Description | DatabaseUpdate | GIUpdate | WindowsBundlePatch |
| APR2021(18.14.0.0.0) | 32524155 | 32524152 | 32438481 |
| JAN2021(18.13.0.0.0) | 32204699 | 32226219 | 32062760 |
| OCT2020(18.12.0.0.0) | 31730250 | 31748523 | 31629682 |
| JUL2020(18.11.0.0.0) | 31308624 | 31305362 | 31247612 |
| APR2020(18.10.0.0.0) | 30872794 | 30899645 | 30901451 |
| JAN2020(18.9.0.0.0) | 30480385 | 30480702 | 30445951 |
| OCT2019(18.8.0.0.0) | 30112122 | 30116795 | 30150321 |
| JUL2019(18.7.0.0.0) | 29757256 | 29708703 | 29859180 |
| APR2019(18.6.0.0.0) | 29301631 | 29301682 | 29589622 |
| JAN2019(18.5.0.0.0) | 28822489 | 28828717 | 29124511 |
| OCT2018(18.4.0.0.0) | 28655784 | 28659165 | NA |
| JUL2018(18.3.0.0.0) | 28090523 | 28096386 | NA |
| APR2018(18.2.0.0.0) | 27676517 | 27681568 | NA |
| 12.2.0.1 | ||||
| Description | OJVMUpdate | OJVMWindowsBundlePatch | ComboOJVM+DBUpdate | ComboOJVM+GIUpdate |
| JUL2021(12.2.0.1.210720) | 32876409 | 32905896 | 32900144 | 32900156 |
| APR2021(12.2.0.1.210420) | 32473172 | 32427674 | 32579049 | 32579057 |
| JAN2021(12.2.0.1.210119) | 32119931 | 32142294 | 32126871 | 32226491 |
| OCT2020(12.2.0.1.201020) | 31668898 | 31740064 | 31720473 | 31720486 |
| JUL2020(12.2.0.1.200714) | 31219919 | 31465105 | 31326379 | 31326390 |
| APR2020(12.2.0.1.200414) | 30805580 | 31035002 | 30783641 | 30783652 |
| JAN2020(12.2.0.1.200114) | 30502018 | 30525838 | 30463660 | 30463673 |
| OCT2019(12.2.0.1.191015) | 30133625 | 30268021 | 30133374 | 30133386 |
| JUL2019(12.2.0.1.190716) | 29774415 | 29837425 | 29699168 | 29699173 |
| APR2019(12.2.0.1.190416) | 29249637 | 29281550 | 29252035 | 29252072 |
| JAN2019(12.2.0.1.190115) | 28790651 | 28994068 | 28980102 | 28980109 |
| NOV2018(12.2.0.1.181130) | NA | 28412314 | NA | NA |
| OCT2018(12.2.0.1.181016) | 28440725 | 28412312 | 28689128 | 28689130 |
| JUL2018(12.2.0.1.180717) | 27923353 | 28135129 | 28317292 | 28317269 |
| APR2018(12.2.0.1.180417) | 27475613 | 27650410 | 27726453 | 27726454 |
| JAN2018(12.2.0.1.180116) | 27001739 | 27162975 | 27010695 | 27010711 |
| OCT2017(12.2.0.1.171017) | 26635944 | 26792369 | 26636004 | 26636246 |
| AUG2017(12.2.0.1.170814) | N/A | 26565082 | 26550033 | 26550314 |
| JUL2017(12.2.0.1.170718) | 25811364 | 26182467 | 26146314 | 26146318 |
| 12.2.0.1 | |||
| Description | DatabaseUpdate | GIUpdate | WindowsBundlePatch |
| JUL2021(12.2.0.1.210720) | 32916808 | 32928749 | 32775037 |
| APR2021(12.2.0.1.210420) | 32507738 | 32540149 | 32392089 |
| JAN2021(12.2.0.1.210119) | 32228578 | 32226491 | 31987852 |
| OCT2020(12.2.0.1.201020) | 31741641 | 31750094 | 31654782 |
| JUL2020(12.2.0.1.200714) | 31312468 | 31305382 | 31210848 |
| APR2020(12.2.0.1.200414) | 30886680 | 30920127 | 30861472 |
| JAN2020(12.2.0.1.200114) | 30593149 | 30501932 | 30446296 |
| OCT2019(12.2.0.1.191015) | 30138470 | 30116802 | 30150416 |
| JUL2019(12.2.0.1.190716) | 29757449 | 29708720 | 29832062 |
| APR2019(12.2.0.1.190416) | 29314339 | 29301687 | 29394003 |
| JAN2019(12.2.0.1.190115) | 28822515 | 28828733 | 28810696 |
| NOV2018(12.2.0.1.181130) | NA | NA | 28810550(64bit) |
| OCT2018(12.2.0.1.181016) | 28662603 | 28714316 | 28574555 |
| JUL2018(12.2.0.1.180717) | 28163133 | NA | 27937914 |
| APR2018(12.2.0.1.180417) | 27674384 | 27468969 | 27426753 |
| JAN2018(12.2.0.1.180116) | 27105253 | 27100009 | 27162931 |
| NOV2017(12.2.0.1.171121) | NA | 27010638 | NA |
| OCT2017(12.2.0.1.171017) | 26710464 | 26737266 | 26758841 |
| AUG2017(12.2.0.1.170814) | 26609817 | 26610291 | 26204214 |
| JUL2017(12.2.0.1.170718) | 26123830 | 26133434 | 26204212 |
| 12.1.0.2 | ||||||
| Description | OJVMPSU(Linux/Unix) | OJVMBP(Windows) | ComboOJVM+DBPSU | ComboOJVM+GIPSU | ComboOJVM+DBProactiveBP | GenericJDBC |
| JUL2021(12.1.0.2.210720) | 32876425 | 32905878 | 32900172 | 32900185 | 32900201 | IncludedinOJVMPSU |
| APR2021(12.1.0.2.210420) | 32473164 | 32427683 | 32579074 | 32579077 | 32579100 | IncludedinOJVMPSU |
| JAN2021(12.1.0.2.210119) | 32119956 | 32142066 | 32126886 | 32126899 | 32126908 | IncludedinOJVMPSU |
| OCT2020(12.1.0.2.201020) | 31668915 | 31740134 | 31720729 | 31720761 | 31720769 | IncludedinOJVMPSU |
| JUL2020(12.1.0.2.200714) | 31219939 | 31465095 | 31326396 | 31326400 | 31326402 | IncludedinOJVMPSU |
| APR2020(12.1.0.2.200414) | 30805558 | 31037459 | 30783658 | 30783882 | 30783885 | IncludedinOJVMPSU |
| JAN2020(12.1.0.2.200114) | 30502041 | 30671054 | 30463684 | 30463691 | 30463708 | IncludedinOJVMPSU |
| OCT2019(12.1.0.2.191015) | 30128197 | 30268189 | 30133412 | 30133443 | 30133464 | IncludedinOJVMPSU |
| JUL2019(12.1.0.2.190716) | 29774383 | 29837393 | 29699220 | 29699244 | 29699255 | IncludedinOJVMPSU |
| APR2019(12.1.0.2.190416) | 29251241 | 29447962 | 29252146 | 29252164 | 29252171 | IncludedinOJVMPSU |
| JAN2019(12.1.0.2.190115) | 28790654 | 28994063 | 28980115 | 28980120 | 28980123 | IncludedinOJVMPSU |
| NOV2018(12.1.0.2.181130) | NA | 28412301 | NA | NA | NA | IncludedinOJVMPSU |
| OCT2018(12.1.0.2.181016) | 28440711 | 28412299 | 28689146 | 28689148 | 28689151 | IncludedinOJVMPSU |
| JUL2018(12.1.0.2.180717) | 27923320 | 28135126 | 28317232 | 28317214 | 28317206 | IncludedinOJVMPSU |
| APR2018(12.1.0.2.180417) | 27475603 | 27650403 | 27726471 | 27726478 | 27726492 | IncludedinOJVMPSU |
| JAN2018(12.1.0.2.180116) | 27001733 | 27162998 | 27010839 | 27010888 | 27010941 | IncludedinOJVMPSU |
| OCT2017(12.1.0.2.171017) | 26635845 | 26792364 | 26636270 | 26636286 | 26636295 | IncludedinOJVMPSU |
| AUG2017(12.1.0.2.170814) | N/A | 26182441 | 26550023 | 26550339 | 26550390 | IncludedinOJVMPSU |
| JUL2017(12.1.0.2.170718) | 26027162 | 26182439 | 25901056 | 26030704 | 26030586 | IncludedinOJVMPSU |
| APR2017(12.1.0.2.170418) | 25437695 | 25590993 | 25433980 | 25434018 | 25437795 | IncludedinOJVMPSU |
| JAN2017(12.1.0.2.170117) | 24917972 | 25112498 | 24917069 | 24917916 | 24917987 | IncludedinOJVMPSU |
| OCT2016(12.1.0.2.161018) | 24315824 | 24591630 | 24433133 | 24433148 | 24436306 | IncludedinOJVMPSU |
| JUL2016(12.1.0.2.160719) | 23177536 | 23515290 | 23615289 | 23615308 | 23615334 | 23727148(IncludedinOJVMPSU) |
| APR2016(12.1.0.2.160419) | 22674709 | 22839633 | 22738582 | 22738641 | 22738657 | N/A |
| JAN2016(12.1.0.2.160119) | 22139226 | 22311086 | 22191659 | 22191676 | 22378102 | |
| OCT2015 | 21555660(12.1.0.2.5) | 21788394(12.1.0.2.4) | 21520444 | 21523260 | 21744313 | |
| JUL2015 | 21068507(12.1.0.2.4) | 21153530(12.1.0.2.3) | 21150768 | 21150782 | 21150792 | |
| APR2015 | 20415564(12.1.0.2.3) | 20391199(12.1.0.2.2) | 20834354 | 20834538 | 20834553 | |
| JAN2015 | 19877336(12.1.0.2.2) | 20225938(12.1.0.2.1) | 20132434 | 20132450 | 20132462 | |
| OCT2014(12.1.0.2.1) | 19282028 | 19791366 | 19791375 | 19791399 | ||
| 12.1.0.2 | ||||
| Description | PSU | GIPSU | ProactiveBundlePatch | BundlePatch(Windows32bit&64bit) |
| JUL2021(12.1.0.2.210720) | 32768233 | 32917447 | 32917362 | 32774982 |
| APR2021(12.1.0.2.210420) | 32328635 | 32495126 | 32518631 | 32396181 |
| JAN2021(12.1.0.2.210119) | 31985579 | 32131261 | 32131231 | 32000405 |
| OCT2020(12.1.0.2.201020) | 31550110 | 31718737 | 31718813 | 31658987 |
| JUL2020(12.1.0.2.200714) | 31113348 | 31305174 | 31307682 | 31211574 |
| APR2020(12.1.0.2.200414) | 30700212 | 30805421 | 30805478 | 30861721 |
| JAN2020(12.1.0.2.200114) | 30340202 | 30464119 | 30464171 | 30455401 |
| OCT2019(12.1.0.2.191015) | 29918340 | 30070257 | 30070242 | 30049606 |
| JUL2019(12.1.0.2.190716) | 29494060 | 29698592 | 29698629 | 29831650 |
| APR2019(12.1.0.2.190416) | 29141015 | 29176115 | 29176139 | 29413116 |
| JAN2019(12.1.0.2.190115) | 28729169 | 28813884 | 28833531 | 28810679 |
| NOV2018(12.1.0.2.181130) | NA | NA | NA | 28810544(64bit) |
| OCT2018(12.1.0.2.181016) | 28259833 | 28349311 | 28349951 | 28563501 |
| JUL2018(12.1.0.2.180717) | 27547329 | 27967747 | 27968010 | 27937907 |
| APR2018(12.1.0.2.180417) | 27338041 | 27468957 | 27486326 | 27440294 |
| JAN2018(12.1.0.2.180116) | 26925311 | 27010872 | 27010930 | 27162953 |
| OCT2017(12.1.0.2.171017) | 26713565 | 26635815 | 26635880 | 26720785 |
| AUG2017(12.1.0.2.170814) | 26609783 | 26610308 | 26610322 | 26161726 |
| JUL2017(12.1.0.2.170718) | 25755742 | 25901062 | 26022196 | 26161724 |
| APR2017(12.1.0.2.170418) | 25171037 | 25434003 | 25433352 | 25632533 |
| JAN2017(12.1.0.2.170117) | 24732082 | 24917825 | 24968615 | 25115951 |
| OCT2016(12.1.0.2.161018) | 24006101 | 24412235 | 24448103 | 24591642 |
| JUL2016(12.1.0.2.160719) | 23054246 | 23273629 | 23273686 | 23530387 |
| APR2016(12.1.0.2.160419) | 22291127 | 22646084 | 22899531 | 22809813 |
| JAN2016(12.1.0.2.160119) | 21948354 | 22191349 | 22243551 | 22310559 |
| OCT2015 | 21359755(12.1.0.2.5) | 21523234(12.1.0.2.5) | 21744410(12.1.0.2.13) | 21821214(12.1.0.2.10) |
| JUL2015 | 20831110(12.1.0.2.4) | 20996835(12.1.0.2.4) | 21188742(12.1.0.2.10) | 21126814(12.1.0.2.7) |
| APR2015 | 20299023(12.1.0.2.3) | 20485724(12.1.0.2.3) | 20698050(12.1.0.2.7) | 20684004(12.1.0.2.4) |
| JAN2015 | 19769480(12.1.0.2.2) | 19954978(12.1.0.2.2) | 20141343(12.1.0.2.4) | 19720843(12.1.0.2.1) |
| OCT2014 | 19303936(12.1.0.2.1) | 19392646(12.1.0.2.1) | 19404326(12.1.0.2.1) | N/A |
参考：Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)
联系：手机/微信(+86 17813235971) QQ(107644445)
标题：提供19.11(含202104patch)完整版db和grid下载
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
最近实施了一套19c rac并且打上patch 32545008(GI Update 202104)和32399816(OJVM Update 202104),通过createGoldImage 创建了安装程序,直接使用该zip包即可安装含gi/db(含ojvm) 2021年4月的patch
[oracle@dzbl1 ~]$ $ORACLE_HOME/runInstaller -createGoldImage -silent -destinationLocation /tmp/soft_img Launching Oracle Database Setup Wizard... Successfully Setup Software. Gold Image location: /tmp/soft_img/db_home_2021-05-20_09-05-40PM.zip [oracle@dzbl1 ~]$ exit logout [root@dzbl1 ~]# su - grid Last login: Thu May 20 20:57:05 CST 2021 [grid@dzbl1 ~]$ ./gridSetup.sh -createGoldImage -silent -destinationLocation /tmp/soft_img -bash: ./gridSetup.sh: No such file or directory [grid@dzbl1 ~]$ $ORACLE_HOME/gridSetup.sh -createGoldImage -silent -destinationLocation /tmp/soft_img Launching Oracle Grid Infrastructure Setup Wizard... Successfully Setup Software. Gold Image location: /tmp/soft_img/grid_home_2021-05-20_09-13-58PM.zip [grid@dzbl1 ~]$ md5sum /tmp/soft_img/grid_home_2021-05-20_09-13-58PM.zip 7cefb1be8ead8250435d5a95785d1239 /tmp/soft_img/grid_home_2021-05-20_09-13-58PM.zip [grid@dzbl1 ~]$ md5sum /tmp/soft_img/db_home_2021-05-20_09-05-40PM.zip 325841792c44f168c524b440440773b0 /tmp/soft_img/db_home_2021-05-20_09-05-40PM.zip [grid@dzbl1 ~]$ opatch lspatches 32585572;DBWLM RELEASE UPDATE 19.0.0.0.0 (32585572) 32584670;TOMCAT RELEASE UPDATE 19.0.0.0.0 (32584670) 32579761;OCW RELEASE UPDATE 19.11.0.0.0 (32579761) 32576499;ACFS RELEASE UPDATE 19.11.0.0.0 (32576499) 32545013;Database Release Update : 19.11.0.0.210420 (32545013) OPatch succeeded. [grid@dzbl1 ~]$ su - oracle Password: Last login: Thu May 20 21:04:33 CST 2021 on pts/1 [oracle@dzbl1 ~]$ opatch lspatches 32399816;OJVM RELEASE UPDATE: 19.11.0.0.210420 (32399816) 32579761;OCW RELEASE UPDATE 19.11.0.0.0 (32579761) 32545013;Database Release Update : 19.11.0.0.210420 (32545013) OPatch succeeded. [oracle@dzbl1 ~]$ ls -l /tmp/soft_img/ total 9225956 -rw-r--r-- 1 oracle oinstall 4268265132 May 20 21:13 db_home_2021-05-20_09-05-40PM.zip -rw-r--r-- 1 grid oinstall 5179109549 May 20 21:21 grid_home_2021-05-20_09-13-58PM.zip [oracle@dzbl1 ~]$
C:\Users\XFF>CertUtil -hashfile E:\vm_shared\LINUX.X64_1911000_grid_home.zip md5 MD5 的 E:\vm_shared\LINUX.X64_1911000_grid_home.zip 哈希: 7cefb1be8ead8250435d5a95785d1239 CertUtil: -hashfile 命令成功完成。 C:\Users\XFF>CertUtil -hashfile E:\vm_shared\LINUX.X64_1911000_db_home.zip md5 MD5 的 E:\vm_shared\LINUX.X64_1911000_db_home.zip 哈希: 325841792c44f168c524b440440773b0 CertUtil: -hashfile 命令成功完成。
提供下载link,可以直接下载19.11完整版db和grid(该版本含2021年4月份patch):Oracle 19.11 database和grid软件下载,提取码为:bamf.下载之后请验证md5,确认没有别其他人修改.
联系：手机/微信(+86 17813235971) QQ(107644445)
标题：公有云安装19c rac遇到问题—169网段udp异常
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
应客户要求在xx公有云上面安装19c rac,通过各方的努力,最后安装情况如下
1. 两个节点root.sh执行成功,crs启动正常,asm磁盘组访问正常,但是有一个节点asm实例无法启动,一个节点的db实例无法启动
---节点1
[root@dzbl1 ~]# su - grid
Last login: Thu May 20 12:32:55 CST 2021
[grid@dzbl1 ~]$ ps -ef|grep ASM
grid 477 1 0 May19 ? 00:00:24 /u01/app/19c/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
grid 22075 22039 0 12:42 pts/1 00:00:00 grep --color=auto ASM
[grid@dzbl1 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 1907344 1904420 0 1904420 0 N DATA/
MOUNTED EXTERN N 512 512 4096 4194304 1150344 1149032 0 1149032 0 N FRA/
MOUNTED EXTERN N 512 512 4096 4194304 14304 13988 0 13988 0 Y SYSTEMDG/
ASMCMD> exit
[grid@dzbl1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE dzbl1 STABLE
ONLINE ONLINE dzbl2 STABLE
ora.chad
ONLINE ONLINE dzbl1 STABLE
ONLINE ONLINE dzbl2 STABLE
ora.net1.network
ONLINE ONLINE dzbl1 STABLE
ONLINE ONLINE dzbl2 STABLE
ora.ons
ONLINE ONLINE dzbl1 STABLE
ONLINE ONLINE dzbl2 STABLE
ora.proxy_advm
OFFLINE OFFLINE dzbl1 STABLE
OFFLINE OFFLINE dzbl2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE dzbl1 STABLE
2 ONLINE ONLINE dzbl2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE dzbl2 STABLE
3 OFFLINE OFFLINE STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE dzbl2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE dzbl2 STABLE
ora.SYSTEMDG.dg(ora.asmgroup)
1 OFFLINE OFFLINE STABLE
2 ONLINE ONLINE dzbl2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE dzbl2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE dzbl1 STABLE
2 ONLINE ONLINE dzbl2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE dzbl2 STABLE
ora.dzbl1.vip
1 ONLINE ONLINE dzbl1 STABLE
ora.dzbl2.vip
1 ONLINE ONLINE dzbl2 STABLE
ora.dzbldb.db
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE dzbl2 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
ora.qosmserver
1 ONLINE ONLINE dzbl2 STABLE
ora.scan1.vip
1 ONLINE ONLINE dzbl2 STABLE
--------------------------------------------------------------------------------
[grid@dzbl1 ~]$
---节点2
[grid@dzbl2 ~]$ ps -ef|grep ASM
grid 2464 1 0 May18 ? 00:00:29 /u01/app/19c/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
grid 6826 1 0 May19 ? 00:00:09 oracle+ASM2_asmb_dzbldb2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 14089 1 0 12:38 ? 00:00:00 asm_m000_+ASM2
grid 15670 1 0 12:40 ? 00:00:00 oracle+ASM2_crf (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 16503 1 0 May18 ? 00:00:05 asm_pmon_+ASM2
grid 16505 1 0 May18 ? 00:00:04 asm_clmn_+ASM2
grid 16507 1 0 May18 ? 00:00:11 asm_psp0_+ASM2
grid 16518 1 0 12:42 ? 00:00:00 oracle+ASM2 (LOCAL=NO)
grid 16562 1 0 May18 ? 00:18:22 asm_vktm_+ASM2
grid 16567 1 0 May18 ? 00:00:08 asm_gen0_+ASM2
grid 16569 1 0 May18 ? 00:00:02 asm_mman_+ASM2
grid 16573 1 0 May18 ? 00:00:06 asm_gen1_+ASM2
grid 16577 1 0 May18 ? 00:01:13 asm_diag_+ASM2
grid 16579 1 0 May18 ? 00:00:04 asm_ping_+ASM2
grid 16581 1 0 May18 ? 00:00:09 asm_pman_+ASM2
grid 16583 1 0 May18 ? 00:03:08 asm_dia0_+ASM2
grid 16585 1 0 May18 ? 00:01:41 asm_lmon_+ASM2
grid 16587 1 0 May18 ? 00:01:55 asm_lmd0_+ASM2
grid 16589 1 0 May18 ? 00:04:26 asm_lms0_+ASM2
grid 16591 1 0 May18 ? 00:02:13 asm_lmhb_+ASM2
grid 16596 1 0 May18 ? 00:00:02 asm_lck1_+ASM2
grid 16598 1 0 May18 ? 00:00:02 asm_dbw0_+ASM2
grid 16600 1 0 May18 ? 00:00:02 asm_lgwr_+ASM2
grid 16602 1 0 May18 ? 00:00:05 asm_ckpt_+ASM2
grid 16604 1 0 May18 ? 00:00:01 asm_smon_+ASM2
grid 16606 1 0 May18 ? 00:00:02 asm_lreg_+ASM2
grid 16608 1 0 May18 ? 00:00:01 asm_pxmn_+ASM2
grid 16610 1 0 May18 ? 00:00:11 asm_rbal_+ASM2
grid 16612 1 0 May18 ? 00:00:24 asm_gmon_+ASM2
grid 16614 1 0 May18 ? 00:00:06 asm_mmon_+ASM2
grid 16616 1 0 May18 ? 00:00:47 asm_mmnl_+ASM2
grid 16618 1 0 May18 ? 00:02:52 asm_imr0_+ASM2
grid 16627 1 0 May18 ? 00:00:30 asm_scm0_+ASM2
grid 16633 1 0 May18 ? 00:00:11 asm_lck0_+ASM2
grid 16662 1 0 May18 ? 00:07:10 asm_gcr0_+ASM2
grid 16699 1 0 May19 ? 00:00:00 oracle+ASM2 (LOCAL=NO)
grid 16746 1 0 May18 ? 00:00:06 asm_asmb_+ASM2
grid 16748 1 0 May18 ? 00:00:13 oracle+ASM2_asmb_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 16756 1 0 May18 ? 00:00:00 oracle+ASM2_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 17567 1 0 May18 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 17622 17536 0 12:43 pts/1 00:00:00 grep --color=auto ASM
grid 27829 1 0 May18 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[grid@dzbl2 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 1907344 1904420 0 1904420 0 N DATA/
MOUNTED EXTERN N 512 512 4096 4194304 1150344 1149032 0 1149032 0 N FRA/
MOUNTED EXTERN N 512 512 4096 4194304 14304 13988 0 13988 0 Y SYSTEMDG/
ASMCMD> exit
[grid@dzbl2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE dzbl1 STABLE
ONLINE ONLINE dzbl2 STABLE
ora.chad
ONLINE ONLINE dzbl1 STABLE
ONLINE ONLINE dzbl2 STABLE
ora.net1.network
ONLINE ONLINE dzbl1 STABLE
ONLINE ONLINE dzbl2 STABLE
ora.ons
ONLINE ONLINE dzbl1 STABLE
ONLINE ONLINE dzbl2 STABLE
ora.proxy_advm
OFFLINE OFFLINE dzbl1 STABLE
OFFLINE OFFLINE dzbl2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE dzbl1 STABLE
2 ONLINE ONLINE dzbl2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE dzbl2 STABLE
3 OFFLINE OFFLINE STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE dzbl2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE dzbl2 STABLE
ora.SYSTEMDG.dg(ora.asmgroup)
1 OFFLINE OFFLINE STABLE
2 ONLINE ONLINE dzbl2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE dzbl2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE dzbl1 STABLE
2 ONLINE ONLINE dzbl2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE dzbl2 STABLE
ora.dzbl1.vip
1 ONLINE ONLINE dzbl1 STABLE
ora.dzbl2.vip
1 ONLINE ONLINE dzbl2 STABLE
ora.dzbldb.db
1 ONLINE OFFLINE STABLE
2 ONLINE ONLINE dzbl2 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
ora.qosmserver
1 ONLINE ONLINE dzbl2 STABLE
ora.scan1.vip
1 ONLINE ONLINE dzbl2 STABLE
--------------------------------------------------------------------------------
[grid@dzbl2 ~]$
2. 分析db和asm有一个实例无法启动原因分析
--实例启动报错
SQL> startup
ORA-03113: end-of-file on communication channel
--无法启动节点alert日志
2021-05-19T12:41:32.143124+08:00
NOTE: ASMB (index:0) registering with ASM instance as Flex client 0xffffffffffffffff (reg:2449521867) (startid:1072960888) (new connection)
2021-05-19T12:41:32.349766+08:00
My CSS node number is 1
My CSS hostname is dzbl1
lmon registered with NM - instance number 1 (internal mem no 0)
2021-05-19T12:41:34.054865+08:00
Using default pga_aggregate_limit of 16384 MB
2021-05-19T12:42:16.978085+08:00
No connectivity to other instances in the cluster during startup. Hence, LMON is terminating the instance. Please check the LMON trace file for details.
Also, please check the network logs of this instance along with clusterwide network health for problems and then re-start this instance.
LMON (ospid: ): terminating the instance due to ORA error
Cause - 'Instance is being terminated by LMON'
2021-05-19T12:42:17.115807+08:00
System state dump requested by (instance=1, osid=29660 (LMON)), summary=[abnormal instance termination]. error - 'Instance is terminating.
System State dumped to trace file /u01/app/oracle/diag/rdbms/dzbldb/dzbldb1/trace/dzbldb1_diag_29641.trc
2021-05-19T12:42:17.227469+08:00
Dumping diagnostic data in directory=[cdmp_20210519124217], requested by (instance=1, osid=29660 (LMON)), summary=[abnormal instance termination].
2021-05-19T12:42:18.344481+08:00
Instance terminated by LMON, pid = 29660
--正常节点lmon日志
*** 2021-05-19T12:42:29.348455+08:00
IPCLW:[0.16]{-}[CNCT]:PROTO: [1621399349248289]Warning! ACNH://0x7f3d993a7990/peer=[UNKNWN]&ospid=0&msn=993097808&seq=995707504
(169.254.14.18:32056) has outstanding sends during delete.
IPCLW:[0.17]{-}[CNCT]:UTIL: [1621399349248289] ACNH 0x7f3d993a7990 State: 2 SMSN: 993097806 PKT(993097808.995707504) # Pending: 2
IPCLW:[0.18]{-}[CNCT]:UTIL: [1621399349248289] Peer: [UNKNWN].0 AckSeq: 0
IPCLW:[0.19]{-}[CNCT]:UTIL: [1621399349248289] Flags: 0x40000000 IHint: 0x30693d920000001f THint: 0x0
IPCLW:[0.20]{-}[CNCT]:UTIL: [1621399349248289] Local Address: 169.254.17.231:19443 Remote Address: 169.254.14.18:32056
IPCLW:[0.21]{-}[CNCT]:UTIL: [1621399349248289] Remote PID: ver 0 flags 1 trans 2 tos 0 opts 0 xdata3 165f xdata2 70dbd629
IPCLW:[0.22]{-}[CNCT]:UTIL: [1621399349248289] : mmsz 32768 mmr 4096 mms 4096 xdata c2a71bf9
IPCLW:[0.23]{-}[CNCT]:UTIL: [1621399349248289] IVPort: 46944 TVPort: 7161 IMPT: 25433 RMPT: 5727 Pending Sends: Yes Unacked Sends: Yes
IPCLW:[0.24]{-}[CNCT]:UTIL: [1621399349248289] Send Engine Queued: No sshdl -1 ssts 0 rtts 0 snderrchk 0 creqcnt 19 credits 0/0
IPCLW:[0.25]{-}[CNCT]:UTIL: [1621399349248289] Unackd Messages 993097806 -> 993097807. SSEQ 995707502 Send Time:
INVALID TIME SMSN # Xmits: 0 EMSN INVALID TIME
IPCLW:[0.26]{-}[CNCT]:UTIL: [1621399349248289] Pending send queue:
IPCLW:[0.27]{-}[CNCT]:UTIL: [1621399349248289] [0] mbuf 0x7f3d99397770 MSN 993097806 Seq 995707502 -> 995707503 # XMits: 0
IPCLW:[0.28]{-}[CNCT]:UTIL: [1621399349248289] [1] mbuf 0x7f3d99397350 MSN 993097807 Seq 995707503 -> 995707504 # XMits: 0
kjxgfipccb: msg 0x7f3d9934a680, mbo 0x7f3d9934a670, type 24, ack 0, ref 0, stat 34
kjxgfipccb: msg 0x7f3d9934a878, mbo 0x7f3d9934a868, type 18, ack 0, ref 0, stat 34
从日志看异常节点的169.254.14.18:32056和169.254.17.231:19443无法使用udp进行通讯,参考:Only One Instance of a RAC Database Can Start at a Time: Second Instance Fails to Start due to “No reconfig messages from other instances” – LMON is terminating the instance (Doc ID 2528588.1),从而使得asm和db实例只能启动一个节点.到目前为止,初步看很可能是公有云的对于169.254网段的某些限制导致.
对于两个节点asm磁盘组mount,crs正常启动.这个是由于使用的是fiex asm技术实现(在asm实例启动正常情况下直接启动本地asm实例,在本地asm实例无法正常启动,通过fiex asm实现磁盘组正常mount)
联系：手机/微信(+86 17813235971) QQ(107644445)
标题：记录在linux 7中安装11.2.0.4 RAC遇到问题
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
还有客户要求在linux 7平台中安装11.2.0.4的RAC,在这次的安装过程中,参考了Installation walk-through – Oracle Grid/RAC 11.2.0.4 on Oracle Linux 7 (Doc ID 1951613.1)文档,在安装grid的时候,执行root.sh执行,打上了patch 18370031,root.sh脚本非常顺利执行成功
打patch 18370031操作
一定要在gi安装执行root.sh之前打该patch
[grid@ptdb1 soft]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /tmp/soft/18370031 Oracle Interim Patch Installer version 11.2.0.3.27 Copyright (c) 2021, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/11.2.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/11.2.0/grid/oraInst.loc OPatch version : 11.2.0.3.27 OUI version : 11.2.0.4.0 Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2021-05-19_20-06-19PM_1.log Verifying environment and performing prerequisite checks... -------------------------------------------------------------------------------- Start OOP by Prereq process. Launch OOP... Oracle Interim Patch Installer version 11.2.0.3.27 Copyright (c) 2021, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/11.2.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/11.2.0/grid/oraInst.loc OPatch version : 11.2.0.3.27 OUI version : 11.2.0.4.0 Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2021-05-19_20-06-40PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 18370031 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/11.2.0/grid') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '18370031' to OH '/u01/app/11.2.0/grid' Patching component oracle.crs, 11.2.0.4.0... Patch 18370031 successfully applied. Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2021-05-19_20-06-40PM_1.log OPatch succeeded.
两个节点执行root.sh操作
[root@ptdb1 rpm]# /u01/app/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
OLR initialization - successful
root wallet
root wallet cert
root cert export
peer wallet
profile reader wallet
pa wallet
peer wallet keys
pa wallet keys
peer cert request
pa cert request
peer cert
pa cert
peer root cert TP
profile reader root cert TP
pa root cert TP
peer pa cert TP
pa peer cert TP
profile reader pa cert TP
profile reader peer cert TP
peer user cert
pa user cert
Adding Clusterware entries to oracle-ohasd.service
CRS-2672: Attempting to start 'ora.mdnsd' on 'ptdb1'
CRS-2676: Start of 'ora.mdnsd' on 'ptdb1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'ptdb1'
CRS-2676: Start of 'ora.gpnpd' on 'ptdb1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'ptdb1'
CRS-2672: Attempting to start 'ora.gipcd' on 'ptdb1'
CRS-2676: Start of 'ora.cssdmonitor' on 'ptdb1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'ptdb1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'ptdb1'
CRS-2672: Attempting to start 'ora.diskmon' on 'ptdb1'
CRS-2676: Start of 'ora.diskmon' on 'ptdb1' succeeded
CRS-2676: Start of 'ora.cssd' on 'ptdb1' succeeded
ASM created and started successfully.
Disk Group SYSDG created successfully.
clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4256: Updating the profile
Successful addition of voting disk 2ad9ee4ec49f4fe2bf80f0c7006bd395.
Successfully replaced voting disk group with +SYSDG.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 2ad9ee4ec49f4fe2bf80f0c7006bd395 (/dev/sdb) [SYSDG]
Located 1 voting disk(s).
CRS-2672: Attempting to start 'ora.asm' on 'ptdb1'
CRS-2676: Start of 'ora.asm' on 'ptdb1' succeeded
CRS-2672: Attempting to start 'ora.SYSDG.dg' on 'ptdb1'
CRS-2676: Start of 'ora.SYSDG.dg' on 'ptdb1' succeeded
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
--节点2
[root@ptdb2 ~]# /u01/app/11.2.0/grid/root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
OLR initialization - successful
Adding Clusterware entries to oracle-ohasd.service
CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node ptdb1,
number 1, and is terminating
An active cluster was found during exclusive startup, restarting to join the cluster
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
不安装该patch的,手动在systemd中添加ohasd服务
在root.sh执行过程中，待/etc/init.d/目录下生成了init.ohasd 文件后执行systemctl start ohasd.service 启动ohasd服务即可。若没有/etc/init.d/init.ohasd文件 systemctl start ohasd.service 则会启动失败,如果没有及时启动ohasd服务,导致root.sh执行失败,可以在启动ohasd服务之后,重新执行root.sh
(1).创建一个空服务文件：/usr/lib/systemd/system/ohasd.service touch /usr/lib/systemd/system/ohasd.service (2).编辑文件ohasd.service添加如下内容 vi /usr/lib/systemd/system/ohasd.service [Unit] Description=Oracle High Availability Services After=syslog.target [Service] ExecStart=/etc/init.d/init.ohasd run >/dev/null 2>&1 Type=simple Restart=always [Install] WantedBy=multi-user.target (3).添加和启动服务 systemctl daemon-reload systemctl enable ohasd.service systemctl start ohasd.service
安装db软件时无法发现节点
[grid@ptdb1 bin]$ pwd
/u01/app/11.2.0/grid/oui/bin
[grid@ptdb1 bin]$ ./runInstaller -silent -ignoreSysPrereqs -updateNodeList
>ORACLE_HOME=$ORACLE_HOME LOCAL_NODE="ptdb1" CLUSTER_NODES="{ptdb1,ptdb2}" CRS=true
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 8062 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
INS-35423错误解决
./runInstaller -jreLoc /etc/alternatives/jre_1.8.0 ORACLE_HOSTNAME="ptdb1"
安装db遇到Error in invoking target ‘agent nmhs’ of makefile ‘
这个是一个特别常见的错误,如果不使用dbcontrol,该错误可以直接忽略,或者采用类似方法处理
对$ORACLE_HOME/sysman/lib/ins_emagent.mk文件中的$(MK_EMAGENT_NMECTL)修改为$(MK_EMAGENT_NMECTL) -lnnz11,然后重试
 |
|