首页 > 数据库 >【Oracle Real Application Cluster Database】集群增加节点

【Oracle Real Application Cluster Database】集群增加节点

时间:2023-08-19 10:31:37浏览次数:40  
标签:Real node03 node01 Database Cluster grid ssh ONLINE ora

[grid@node03 ~]$ ssh-keygen
[grid@node03 ~]$ ssh-copy-id -i ~/.ssh/id_rsa.pub grid@node03
[grid@node03 ~]$ ssh-copy-id -i ~/.ssh/id_rsa.pub grid@node01
[grid@node03 ~]$ (ssh node01 "date;hostname";ssh node03 "date;hostname")
Sat Aug 19 09:12:25 CST 2023
node01
Sat Aug 19 09:12:25 CST 2023
node03

[grid@node01 ~]$ ssh-copy-id -i ~/.ssh/id_rsa.pub grid@node03
[grid@node01 ~]$ (ssh node01 "date;hostname";ssh node03 "date;hostname")
Sat Aug 19 09:12:44 CST 2023
node01
Sat Aug 19 09:12:44 CST 2023
node03

[grid@node01 ~]$ export IGNORE_PREADDNODE_CHECKS=Y

[grid@node01 ~]$ cd $ORACLE_HOME/oui/bin
[grid@node01 bin]$ ./addNode.sh -silent "CLUSTER_NEW_NODES={node03}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={node03-vip}"
......
/u01/app/oraInventory/orainstRoot.sh #On nodes node03
/u01/app/11.2.0.4/grid/root.sh #On nodes node03
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts in each cluster node

The Cluster Node Addition of /u01/app/11.2.0.4/grid was successful.
Please check '/tmp/silentInstall.log' for more details.

[root@node03 ~]# /u01/app/oraInventory/orainstRoot.sh
[root@node03 ~]# /u01/app/11.2.0.4/grid/root.sh
[oracle@node03 ~]$ ssh-keygen
[oracle@node03 ~]$ ssh-copy-id -i ~/.ssh/id_rsa.pub oracle@node03
[oracle@node03 ~]$ ssh-copy-id -i ~/.ssh/id_rsa.pub oracle@node01
[oracle@node03 ~]$ (ssh node01 "date;hostname";ssh node03 "date;hostname")
Sun May  5 10:12:58 CST 2019
node01
Sun May  5 10:12:58 CST 2019
node03

[oracle@node01 ~]$ ssh-copy-id -i ~/.ssh/id_rsa.pub oracle@node03
[oracle@node01 ~]$ (ssh node01 "date;hostname";ssh node03 "date;hostname")
Sat Aug 19 09:18:06 CST 2023
node01
Sat Aug 19 09:18:06 CST 2023
node03

[oracle@node01 ~]$ cd $ORACLE_HOME/oui/bin
[oracle@node01 bin]$ ./addNode.sh -silent "CLUSTER_NEW_NODES={node03}"
......
/u01/app/oracle/product/11.2.0/db_1/root.sh #On nodes node03
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts in each cluster node
    
The Cluster Node Addition of /u01/app/oracle/product/11.2.0/db_1 was successful.
Please check '/tmp/silentInstall.log' for more details.

[root@node03 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh
[oracle@node01 ~]$ dbca

【Oracle Real Application Cluster Database】集群增加节点_oracle

【Oracle Real Application Cluster Database】集群增加节点_oracle_02

【Oracle Real Application Cluster Database】集群增加节点_oracle_03

【Oracle Real Application Cluster Database】集群增加节点_oracle_04

【Oracle Real Application Cluster Database】集群增加节点_oracle_05

【Oracle Real Application Cluster Database】集群增加节点_oracle_06

【Oracle Real Application Cluster Database】集群增加节点_oracle_07

【Oracle Real Application Cluster Database】集群增加节点_oracle_08

[grid@node03 ~]$ crsctl check cluster -all
**************************************************************
node01:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
node02:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
node03:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************

[grid@node03 ~]$ crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       node03                   Started             
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       node03                                       
ora.crf
      1        ONLINE  ONLINE       node03                                       
ora.crsd
      1        ONLINE  ONLINE       node03                                       
ora.cssd
      1        ONLINE  ONLINE       node03                                       
ora.cssdmonitor
      1        ONLINE  ONLINE       node03                                       
ora.ctssd
      1        ONLINE  ONLINE       node03                   OBSERVER            
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       node03                                       
ora.gipcd
      1        ONLINE  ONLINE       node03                                       
ora.gpnpd
      1        ONLINE  ONLINE       node03                                       
ora.mdnsd
      1        ONLINE  ONLINE       node03     
                                  
[grid@node03 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       node01                                     
               ONLINE  ONLINE       node02                                     
               ONLINE  ONLINE       node03                                     
ora.FRA.dg
               ONLINE  ONLINE       node01                                     
               ONLINE  ONLINE       node02                                     
               ONLINE  ONLINE       node03                                     
ora.LISTENER.lsnr
               ONLINE  ONLINE       node01                                     
               ONLINE  ONLINE       node02                                     
               ONLINE  ONLINE       node03                                     
ora.OCRVDISK.dg
               ONLINE  ONLINE       node01                                     
               ONLINE  ONLINE       node02                                     
               ONLINE  ONLINE       node03                                     
ora.asm
               ONLINE  ONLINE       node01                 Started             
               ONLINE  ONLINE       node02                 Started             
               ONLINE  ONLINE       node03                 Started             
ora.gsd
               OFFLINE OFFLINE      node01                                     
               OFFLINE OFFLINE      node02                                     
               OFFLINE OFFLINE      node03                                     
ora.net1.network
               ONLINE  ONLINE       node01                                     
               ONLINE  ONLINE       node02                                     
               ONLINE  ONLINE       node03                                     
ora.ons
               ONLINE  ONLINE       node01                                     
               ONLINE  ONLINE       node02                                     
               ONLINE  ONLINE       node03                                     
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       node01                                     
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       node03                                     
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       node02                                     
ora.cvu
      1        ONLINE  ONLINE       node02                                     
ora.oc4j
      1        ONLINE  ONLINE       node02                                     
ora.scan1.vip
      1        ONLINE  ONLINE       node01                                     
ora.scan2.vip
      1        ONLINE  ONLINE       node03                                     
ora.scan3.vip
      1        ONLINE  ONLINE       node02                                     
ora.node.db
      1        ONLINE  ONLINE       node01                 Open                
      2        ONLINE  ONLINE       node02                 Open                
      3        ONLINE  ONLINE       node03                 Open                
ora.node01.vip
      1        ONLINE  ONLINE       node01                                     
ora.node02.vip
      1        ONLINE  ONLINE       node02                                     
ora.node03.vip
      1        ONLINE  ONLINE       node03                                      

标签:Real,node03,node01,Database,Cluster,grid,ssh,ONLINE,ora
From: https://blog.51cto.com/dbprofessional/7147241

相关文章

  • 【Oracle RAC Database】创建ASM磁盘组与RAC Database
    [grid@node01~]$asmca[oracle@node01~]$dbca[grid@node01~]$crsctlstatusres-t--------------------------------------------------------------------------------NAMETARGETSTATESERVERSTATE_DETAILS---------......
  • 分布式存储系统举例剖析(elasticsearch,kafka,redis-cluster)
    1.概述对于分布式系统,人们首先对现实中的分布式系统进行高层抽象,然后做出各种假设,发展了诸如CAP,FLP等理论,提出了很多一致性模型,Paxos是其中最璀璨的明珠。我们对分布式系统的时序,复制模式,一致性等基础理论特别关注。在共识算法的基础上衍生了选举算法,并且为分布式事务提供......
  • 【Oracle RAC Database】通过ASMLIB创建ASM DISK
    [root@node01~]#groupadd-g1200dba[root@node01~]#groupadd-g1201oinstall[root@node01~]#groupadd-g1202asmadmin[root@node01~]#groupadd-g1203asmdba[root@node01~]#useradd-u1100-goinstall-Gasmadmin,asmdba,dbagrid[root@node01~]......
  • 【Oracle RAC Database】通过DNS实现SCAN VIP的域名解析
    [root@node04~]#yuminstall-ybind[root@node04~]#vim/etc/named.confoptions{listen-onport53{192.168.1.104;};/*listen-on-v6port53{::1;};*/directory"/var/named";dump-file"/v......
  • unable to open database file , EF生成SQLite数据库
    前言:  记录下,忘了再回头看看。unabletoopendatabasefile 错误  如果使用EF生成SQLite数据库,发现报出错误unabletoopendatabasefile,请检查下“存放SQLite数据文件的文件夹是否存在”......
  • k8s Service(一) ClusterIP、NodePort、LoadBalancer、externalIPs 演示
    目录:Service简介kube-proxy3种不同的数据调度模式Service资源的定义格式示例1:ClusterIP演示示例2:NodePort演示示例3:LoadBalancer演示示例4:externalIPs演示Service简介Service:可以理解为pod的负债均衡器,标准资源类型,ServiceController为动态的一组Pod提......
  • redis安装及redis cluster创建
    redis安装及rediscluster创建先检查是否安装GCC,若无则先安装GCC,不然编译redis会报错。命令:gcc-v若提示命令未找到则没有。可按照GCCG++环境离线配置.docx文档添加。步骤一:下载redis安装包并通过xftp上传到服务器链接:http://download.redis.io/releases/步骤二:解压redis安装包命......
  • redis cluster查询过期key
    redis以前也就部署好没管过,这次用的云上的rediscluster,程序没有设置过期时间,所以要求手动去删除key。按以前的习惯redis-cli登录keys*查询不行,原来cluster下key是存在不同的slot下的,要去每个slot下找#查看cluster信息,特别是cluster_slots_ok的数量clusterinfocluster的slot是从......
  • Amazon EMR Hudi 性能调优——Clustering
    随着数据体量的日益增长,人们对Hudi的查询性能也提出更多要求,除了Parquet存储格式本来的性能优势之外,还希望Hudi能够提供更多的性能优化的技术途径,尤其当对Hudi表进行高并发的写入,产生了大量的小文件之后,又需要使用Presto/Trino对Hudi表进行高吞吐的即席查询的场景里。......
  • hive 的order by ,sort by,distribute by,cluster by
    orderbyorderby会对输入做全局排序,因此只有一个Reducer(多个Reducer无法保证全局有序),然而只有一个Reducer,会导致当输入规模较大时,消耗较长的计算时间,在生产环境中遇到数据量较大的情况,一般无法成功。sortbysortby不是全局排序,其在数据进入reducer前完成排序,因此,如果用sort......