【Oracle Real Application Cluster Database】集群删除节点

时间：2023-08-19 15:34:11浏览次数：39

标签：Real node03 node01 Database node02 Cluster ONLINE HOME ora

[grid@node01 ~]$ srvctl stop listener -n node03
[grid@node01 ~]$ srvctl stop instance -d core -n node03

[oracle@node01 ~]$ dbca -silent -deleteInstance -nodeList node03 -gdbName core -instanceName core3 -sysDBAUserName sys -sysDBAPassword 1QAZ2wsx      

[oracle@node03 ~]$ $ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={node03}" -local

[oracle@node03 ~]$ $ORACLE_HOME/deinstall/deinstall -local

[oracle@node01 ~]$ $ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={node01,node02}"

[grid@node01 ~]$ olsnodes -s -t 
node01        Active  Unpinned
node02        Active  Unpinned
node03        Active  Unpinned

[grid@node01 ~]$ crsctl unpin css -n node03

[root@node03 ~]# yum install -y perl-Env
[root@node03 ~]# cd /u01/app/11.2.0.4/grid/crs/install
[root@node03 install]# ./rootcrs.pl -deconfig -force 

[root@node01 ~]# /u01/app/11.2.0.4/grid/bin/crsctl delete node -n node03

[grid@node03 ~]$ $ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={node03}" CRS=true -local

[grid@node03 ~]$ $ORACLE_HOME/deinstall/deinstall -local
......
Run the following command as the root user or the administrator on node "node03".
/tmp/deinstall2023-08-19_11-30-35AM/perl/bin/perl -I/tmp/deinstall2023-08-19_11-30-35AM/perl/lib -I/tmp/deinstall2023-08-19_11-30-35AM/crs/install /tmp/deinstall2023-08-19_11-30-35AM/crs/install/rootcrs.pl -force  -deconfig -paramfile "/tmp/deinstall2023-08-19_11-30-35AM/response/deinstall_Ora11g_gridinfrahome1.rsp"
Press Enter after you finish running the above commands

[root@node03 ~]# /tmp/deinstall2023-08-19_11-30-35AM/perl/bin/perl -I/tmp/deinstall2023-08-19_11-30-35AM/perl/lib -I/tmp/deinstall2023-08-19_11-30-35AM/crs/install /tmp/deinstall2023-08-19_11-30-35AM/crs/install/rootcrs.pl -force  -deconfig -paramfile "/tmp/deinstall2023-08-19_11-30-35AM/response/deinstall_Ora11g_gridinfrahome1.rsp"

[root@node03 ~]# rm -rf /etc/oraInst.loc
[root@node03 ~]# rm -rf /opt/ORCLfmap
[root@node03 ~]# rm -rf /etc/oratab

[grid@node01 ~]$ $ORACLE_HOME/oui/bin/runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={node01,node02}" CRS=true

[grid@node01 ~]$ cluvfy stage -post nodedel -n node03
Performing post-checks for node removal 
Checking CRS integrity...
Clusterware version consistency passed
CRS integrity check passed
Node removal check passed
Post-check for node removal was successful. 
 
[grid@node01 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       node01                                     
               ONLINE  ONLINE       node02                                     
ora.FRA.dg
               ONLINE  ONLINE       node01                                     
               ONLINE  ONLINE       node02                                     
ora.LISTENER.lsnr
               ONLINE  ONLINE       node01                                     
               ONLINE  ONLINE       node02                                     
ora.OCRVDISK.dg
               ONLINE  ONLINE       node01                                     
               ONLINE  ONLINE       node02                                     
ora.asm
               ONLINE  ONLINE       node01                 Started             
               ONLINE  ONLINE       node02                 Started             
ora.gsd
               OFFLINE OFFLINE      node01                                     
               OFFLINE OFFLINE      node02                                     
ora.net1.network
               ONLINE  ONLINE       node01                                     
               ONLINE  ONLINE       node02                                     
ora.ons
               ONLINE  ONLINE       node01                                     
               ONLINE  ONLINE       node02                                     
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       node01                                     
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       node01                                     
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       node01                                     
ora.scan3.vip
      1        ONLINE  ONLINE       node02                                     
ora.node.db
      2        ONLINE  ONLINE       node02                 Open                
      3        ONLINE  ONLINE       node01                 Open                
ora.node01.vip
      1        ONLINE  ONLINE       node01                                     
ora.node02.vip
      1        ONLINE  ONLINE       node02

标签：Real,node03,node01,Database,node02,Cluster,ONLINE,HOME,ora
From： https://blog.51cto.com/dbprofessional/7150070

Visual Studio 2022 没有MySQLDatabase数据源
解决办法： ①下载安装MySQLODBC驱动②运行ODBC数据源管理器③添加MySQL数据源，填入相应信息，测试通过即可④打开VS 工具>>连接到数据库，选择MicrosoftODBCDataSource⑤下拉列表中选择刚才新建的ODBC数据源，确定。由此，在VS的侧边栏就可以对MySQL......
Songshan-Lake Cluster
SongshanLakeLaboratory PlatformforDataDrivenComputationalMaterialsDiscovery TiangongSupercomputer----------------------------------......
【Oracle Real Application Cluster Database】集群增加节点
[grid@node03~]$ssh-keygen[grid@node03~]$ssh-copy-id-i~/.ssh/id_rsa.pubgrid@node03[grid@node03~]$ssh-copy-id-i~/.ssh/id_rsa.pubgrid@node01[grid@node03~]$(sshnode01"date;hostname";sshnode03"date;hostname")SatAug19......
【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安装包命......

【Oracle Real Application Cluster Database】集群删除节点

相关文章

赞助商

阅读排行