HPUX系统Oracle RAC如何添加ASM磁盘
前言 HPUX简介
HP-UX (Hewlett-Packard Unix) 是惠普公司开发的类 Unix 操作系统。自 1980 年代问世以来,HP-UX 在技术和功能上不断发展,适应了多种硬件平台和企业计算需求。以下是 HP-UX 的发展历史概述:
1980 年代:起源与早期发展
-
1983 年:HP-UX 1.0 发布,这是基于 UNIX System III 的操作系统,最初用于 HP 9000 系列计算机。
-
1984 年:HP-UX 2.0 发布,基于 UNIX System V,这一版本增强了内存管理和文件系统性能。
1990 年代:扩展与创新
-
1991 年:HP-UX 8.0 发布,引入了对多处理器的支持,并增强了图形用户界面功能。
-
1993 年:HP-UX 9.0 发布,进一步改进了多任务处理和文件系统性能。
-
1995 年:HP-UX 10.0 发布,这是一个重要的版本,带来了许多新特性,包括 Logical Volume Manager (LVM)、增强的用户界面、改进的安全功能和对对称多处理 (SMP) 的支持。
-
1997 年:HP-UX 10.20 发布,提供了对 64 位计算和更大内存寻址的支持。
2000 年代:64 位架构与企业级功能
-
2000 年:HP-UX 11i 发布,提供了更高的可靠性、可用性和服务性 (RAS) 特性,并引入了用于关键任务企业计算的改进,如动态分区和虚拟分区。
-
2003 年:HP-UX 11i v2 (11.23) 发布,支持 Integrity 服务器,并提供更强的安全性和可管理性特性。
-
2007 年:HP-UX 11i v3 (11.31) 发布,进一步改进了虚拟化、安全性、性能和管理功能。
2010 年代:持续改进与现代化
-
2010 年:HP-UX 11i v3 2010 更新版发布,增强了云计算和大数据支持功能。
-
2013 年:HP-UX 11i v3 2013 更新版发布,提供了对最新硬件的支持,并进一步改进了虚拟化和安全性。
-
2017 年:HPE 宣布继续对 HP-UX 提供长期支持,并承诺为现有客户提供增强的功能和安全更新。
2020 年代:向长期支持转型
-
2020 年及以后:尽管不再推出重大版本更新,HP-UX 仍然继续为企业客户提供关键任务支持。HPE 继续提供补丁、安全更新和技术支持,确保现有 HP-UX 环境的稳定运行
随着时代的发展X86机器的各项性能也不再逊色于小型机了,HP小型机也越来越少了,可能在一些金融行业还有HP小机的影子,但是确实少见很多了。这篇文章是介绍HPUX小机添加ASM磁盘,从文章的长度上就知道有多复杂,这里发一下仅供大家参考,一窥早期DBA的战战兢兢,如履薄冰!
Environment:
OS:HPUX11.31
DATABASE: oracle 10.0.2.4 3*nodes RAC
Storage:HP-6100 FC disk
Cluster:HPCM
1. cut 2*300G RAID5 FC EVA disk to all nodes of sfc12rc rac
2. os list and find new disk on all nodes:
ioscan -N -fCdiskioscan -N -m lunioscan -fnCdisk
smh to check disk properties: SMH->Disks and File Systems->Disks->DetailsVD name UUID LUN sfc12rc1 sfc12rc2 sfc12rc3----------------------------------------------------------------------------------------------------------------VD_12_ORA_DATA_13 6001-4380-02a5-7554-0001-0000-0096-0000 18 disk98 disk97 disk99VD_12_ORA_DATA_14 6001-4380-02a5-7554-0001-0000-0099-0000 19 disk103 disk103 disk104
3. stop oracle cluster and OS cluster
sqlplus to close database from sfc12rc1 to sfc12rc3--sqlplus / as sysdba shutdown immediate on each node.stop all oracle cluster service:crs_stop -allcrsctl stop crsstop OS cluster:cmviewclcmhaltcl -fcmviewcl
session log
sfc12rc1:/# crsctl check crsCSS appears healthyCRS appears healthyEVM appears healthysfc12rc1:/# crsctl stop crs --stop clusterStopping resources. This could take several minutes.Successfully stopped CRS resources.Stopping CSSD.Shutting down CSS daemon.Shutdown request successfully issued.sfc12rc1:/#sfc12rc1:/#sfc12rc1:/# cmviewcl -- view information about a high availability clusterCLUSTER STATUSclu_RACSFC12 upNODE STATUS STATEsfc12rc1 up runningPACKAGE STATUS STATE AUTO_RUN NODEpkgSFC12IP1 up running enabled sfc12rc1pkgSFC12DB1 up running disabled sfc12rc1NODE STATUS STATEsfc12rc2 up runningPACKAGE STATUS STATE AUTO_RUN NODEpkgSFC12IP2 up running enabled sfc12rc2pkgSFC12DB2 up running disabled sfc12rc2NODE STATUS STATEsfc12rc3 up runningPACKAGE STATUS STATE AUTO_RUN NODEpkgSFC12IP3 up running enabled sfc12rc3pkgSFC12DB3 up running disabled sfc12rc3sfc12rc1:/# cmhaltcl --check a a high availability cluster healthyPackage pkgSFC12IP1 is still running on sfc12rc1.Package pkgSFC12IP2 is still running on sfc12rc2.Package pkgSFC12IP3 is still running on sfc12rc3.Package pkgSFC12DB1 is still running on sfc12rc1.Package pkgSFC12DB2 is still running on sfc12rc2.Package pkgSFC12DB3 is still running on sfc12rc3.Use the -f option to forcefully halt the cluster/node including halting packages.sfc12rc1:/# cmhaltcl -fDisabling all packages from starting on nodes to be halted.Warning: Do not modify or enable packages until the halt operation is completed.Disabling automatic failover for failover packages to be halted.Halting package pkgSFC12IP1Successfully halted package pkgSFC12IP1Halting package pkgSFC12DB1Successfully halted package pkgSFC12DB1Halting package pkgSFC12IP2Successfully halted package pkgSFC12IP2Halting package pkgSFC12DB2Successfully halted package pkgSFC12DB2Halting package pkgSFC12IP3Successfully halted package pkgSFC12IP3Halting package pkgSFC12DB3Successfully halted package pkgSFC12DB3This operation may take some time.Waiting for nodes to halt ... doneSuccessfully halted all nodes specified.Halt operation complete.sfc12rc1:/# cmviewcl --check os cluster is downCLUSTER STATUSclu_RACSFC12 downNODE STATUS STATEsfc12rc1 down unknownsfc12rc2 down unknownsfc12rc3 down unknownUNOWNED_PACKAGESPACKAGE STATUS STATE AUTO_RUN NODEpkgSFC12IP1 down halted enabled unownedpkgSFC12IP2 down halted enabled unownedpkgSFC12IP3 down halted enabled unownedpkgSFC12DB1 down halted disabled unownedpkgSFC12DB2 down halted disabled unownedpkgSFC12DB3 down halted disabled unownedsfc12rc1:/#----------------------------------------------------------------------
4. create VG&LV in sfc12rc1, then export VG mapfile:
Sfc12rc1:pvcreate /dev/rdisk/disk98pvcreate /dev/rdisk/disk103mkdir /dev/vg_ora_data04mknod /dev/vg_ora_data04/group c 64 0x070000vgcreate -l 10 -s 32 vg_ora_data06 /dev/disk/disk114vgextend vg_ora_data06 /dev/disk/disk119vgdisplay vg_ora_data04vgdisplay -v vg_ora_data04lvcreate -l 9597 -n lvdata05 vg_ora_data04lvcreate -l 9597 -n lvdata06 vg_ora_data04mkdir -p /tmp/20111231 --from sfc12rc1 to sfc12rc3vgexport -p -v -s -m /tmp/20111231/vg_ora_data04.map vg_ora_data04rcp /tmp/20111231/vg_ora_data04.map sfc12rc2:/tmp/20111231rcp /tmp/20111231/vg_ora_data04.map sfc12rc3:/tmp/20111231
sfc12rc1:/# pvcreate /dev/rdisk/disk98 --create physical volumePhysical volume "/dev/rdisk/disk98" has been successfully created.sfc12rc1:/# pvcreate /dev/rdisk/disk103 --create physical volumePhysical volume "/dev/rdisk/disk103" has been successfully created.sfc12rc1:/# ls -lrt /dev/vg_ora_data04/dev/vg_ora_data04 not foundsfc12rc1:/# mkdir /dev/vg_ora_data04sfc12rc1:/# mknod /dev/vg_ora_data06/group c 64 0x090000--最后编号与其他VG不同即可sfc12rc1:/# ls -lrt /dev/vg_ora_data04total 0crw-r--r-- 1 root sys 64 0x070000 Dec 31 08:53 groupsfc12rc1:/# vgdisplay vg_ora_data04 --display information about LVM volume groups--- Volume groups ---VG Name /dev/vg_ora_data04VG Write Access read/writeVG Status availableMax LV 10Cur LV 0Open LV 0Max PV 16Cur PV 2Act PV 2Max PE per PV 9599VGDA 4PE Size (Mbytes) 32Total PE 19198Alloc PE 0Free PE 19198Total PVG 0Total Spare PVs 0Total Spare PVs in use 0VG Version 1.0VG Max Size 4914688mVG Max Extents 153584sfc12rc1:/# vgdisplay -v vg_ora_data04--- Volume groups ---VG Name /dev/vg_ora_data04VG Write Access read/writeVG Status availableMax LV 10Cur LV 0Open LV 0Max PV 16Cur PV 2Act PV 2Max PE per PV 9599VGDA 4PE Size (Mbytes) 32Total PE 19198Alloc PE 0Free PE 19198Total PVG 0Total Spare PVs 0Total Spare PVs in use 0VG Version 1.0VG Max Size 4914688mVG Max Extents 153584--- Physical volumes ---PV Name /dev/disk/disk98PV Status availableTotal PE 9599Free PE 9599Autoswitch OnProactive Polling OnPV Name /dev/disk/disk103PV Status availableTotal PE 9599Free PE 9599Autoswitch OnProactive Polling Onsfc12rc1:/#sfc12rc1:/# lvcreate -l 9597 -n lvdata08 vg_ora_data06--create logical volume / Max PE per PV 9599 但是要预留2个pe给系统使用Logical volume "/dev/vg_ora_data04/lvdata05" has been successfully created withcharacter device "/dev/vg_ora_data04/rlvdata05".Logical volume "/dev/vg_ora_data04/lvdata05" has been successfully extended.Volume Group configuration for /dev/vg_ora_data04 has been saved in /etc/lvmconf/vg_ora_data04.confsfc12rc1:/# lvcreate -l 9597 -n lvdata09 vg_ora_data06Logical volume "/dev/vg_ora_data04/lvdata06" has been successfully created withcharacter device "/dev/vg_ora_data04/rlvdata06".Logical volume "/dev/vg_ora_data04/lvdata06" has been successfully extended.Volume Group configuration for /dev/vg_ora_data04 has been saved in /etc/lvmconf/vg_ora_data04.confsfc12rc1:/#sfc12rc1:/# lvdisplay /dev/vg_ora_data04/lvdata05 --show LV information--- Logical volumes ---LV Name /dev/vg_ora_data04/lvdata05VG Name /dev/vg_ora_data04LV Permission read/writeLV Status available/syncdMirror copies 0Consistency Recovery MWCSchedule parallelLV Size (Mbytes) 307104Current LE 9597Allocated PE 9597Stripes 0Stripe Size (Kbytes) 0Bad block onAllocation strictIO Timeout (Seconds) defaultsfc12rc1:/#sfc12rc1:/# mkdir -p /tmp/20111231sfc12rc1:/# vgexport -p -v -s -m /tmp/20181001/vg_ora_data06.map vg_ora_data06--将vg配置信息导入到文件Beginning the export process on Volume Group "vg_ora_data04".vgexport: Volume group "vg_ora_data04" is still active./dev/disk/disk98/dev/disk/disk103vgexport: Preview of vgexport on volume group "vg_ora_data04" succeeded.sfc12rc1:/#sfc12rc1:/# rcp /tmp/20181001/vg_ora_data06.map sfc12rc2:/tmp/20181001sfc12rc1:/# rcp /tmp/20181001/vg_ora_data06.map sfc12rc3:/tmp/20181001--将VG配置文件copy 到另外两个节点sfc12rc1:/#
5. import VG mapfile from sfc12rc1 to sfc12rc2:
sfc12rc2:mkdir /dev/vg_ora_data04mknod /dev/vg_ora_data04/group c 64 0x070000vgimport -v -m /tmp/20181001/vg_ora_data06.map vg_ora_data06 /dev/disk/disk118 \/dev/disk/disk119sfc12rc2:/# mkdir /dev/vg_ora_data06sfc12rc2:/# mknod /dev/vg_ora_data06/group c 64 0x090000sfc12rc2:/# ls -lrt /dev/vg_ora_data06total 0crw-r--r-- 1 root sys 64 0x070000 Dec 31 09:03 groupsfc12rc2:/# vgimport -v -m /tmp/20111231/vg_ora_data04.map vg_ora_data04 /dev/disk/disk97 \> /dev/disk/disk103--将vg配置信息导入到该节点Beginning the import process on Volume Group "vg_ora_data04".vgimport: Warning: Volume Group belongs to different CPU ID.Can not determine if Volume Group is in use on another system. Continuing.Logical volume "/dev/vg_ora_data04/lvdata05" has been successfully createdwith lv number 1.Logical volume "/dev/vg_ora_data04/lvdata06" has been successfully createdwith lv number 2.vgimport: Volume group "/dev/vg_ora_data04" has been successfully created.Warning: A backup of this volume group may not exist on this machine.Please remember to take a backup using the vgcfgbackup command after activating the volume group.sfc12rc2:/# vgdisplay vg_ora_data04vgdisplay: Volume group not activated.vgdisplay: Cannot display volume group "vg_ora_data04".sfc12rc2:/# vgdisplay -v vg_ora_data04vgdisplay: Volume group not activated.vgdisplay: Cannot display volume group "vg_ora_data04".sfc12rc2:/# lvdisplay /dev/vg_ora_data04/lvdata05lvdisplay: Couldn't query logical volume "/dev/vg_ora_data04/lvdata05":Volume group not activated.lvdisplay: Cannot display logical volume "/dev/vg_ora_data04/lvdata05".sfc12rc2:/#----------------------------------------------------------------------
6. import VG mapfile from sfc12rc1 to sfc12rc3:
sfc12rc3:mkdir /dev/vg_ora_data06mknod /dev/vg_ora_data06/group c 64 0x090000vgimport -v -m /tmp/20181001/vg_ora_data06.map vg_ora_data06 /dev/disk/disk118 \/dev/disk/disk119sfc12rc3:/#sfc12rc3:/# mkdir /dev/vg_ora_data04sfc12rc3:/# mknod /dev/vg_ora_data04/group c 64 0x070000sfc12rc3:/# vgimport -v -m /tmp/20111231/vg_ora_data04.map vg_ora_data04 /dev/disk/disk99 \> /dev/disk/disk104--将vg配置信息导入到该节点Beginning the import process on Volume Group "vg_ora_data04".vgimport: Warning: Volume Group belongs to different CPU ID.Can not determine if Volume Group is in use on another system. Continuing.Logical volume "/dev/vg_ora_data04/lvdata05" has been successfully createdwith lv number 1.Logical volume "/dev/vg_ora_data04/lvdata06" has been successfully createdwith lv number 2.vgimport: Volume group "/dev/vg_ora_data04" has been successfully created.Warning: A backup of this volume group may not exist on this machine.Please remember to take a backup using the vgcfgbackup command after activating the volume group.sfc12rc3:/#----------------------------------------------------------------------
7. modify cluster configration file and apply in sfc12rc1:
sfc12rc1:cd /etc/cmcluster/备份并且修改 /etc/cmcluster/cluster_sfc12.ascii 文件在原有的vg下面,加入新的卷組信息OPS_VOLUME_GROUP /dev/vg_ora_data04cmcheckconf -v -C /etc/cmcluster/cluster_sfc12.asciicmapplyconf -v -C /etc/cmcluster/cluster_sfc12.asciircp -p cluster_sfc12.ascii sfc12rc2:/etc/cmcluster/rcp -p cluster_sfc12.ascii sfc12rc3:/etc/cmcluster/
cd pkgSFC12DB1修改pkgSFC12DB1配置备份并且在pkgSFC12DB1.cntl中加入VG[5]=vg_ora_data04cmapplyconf -v -C /etc/cmcluster/cluster_sfc12.ascii -P \/etc/cmcluster/pkgSFC12DB1/pkgSFC12DB1.confsfc12rc1:/# cd /etc/cmcluster/sfc12rc1:/etc/cmcluster# ls -lrttotal 208-r-------- 1 bin bin 118 Mar 16 2007 cmknowncmdsdrwxr-xr-x 2 bin bin 8192 Oct 22 2008 cfsdr-xr-xr-x 2 bin bin 96 Oct 22 2008 examplesdr-xr-xr-x 4 root root 96 Oct 22 2008 modulesdr-xr-xr-x 5 bin bin 96 Jan 7 2009 scriptsdr-xr-xr-x 2 bin bin 8192 Jan 7 2009 lib-rw-r--r-- 1 root sys 11 Jan 15 2009 mapfile---------- 1 root root 0 Jan 15 2009 config.lckdrwxr-xr-x 2 root sys 96 Jan 15 2009 pkgSFC12IP1drwxr-xr-x 2 root sys 96 Feb 9 2009 pkgSFC12IP3drwxr-xr-x 2 root sys 96 Feb 20 2009 pkgSFC12IP2-rw-r--r-- 1 root sys 10458 Jun 29 2009 cluster_sfc12.ascii20100921drwx------ 2 root sys 8192 Sep 21 2010 pkgSFC12DB1-rw-r--r-- 1 root sys 10495 Oct 2 2010 cluster_sfc12.ascii-rw------- 1 root root 30916 Dec 31 08:45 cmclconfig-rw------- 1 root root 0 Dec 31 08:45 cmclconfig.tmpsfc12rc1:/etc/cmcluster# cp cluster_sfc12.ascii cluster_sfc12.ascii20111231-- –修改系统文件前 先备份sfc12rc1:/etc/cmcluster# vi /etc/cmcluster/cluster_sfc12.ascii--在文件最后加入新的卷组信息OPS_VOLUME_GROUP /dev/vg_ora_data04sfc12rc1:/etc/cmcluster#sfc12rc1:/etc/cmcluster# cmcheckconf -v -C /etc/cmcluster/cluster_sfc12.ascii---检查修改后的文件是否有错误Begin cluster verification...Checking cluster file: /etc/cmcluster/cluster_sfc12.asciiChecking nodes ... DoneChecking existing configuration ... DoneGathering storage informationFound 20 devices on node sfc12rc1Found 20 devices on node sfc12rc2Found 20 devices on node sfc12rc3Analysis of 60 devices should take approximately 5 seconds0%----10%----20%----30%----40%----50%----60%----70%----80%----90%----100%Found 8 volume groups on node sfc12rc1Found 8 volume groups on node sfc12rc2Found 8 volume groups on node sfc12rc3Analysis of 24 volume groups should take approximately 1 seconds0%----10%----20%----30%----40%----50%----60%----70%----80%----90%----100%Gathering network informationBeginning network probing (this may take a while)Completed network probingCluster clu_RACSFC12 is an existing clusterCluster clu_RACSFC12 is an existing clusterChecking for inconsistenciesMaximum configured packages parameter is 150.Configuring 6 package(s).144 package(s) can be added to this cluster.200 access policies can be added to this cluster.Modifying configuration on node sfc12rc1Modifying configuration on node sfc12rc2Modifying configuration on node sfc12rc3Modifying the cluster configuration for cluster clu_RACSFC12Modifying node sfc12rc1 in cluster clu_RACSFC12Modifying node sfc12rc2 in cluster clu_RACSFC12Modifying node sfc12rc3 in cluster clu_RACSFC12cmcheckconf: Verification completed with no errors found.Use the cmapplyconf command to apply the configuration.sfc12rc1:/etc/cmcluster#sfc12rc1:/etc/cmcluster# cmapplyconf -v -C /etc/cmcluster/cluster_sfc12.ascii--使修改生效Begin cluster verification...Checking cluster file: /etc/cmcluster/cluster_sfc12.asciiChecking nodes ... DoneChecking existing configuration ... DoneGathering storage informationFound 20 devices on node sfc12rc1Found 20 devices on node sfc12rc2Found 20 devices on node sfc12rc3Analysis of 60 devices should take approximately 5 seconds0%----10%----20%----30%----40%----50%----60%----70%----80%----90%----100%Found 8 volume groups on node sfc12rc1Found 8 volume groups on node sfc12rc2Found 8 volume groups on node sfc12rc3Analysis of 24 volume groups should take approximately 1 seconds0%----10%----20%----30%----40%----50%----60%----70%----80%----90%----100%Gathering network informationBeginning network probing (this may take a while)Completed network probingCluster clu_RACSFC12 is an existing clusterCluster clu_RACSFC12 is an existing clusterChecking for inconsistenciesMaximum configured packages parameter is 150.Configuring 6 package(s).144 package(s) can be added to this cluster.200 access policies can be added to this cluster.Modifying configuration on node sfc12rc1Modifying configuration on node sfc12rc2Modifying configuration on node sfc12rc3Modifying the cluster configuration for cluster clu_RACSFC12Modifying node sfc12rc1 in cluster clu_RACSFC12Modifying node sfc12rc2 in cluster clu_RACSFC12Modifying node sfc12rc3 in cluster clu_RACSFC12Modify the cluster configuration ([y]/n)? yMarking/unmarking volume groups for use in the clusterCompleted the cluster creationsfc12rc1:/etc/cmcluster#sfc12rc1:/etc/cmcluster# rcp -p cluster_sfc12.ascii sfc12rc2:/etc/cmcluster/sfc12rc1:/etc/cmcluster# rcp -p cluster_sfc12.ascii sfc12rc3:/etc/cmcluster/--将修改OK的cluster_sfc12.ascii文件copy到另外两个节点sfc12rc1:/etc/cmcluster#sfc12rc1:/etc/cmcluster# cd pkgSFC12DB1sfc12rc1:/etc/cmcluster/pkgSFC12DB1# ls -lrttotal 464-rwx------ 1 root sys 26764 Jan 15 2009 pkgSFC12DB1.conf-rwx------ 1 root sys 64281 Jun 29 2009 pkgSFC12DB1.cntl20100921-rwx------ 1 root sys 64301 Oct 2 2010 pkgSFC12DB1.cntl-rw-r--r-- 1 root root 67729 Dec 31 08:47 pkgSFC12DB1.cntl.logsfc12rc1:/etc/cmcluster/pkgSFC12DB1# cp pkgSFC12DB1.cntl pkgSFC12DB1.cntl20111231sfc12rc1:/etc/cmcluster/pkgSFC12DB1# vi pkgSFC12DB1.cntl#VG[0]=""VG[0]=vg_ora_voteVG[1]=vg_ora_data01VG[2]=vg_ora_arch01VG[3]=vg_ora_data02VG[4]=vg_ora_data03VG[5]=vg_ora_data04 --新加sfc12rc1:/etc/cmcluster/pkgSFC12DB1#sfc12rc1:/etc/cmcluster/pkgSFC12DB1# cmapplyconf -v -C /etc/cmcluster/cluster_sfc12.ascii -P \> /etc/cmcluster/pkgSFC12DB1/pkgSFC12DB1.confBegin cluster verification...Checking cluster file: /etc/cmcluster/cluster_sfc12.asciiChecking nodes ... DoneChecking existing configuration ... DoneGathering storage informationFound 20 devices on node sfc12rc1Found 20 devices on node sfc12rc2Found 20 devices on node sfc12rc3Analysis of 60 devices should take approximately 5 seconds0%----10%----20%----30%----40%----50%----60%----70%----80%----90%----100%Found 8 volume groups on node sfc12rc1Found 8 volume groups on node sfc12rc2Found 8 volume groups on node sfc12rc3Analysis of 24 volume groups should take approximately 1 seconds0%----10%----20%----30%----40%----50%----60%----70%----80%----90%----100%Gathering network informationBeginning network probing (this may take a while)Completed network probingCluster clu_RACSFC12 is an existing clusterParsing package file: /etc/cmcluster/pkgSFC12DB1/pkgSFC12DB1.conf./etc/cmcluster/pkgSFC12DB1/pkgSFC12DB1.conf: A legacy package is being used.Package pkgSFC12DB1 already exists. It will be modified.Cluster clu_RACSFC12 is an existing clusterChecking for inconsistenciesMaximum configured packages parameter is 150.Configuring 6 package(s).144 package(s) can be added to this cluster.200 access policies can be added to this cluster.Modifying configuration on node sfc12rc1Modifying configuration on node sfc12rc2Modifying configuration on node sfc12rc3Modifying the cluster configuration for cluster clu_RACSFC12Modifying node sfc12rc1 in cluster clu_RACSFC12Modifying node sfc12rc2 in cluster clu_RACSFC12Modifying node sfc12rc3 in cluster clu_RACSFC12Modifying the package configuration for package pkgSFC12DB1.Modify the cluster configuration ([y]/n)? yMarking/unmarking volume groups for use in the clusterCompleted the cluster creationsfc12rc1:/etc/cmcluster/pkgSFC12DB1#---------------------------------------------------------------------
8. modify cluster configration file and apply in sfc12rc2:
sfc12rc2:cd /etc/cmcluster/pkgSFC12DB2修改pkgSFC12DB2配置备份并在pkgSFC12DB2.cntl中加入VG[5]=vg_ora_data04cmapplyconf -v -C /etc/cmcluster/cluster_sfc12.ascii -P \/etc/cmcluster/pkgSFC12DB2/pkgSFC12DB2.confsfc12rc2:/# cd /etc/cmcluster/pkgSFC12DB2sfc12rc2:/etc/cmcluster/pkgSFC12DB2# ls -lrttotal 448-rwx------ 1 root sys 26764 Jan 15 2009 pkgSFC12DB2.conf-rwx------ 1 root sys 64281 Jun 29 2009 pkgSFC12DB2.cntl20100921-rwx------ 1 root sys 64301 Oct 2 2010 pkgSFC12DB2.cntl-rw-r--r-- 1 root root 65051 Dec 31 08:47 pkgSFC12DB2.cntl.logsfc12rc2:/etc/cmcluster/pkgSFC12DB2# vi pkgSFC12DB2.cntl#VG[0]=""VG[0]=vg_ora_voteVG[1]=vg_ora_data01VG[2]=vg_ora_arch01VG[3]=vg_ora_data02VG[4]=vg_ora_data03VG[5]=vg_ora_data04 --新加sfc12rc2:/etc/cmcluster/pkgSFC12DB2#sfc12rc2:/etc/cmcluster/pkgSFC12DB2# cmapplyconf -v -C /etc/cmcluster/cluster_sfc12.ascii -P \> /etc/cmcluster/pkgSFC12DB2/pkgSFC12DB2.confBegin cluster verification...Checking cluster file: /etc/cmcluster/cluster_sfc12.asciiChecking nodes ... DoneChecking existing configuration ... DoneGathering storage informationFound 20 devices on node sfc12rc1Found 20 devices on node sfc12rc2Found 20 devices on node sfc12rc3Analysis of 60 devices should take approximately 5 seconds0%----10%----20%----30%----40%----50%----60%----70%----80%----90%----100%Found 8 volume groups on node sfc12rc1Found 8 volume groups on node sfc12rc2Found 8 volume groups on node sfc12rc3Analysis of 24 volume groups should take approximately 1 seconds0%----10%----20%----30%----40%----50%----60%----70%----80%----90%----100%Gathering network informationBeginning network probing (this may take a while)Completed network probingCluster clu_RACSFC12 is an existing clusterParsing package file: /etc/cmcluster/pkgSFC12DB2/pkgSFC12DB2.conf./etc/cmcluster/pkgSFC12DB2/pkgSFC12DB2.conf: A legacy package is being used.Package pkgSFC12DB2 already exists. It will be modified.Cluster clu_RACSFC12 is an existing clusterChecking for inconsistenciesMaximum configured packages parameter is 150.Configuring 6 package(s).144 package(s) can be added to this cluster.200 access policies can be added to this cluster.Modifying configuration on node sfc12rc1Modifying configuration on node sfc12rc2Modifying configuration on node sfc12rc3Modifying the cluster configuration for cluster clu_RACSFC12Modifying node sfc12rc1 in cluster clu_RACSFC12Modifying node sfc12rc2 in cluster clu_RACSFC12Modifying node sfc12rc3 in cluster clu_RACSFC12Modifying the package configuration for package pkgSFC12DB2.Modify the cluster configuration ([y]/n)? yMarking/unmarking volume groups for use in the clusterCompleted the cluster creationsfc12rc2:/etc/cmcluster/pkgSFC12DB2#---------------------------------------------------------------------
9. modify cluster configration file and apply in sfc12rc3:
sfc12rc3:cd /etc/cmcluster/pkgSFC12DB3修改pkgSFC12DB3配置备份并在pkgSFC12DB3.cntl中加入VG[5]=vg_ora_data04cmapplyconf -v -C /etc/cmcluster/cluster_sfc12.ascii -P \/etc/cmcluster/pkgSFC12DB3/pkgSFC12DB3.confsfc12rc3:/# cd /etc/cmcluster/pkgSFC12DB3sfc12rc3:/etc/cmcluster/pkgSFC12DB3# ls -lrttotal 448-rwx------ 1 root sys 26764 Jan 15 2009 pkgSFC12DB3.conf-rwx------ 1 root sys 64281 Jun 29 2009 pkgSFC12DB3.cntl20100921-rwx------ 1 root sys 64301 Oct 2 2010 pkgSFC12DB3.cntl-rw-r--r-- 1 root root 62722 Dec 31 08:47 pkgSFC12DB3.cntl.logsfc12rc3:/etc/cmcluster/pkgSFC12DB3# cp pkgSFC12DB3.cntl pkgSFC12DB3.cntl20111231sfc12rc3:/etc/cmcluster/pkgSFC12DB3# vi pkgSFC12DB3.cntl#VG[0]=""VG[0]=vg_ora_voteVG[1]=vg_ora_data01VG[2]=vg_ora_arch01VG[3]=vg_ora_data02VG[4]=vg_ora_data03VG[5]=vg_ora_data04 --新加sfc12rc3:/etc/cmcluster/pkgSFC12DB3# cmapplyconf -v -C /etc/cmcluster/cluster_sfc12.ascii -P \> /etc/cmcluster/pkgSFC12DB3/pkgSFC12DB3.confBegin cluster verification...Checking cluster file: /etc/cmcluster/cluster_sfc12.asciiChecking nodes ... DoneChecking existing configuration ... DoneGathering storage informationFound 20 devices on node sfc12rc1Found 20 devices on node sfc12rc2Found 20 devices on node sfc12rc3Analysis of 60 devices should take approximately 5 seconds0%----10%----20%----30%----40%----50%----60%----70%----80%----90%----100%Found 8 volume groups on node sfc12rc1Found 8 volume groups on node sfc12rc2Found 8 volume groups on node sfc12rc3Analysis of 24 volume groups should take approximately 1 seconds0%----10%----20%----30%----40%----50%----60%----70%----80%----90%----100%Gathering network informationBeginning network probing (this may take a while)Completed network probingCluster clu_RACSFC12 is an existing clusterParsing package file: /etc/cmcluster/pkgSFC12DB3/pkgSFC12DB3.conf./etc/cmcluster/pkgSFC12DB3/pkgSFC12DB3.conf: A legacy package is being used.Package pkgSFC12DB3 already exists. It will be modified.Cluster clu_RACSFC12 is an existing clusterChecking for inconsistenciesMaximum configured packages parameter is 150.Configuring 6 package(s).144 package(s) can be added to this cluster.200 access policies can be added to this cluster.Modifying configuration on node sfc12rc1Modifying configuration on node sfc12rc2Modifying configuration on node sfc12rc3Modifying the cluster configuration for cluster clu_RACSFC12Modifying node sfc12rc1 in cluster clu_RACSFC12Modifying node sfc12rc2 in cluster clu_RACSFC12Modifying node sfc12rc3 in cluster clu_RACSFC12Modifying the package configuration for package pkgSFC12DB3.Modify the cluster configuration ([y]/n)? yMarking/unmarking volume groups for use in the clusterCompleted the cluster creationsfc12rc3:/etc/cmcluster/pkgSFC12DB3#--------------------------------------------------------------------
10. start OS cluster in sfc12rc1:
vgchange -a n vg_ora_data04cmrunclcmviewclcmrunpkg -n sfc12rc1 pkgSFC12DB1cmrunpkg -n sfc12rc2 pkgSFC12DB2cmrunpkg -n sfc12rc3 pkgSFC12DB3cmviewclsfc12rc1:/#sfc12rc1:/# vgchange -a n vg_ora_data04Volume group "vg_ora_data04" has been successfully changed.sfc12rc1:/# vgdisplay /dev/vg_ora_data04vgdisplay: Volume group not activated.vgdisplay: Cannot display volume group "/dev/vg_ora_data04".sfc12rc1:/# cmruncl --启动clustercmruncl: Validating network configuration...cmruncl: Network validation completecmruncl: Validating cluster lock disk .... DoneWaiting for cluster to form ....... doneCluster successfully formed.Check the syslog files on all nodes in the cluster to verify that no warnings occurred during startup.sfc12rc1:/# cmviewcl --查看状态CLUSTER STATUSclu_RACSFC12 upNODE STATUS STATEsfc12rc1 up runningPACKAGE STATUS STATE AUTO_RUN NODEpkgSFC12IP1 up running enabled sfc12rc1NODE STATUS STATEsfc12rc2 up runningPACKAGE STATUS STATE AUTO_RUN NODEpkgSFC12IP2 up running enabled sfc12rc2NODE STATUS STATEsfc12rc3 up runningPACKAGE STATUS STATE AUTO_RUN NODEpkgSFC12IP3 up running enabled sfc12rc3UNOWNED_PACKAGESPACKAGE STATUS STATE AUTO_RUN NODEpkgSFC12DB1 down halted disabled unownedpkgSFC12DB2 down halted disabled unownedpkgSFC12DB3 down halted disabled unownedsfc12rc1:/# cmrunpkg -n sfc12rc1 pkgSFC12DB1 -PKG不会自动启动 需要手动启动Running package pkgSFC12DB1 on node sfc12rc1Successfully started package pkgSFC12DB1 on node sfc12rc1cmrunpkg: All specified packages are runningsfc12rc1:/# cmrunpkg -n sfc12rc2 pkgSFC12DB2Running package pkgSFC12DB2 on node sfc12rc2Successfully started package pkgSFC12DB2 on node sfc12rc2cmrunpkg: All specified packages are runningsfc12rc1:/# cmrunpkg -n sfc12rc3 pkgSFC12DB3Running package pkgSFC12DB3 on node sfc12rc3Successfully started package pkgSFC12DB3 on node sfc12rc3cmrunpkg: All specified packages are runningsfc12rc1:/# cmviewcl --show cluster statusCLUSTER STATUSclu_RACSFC12 upNODE STATUS STATEsfc12rc1 up runningPACKAGE STATUS STATE AUTO_RUN NODEpkgSFC12IP1 up running enabled sfc12rc1pkgSFC12DB1 up running disabled sfc12rc1NODE STATUS STATEsfc12rc2 up runningPACKAGE STATUS STATE AUTO_RUN NODEpkgSFC12IP2 up running enabled sfc12rc2pkgSFC12DB2 up running disabled sfc12rc2NODE STATUS STATEsfc12rc3 up runningPACKAGE STATUS STATE AUTO_RUN NODEpkgSFC12IP3 up running enabled sfc12rc3pkgSFC12DB3 up running disabled sfc12rc3sfc12rc1:/#-------------------------------------------------------------------------------
11. chdange rlv properties and start oracle cluster from sfc12rc1 to sfc12rc3:
chown oracle:dba /dev/vg_ora_data06/rlvdata08chmod 660 /dev/vg_ora_data06/rlvdata08chown oracle:dba /dev/vg_ora_data06/rlvdata09chmod 660 /dev/vg_ora_data06/rlvdata09ls -lrt /dev/vg_ora_data06/rlvdata*vi /apps/oracle/admin/+ASM/pfile/init.oraappend ",'/dev/vg_ora_data06/rlvdata08','/dev/vg_ora_data06/rlvdata09'" to asm_diskstringcrsctl start crssfc12rc1:/#sfc12rc1:/# chown oracle:dba /dev/vg_ora_data04/rlvdata05 --change ownersfc12rc1:/# chmod 660 /dev/vg_ora_data04/rlvdata05 --change modesfc12rc1:/# chown oracle:dba /dev/vg_ora_data04/rlvdata06sfc12rc1:/# chmod 660 /dev/vg_ora_data04/rlvdata06sfc12rc1:/# ls -lrt /dev/vg_ora_data04/rlvdata*crw-rw---- 1 oracle dba 64 0x070001 Dec 31 08:57 /dev/vg_ora_data04/rlvdata05crw-rw---- 1 oracle dba 64 0x070002 Dec 31 08:57 /dev/vg_ora_data04/rlvdata06sfc12rc1:/#sfc12rc1:/# crsctl start crs --start crsAttempting to start CRS stackThe CRS stack will be started shortlysfc12rc1:/# crsctl check crs --check crs statusCSS appears healthyCRS appears healthyEVM appears healthysfc12rc1:/#--------------------------------------------------------------------------------
12. check all node find new disks,then add 2 disks to DGDATA diskgroup:
column name format a20select name,state,type,total_mb,free_mb,unbalanced from v$asm_diskgroup;select name,path,total_mb,free_mb,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS from v$asm_disk order by 1,2;alter diskgroup dgdata add disk '/dev/vg_ora_data04/rlvdata05';alter diskgroup dgdata add disk '/dev/vg_ora_data04/rlvdata06';--alter diskgroup dgdata rebalance power 11;select * from v$asm_operation;select name,total_mb,free_mb,unbalanced from v$asm_diskgroup;select group_number,name,path,total_mb,free_mb,header_status from v$asm_disk order by 1,2;idle> column name format a20idle> select name,state,type,total_mb,free_mb,unbalanced from v$asm_diskgroup;NAME STATE TYPE TOTAL_MB FREE_MB UN-------------------- ---------------------- ------------ ---------- ---------- --DGARCH MOUNTED EXTERN 307104 304314 NDGDATA MOUNTED EXTERN 1228416 168358 Nidle> select name,path,total_mb,free_mb,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS from v$asm_disk order by 1,2;NAME PATH TOTAL_MB FREE_MB MOUNT_STATUS HEADER_STATUS MODE_STATUS-------------------- ------------------------------ ---------- ---------- -------------- ------------------------ --------------DGARCH_0000 /dev/vg_ora_arch01/rlvarch01 307104 304314 CACHED MEMBER ONLINEDGDATA_0000 /dev/vg_ora_data01/rlvdata01 307104 42084 CACHED MEMBER ONLINEDGDATA_0001 /dev/vg_ora_data02/rlvdata02 307104 42090 CACHED MEMBER ONLINEDGDATA_0002 /dev/vg_ora_data03/rlvdata04 307104 42096 CACHED MEMBER ONLINEDGDATA_0003 /dev/vg_ora_data03/rlvdata03 307104 42088 CACHED MEMBER ONLINE/dev/vg_ora_data04/rlvdata05 307104 0 CLOSED CANDIDATE ONLINE/dev/vg_ora_data04/rlvdata06 307104 0 CLOSED CANDIDATE ONLINE7 rows selected.idle>idle> alter diskgroup dgdata add disk '/dev/vg_ora_data06/rlvdata08';--add disk to diskgroupDiskgroup altered.idle> alter diskgroup dgdata add disk '/dev/vg_ora_data06/rlvdata09';--add disk to diskgroupDiskgroup altered.idle> alter diskgroup dgdata rebalance power 11; --rebalance diskgroupDiskgroup altered.idle>idle>idle> select * from v$asm_operation;select name,total_mb,free_mb,unbalanced from v$asm_diskgroup;GROUP_NUMBER OPERATION STATE POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES------------ ---------- -------- ---------- ---------- ---------- ---------- ---------- -----------2 REBAL RUN 11 11 35 353309 6160 57idle>select group_number,name,path,total_mb,free_mb,header_status from v$asm_disk order by 1,2;NAME TOTAL_MB FREE_MB UN-------------------- ---------- ---------- --DGARCH 307104 304314 NDGDATA 1842624 782558 Nidle> idle>GROUP_NUMBER NAME PATH TOTAL_MB FREE_MB HEADER_STATUS------------ -------------------- ------------------------------ ---------- ---------- ------------------------1 DGARCH_0000 /dev/vg_ora_arch01/rlvarch01 307104 304314 MEMBER2 DGDATA_0000 /dev/vg_ora_data01/rlvdata01 307104 42095 MEMBER2 DGDATA_0001 /dev/vg_ora_data02/rlvdata02 307104 42102 MEMBER2 DGDATA_0002 /dev/vg_ora_data03/rlvdata04 307104 42107 MEMBER2 DGDATA_0003 /dev/vg_ora_data03/rlvdata03 307104 42098 MEMBER2 DGDATA_0004 /dev/vg_ora_data04/rlvdata05 307104 307078 MEMBER2 DGDATA_0005 /dev/vg_ora_data04/rlvdata06 307104 307078 MEMBER7 rows selected.idle>---------------------------------------------------------------------------------------------------------------do from sfc12rc1 to sfc12rc3 if necessary, check init file is right:alter system set asm_diskstring='/dev/vg_ora_arch01/rlvarch01','/dev/vg_ora_data01/rlvdata01','/dev/vg_ora_data02/rlvdata02','/dev/vg_ora_data03/rlvdata03','/dev/vg_ora_data03/rlvdata04','/dev/vg_ora_data04/rlvdata05','/dev/vg_ora_data04/rlvdata06';
相关文章:
HPUX系统Oracle RAC如何添加ASM磁盘
前言 HPUX简介 HP-UX (Hewlett-Packard Unix) 是惠普公司开发的类 Unix 操作系统。自 1980 年代问世以来,HP-UX 在技术和功能上不断发展,适应了多种硬件平台和企业计算需求。以下是 HP-UX 的发展历史概述: 1980 年代:起源与早期…...
Jmeter 压力测测试的简单入门
下载安装 官方网站:Apache JMeter - Download Apache JMeter 下载完成解压即可。 配置 1. 找到 bin 目录下的 ApacheJMeter.jar 包,直接打开 如果向图片这样不能直接打开,就在此路径运行 CMD,然后输入下面的命令即可启动。 ja…...
N叉树的层序遍历-力扣
本题同样是二叉树的层序遍历的扩展,只不过二叉树每个节点的子节点只有左右节点,而N叉树的子节点是一个数组,层序遍历到一个节点时,需要将这个节点的子节点数组的每个节点都入队。 代码如下: /* // Definition for a N…...
解决阿里云的端口添加安全组仍然无法扫描到
发现用线上的网站扫不到这个端口,这个端口关了,但是没有更详细信息了 我用nmap扫了一下我的这个端口,发现主机是活跃的,但是有防火墙,我们列出云服务器上面的这个防火墙list,发现确实没有5566端口 参考&a…...
【因果推断python】26_双重稳健估计1
目录 不要把所有的鸡蛋放在一个篮子里 双重稳健估计 关键思想 不要把所有的鸡蛋放在一个篮子里 我们已经学会了如何使用线性回归和倾向得分加权来估计 。但是我们应该在什么时候使用哪一个呢?在不明确的情况下,请同时使用两者!双重稳健估计…...
C语言 图形化界面方式连接MySQL【C/C++】【图形化界面组件分享】
博客主页:花果山~程序猿-CSDN博客 文章分栏:MySQL之旅_花果山~程序猿的博客-CSDN博客 关注我一起学习,一起进步,一起探索编程的无限可能吧!让我们一起努力,一起成长! 目录 一.配置开发环境 二…...
Unity DOTS技术(十五) 物理系统
要解决性能的瓶颈问题,在DOTS中我们将不再使用Unity自带的物理组件. 下面来分享一下在DOTS中当如何使用物理插件. 一.导入插件 在使用DOTS系创建的实体我们会发现,游戏物体无法受物理系统影响进行运动.于是我们需要添加物理系统插件. 1.打开Package Manager > 搜索插件Uni…...
Java线程安全
线程安全 线程安全:线程安全:synchronized同步代码块:同步方法:成员同步方法:静态同步方法: Lock:应用: 单例模式:懒汉式:饿汉式:枚举饿汉式:双重检验锁: 线程…...
Solidity选择使用 require 语句还是条件语句结合手动触发 revert 操作?回滚交易和抛出异常如何选择?
文章目录 Solidity选择使用 require 语句还是条件语句结合手动触发 revert 操作?场景举例:回滚交易和抛出异常如何选择? Solidity选择使用 require 语句还是条件语句结合手动触发 revert 操作? IERC721 nft IERC721(nftAddress)…...
SpringCloud 网关配置websocket
一、nginx https://域名.com location /websocket/ { proxy_pass http://172.1.1.173:8181/; #内网网关IP proxy_http_version 1.1; proxy_read_timeout 360s; proxy_redirect off; proxy_set_header Upgrade $http_upgrade; …...
基于JavaScript 实现近邻算法以及优化方案
前言 近邻算法(K-Nearest Neighbors,简称 KNN)是一种简单的、广泛使用的分类和回归算法。它的基本思想是:给定一个待分类的样本,找到这个样本在特征空间中距离最近的 k 个样本,这 k 个样本的多数类别作为待…...
移动端适配和响应式页面中的常用单位
在移动端适配和响应式页面中,一般采用以下几种单位: 百分比(%):百分比单位是相对于父元素的大小计算的。它可以用于设置宽度、高度、字体大小等属性,使得元素能够随着父元素的大小自动调整。百分比单位在响…...
麒麟v10系统arm64架构openssh9.7p1的rpm包
制作openssh 说明 理论上制作的多个rpm在arm64架构(aarch64)都适用 系统信息:4.19.90-17.ky10.aarch64 GNU/Linux 升级前备份好文件/etc/ssh、/etc/pam.d等以及开启telnet 升级后确认正常后关闭telnet 在之前制作过openssh-9.5p1基础上继续…...
刚刚❗️德勤2025校招暑期实习测评笔试SHL测评题库已发(答案)
📣德勤 2024暑期实习测评已发,正在申请的小伙伴看过来哦👀 ㊙️本次暑期实习优先考虑2025年本科及以上学历的毕业生,此次只有“审计及鉴定”“税务与商务咨询”两个部门开放了岗位~ ⚠️测评注意事项: ὄ…...
python对视频进行帧处理以及裁减部分区域
视频截取帧 废话不多说直接上代码: from cv2 import VideoCapture from cv2 import imwrite# 定义保存图片函数 # image:要保存的图片名字 # addr;图片地址与相片名字的前部分 # num: 相片,名字的后缀。int 类型 def save_image(image, add…...
Python栈的编程题目
你好,我是悦创。 下面是三道关于栈的编程题目,适合不同难度级别的练习: 1. 有效的括号(简单) 题目描述: 给定一个只包括 (,),{,},[ 和 ] 的字符串…...
ROS云课三分钟外传之CoppeliaSim_Edu_V4_1_0_Ubuntu16_04
三分钟热度试一试吧,走过路过不要错过。 参考之前: 从云课五分钟到一分钟之v-rep_pro_edu_v3_6_2-CSDN博客 git clone https://gitcode.net/ZhangRelay/v-rep_pro_edu_v3_6_2_ubuntu16_04.gittar -xf v-rep_pro_edu_v3_6_2_ubuntu16_04/V-REP_PRO_EDU…...
day28回溯算法part04| 93.复原IP地址 78.子集 90.子集II
**93.复原IP地址 ** 本期本来是很有难度的,不过 大家做完 分割回文串 之后,本题就容易很多了 题目链接/文章讲解 | 视频讲解 class Solution { public:vector<string> result;// pointNum记录加入的点的数量,其等于3的时候停止void b…...
SpringBoot项目启动时“jar中没有主清单属性”异常
资料参考 Spring Boot 启动时 “jar中没有主清单属性” 异常 - spring 中文网 (springdoc.cn) 实际解决 更详细的参考以上,我这边的话只需要在 pom文件 中加上 spring-boot-maven-plugin 插件就能解决该异常,具体如下: <build><p…...
vAttention:用于在没有Paged Attention的情况下Serving LLM
文章目录 0x0. 前言(太长不看版)0x1. 摘要0x2. 介绍&背景0x3. 使用PagedAttention模型的问题0x3.1 需要重写注意力kernel0x3.2 在服务框架中增加冗余0x3.3 性能开销0x3.3.1 GPU上的运行时开销0x3.3.2 CPU上的运行时开销 0x4. 对LLM服务系统的洞察0x5…...
synchronized 学习
学习源: https://www.bilibili.com/video/BV1aJ411V763?spm_id_from333.788.videopod.episodes&vd_source32e1c41a9370911ab06d12fbc36c4ebc 1.应用场景 不超卖,也要考虑性能问题(场景) 2.常见面试问题: sync出…...
智慧工地云平台源码,基于微服务架构+Java+Spring Cloud +UniApp +MySql
智慧工地管理云平台系统,智慧工地全套源码,java版智慧工地源码,支持PC端、大屏端、移动端。 智慧工地聚焦建筑行业的市场需求,提供“平台网络终端”的整体解决方案,提供劳务管理、视频管理、智能监测、绿色施工、安全管…...
IGP(Interior Gateway Protocol,内部网关协议)
IGP(Interior Gateway Protocol,内部网关协议) 是一种用于在一个自治系统(AS)内部传递路由信息的路由协议,主要用于在一个组织或机构的内部网络中决定数据包的最佳路径。与用于自治系统之间通信的 EGP&…...
剑指offer20_链表中环的入口节点
链表中环的入口节点 给定一个链表,若其中包含环,则输出环的入口节点。 若其中不包含环,则输出null。 数据范围 节点 val 值取值范围 [ 1 , 1000 ] [1,1000] [1,1000]。 节点 val 值各不相同。 链表长度 [ 0 , 500 ] [0,500] [0,500]。 …...
【SQL学习笔记1】增删改查+多表连接全解析(内附SQL免费在线练习工具)
可以使用Sqliteviz这个网站免费编写sql语句,它能够让用户直接在浏览器内练习SQL的语法,不需要安装任何软件。 链接如下: sqliteviz 注意: 在转写SQL语法时,关键字之间有一个特定的顺序,这个顺序会影响到…...
【Go】3、Go语言进阶与依赖管理
前言 本系列文章参考自稀土掘金上的 【字节内部课】公开课,做自我学习总结整理。 Go语言并发编程 Go语言原生支持并发编程,它的核心机制是 Goroutine 协程、Channel 通道,并基于CSP(Communicating Sequential Processes࿰…...
Redis数据倾斜问题解决
Redis 数据倾斜问题解析与解决方案 什么是 Redis 数据倾斜 Redis 数据倾斜指的是在 Redis 集群中,部分节点存储的数据量或访问量远高于其他节点,导致这些节点负载过高,影响整体性能。 数据倾斜的主要表现 部分节点内存使用率远高于其他节…...
深度学习习题2
1.如果增加神经网络的宽度,精确度会增加到一个特定阈值后,便开始降低。造成这一现象的可能原因是什么? A、即使增加卷积核的数量,只有少部分的核会被用作预测 B、当卷积核数量增加时,神经网络的预测能力会降低 C、当卷…...
【Go语言基础【13】】函数、闭包、方法
文章目录 零、概述一、函数基础1、函数基础概念2、参数传递机制3、返回值特性3.1. 多返回值3.2. 命名返回值3.3. 错误处理 二、函数类型与高阶函数1. 函数类型定义2. 高阶函数(函数作为参数、返回值) 三、匿名函数与闭包1. 匿名函数(Lambda函…...
Python Ovito统计金刚石结构数量
大家好,我是小马老师。 本文介绍python ovito方法统计金刚石结构的方法。 Ovito Identify diamond structure命令可以识别和统计金刚石结构,但是无法直接输出结构的变化情况。 本文使用python调用ovito包的方法,可以持续统计各步的金刚石结构,具体代码如下: from ovito…...
