10G RAC删除和添加节点

最新推荐文章于 2021-04-10 12:17:22 发布
最新推荐文章于 2021-04-10 12:17:22 发布
阅读量1.1k 收藏 2
点赞数
分类专栏： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u010692693/article/details/52211811
版权



假设rac有两个节点rac1和rac2，rac2发生物理损坏重装系统，重新将rac2加入集群


1. 在rac1节点执行对rac2节点资源的停止任务，一定要手动执行停止操作，即使显示offline

[oracle@rac1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.orcl.db    application    ONLINE    ONLINE    rac1        
ora....l1.inst application    ONLINE    ONLINE    rac1        
ora....l2.inst application    ONLINE    OFFLINE               
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   application    ONLINE    ONLINE    rac1        
ora....SM2.asm application    ONLINE    OFFLINE               
ora....C2.lsnr application    ONLINE    OFFLINE               
ora.rac2.gsd   application    ONLINE    OFFLINE               
ora.rac2.ons   application    ONLINE    OFFLINE               
ora.rac2.vip   application    ONLINE    ONLINE    rac1        


[oracle@rac1 ~]$ srvctl stop inst -d orcl -i orcl2
[oracle@rac1 ~]$ srvctl stop nodeapps -n rac2
[oracle@rac1 ~]$ srvctl stop listener -n rac2
[oracle@rac1 ~]$ srvctl stop asm -n rac2

2. 删除群集中的rac2的资源  ---oracle

建议用图形化dbca  -->  instance management  -->  delete an instance

这里不建议用 srvctl remove instance -d orcl -i orcl2

因为 srvctl 仅仅是删除了 OCR 中的配置信息，但不会删除节点 1 的 thread、redo groups 以及 undo tablespace，而这些 dbca 都会自动做了。  

[oracle@rac1 ~]$ srvctl remove asm -n rac2

[root@rac1 ~]# cd /u01/app/oracle/product/10.2.0/crs_1/bin/
[root@rac1 bin]# ./crs_unregister ora.rac2.LISTENER_RAC2.lsnr


3. 在rac1节点，手工删除crs的远程端口记录 

[oracle@rac1 ~]$ cat $ORA_CRS_HOME/opmn/conf/ons.config
localport=6113 
remoteport=6200 
loglevel=3
useocr=on

[root@rac1 bin]# ./racgons remove_config rac2:6200
racgons: Existing key value on rac2 = 6200.
racgons: rac2:6200 removed from OCR.

[root@rac1 bin]#  ./srvctl remove nodeapps -n rac2
Please confirm that you intend to remove the node-level applications on node rac2 (y/[n]) y

4. 在rac1节点，执行节点删除脚本 
[oracle@rac1 orcl]$ olsnodes -p -i -n        --查看下需要删除的实例号 查询结果的第二列
rac1    1       rac1-priv       rac1-vip
rac2    2       rac2-priv       rac2-vip

[root@rac1 bin]# cd ../install
[root@rac1 install]# ./rootdeletenode.sh rac2,2       ----逗号后面点的2就是上面olsnodes 查出来的实例号
CRS-0210: Could not find resource 'ora.rac2.LISTENER_RAC2.lsnr'.
CRS-0210: Could not find resource 'ora.rac2.ons'.
CRS-0210: Could not find resource 'ora.rac2.vip'.
CRS-0210: Could not find resource 'ora.rac2.gsd'.
CRS-0210: Could not find resource ora.rac2.vip.
CRS nodeapps are deleted successfully
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 14 values from OCR.
Key SYSTEM.css.interfaces.noderac2 marked for deletion is not there. Ignoring.
Successfully deleted 5 keys from OCR.
Node deletion operation successful.
'rac2,2' deleted successfully 

[oracle@rac1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.orcl.db    application    ONLINE    ONLINE    rac1        
ora....l1.inst application    ONLINE    ONLINE    rac1        
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   application    ONLINE    ONLINE    rac1

5. 执行数据级别和crs级别的清单删除   --oracle用户 

[oracle@rac1 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/oui/bin/
[oracle@rac1 bin]$ ./runInstaller  -silent -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES=rac1"
Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oracle/oraInventory
'UpdateNodeList' was successful.

[oracle@rac1 bin]$ cd /u01/app/oracle/product/10.2.0/crs_1/oui/bin/
[oracle@rac1 bin]$ ./runInstaller  -silent -updateNodeList ORACLE_HOME=$ORA_CRS_HOME "CLUSTER_NODES=rac1" CRS=TURE
Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oracle/oraInventory
'UpdateNodeList' was successful.

6. 执行crs的节点添加任务 (图形化) 

[oracle@rac1 ~]$ $ORA_CRS_HOME/oui/bin/addNode.sh


[root@rac2 ~]# /u01/app/oracle/oraInventory/orainstRoot.sh 
Changing permissions of /u01/app/oracle/oraInventory to 770.
Changing groupname of /u01/app/oracle/oraInventory to oinstall.
The execution of the script is complete

[root@rac1 ~]# cd /u01/app/oracle/product/10.2.0/crs_1/install
[root@rac1 install]# sh -x rootaddnode.sh
+ ORA_CRS_HOME=/u01/app/oracle/product/10.2.0/crs_1
+ export ORA_CRS_HOME
+ CH=/u01/app/oracle/product/10.2.0/crs_1
+ ORACLE_HOME=/u01/app/oracle/product/10.2.0/crs_1
+ export ORACLE_HOME
+ ORACLE_OWNER=oracle
+ CRS_NEW_HOST_NAME_LIST=rac2,2
+ CRS_NEW_NODE_NAME_LIST=rac2,2
+ CRS_NEW_PRIVATE_NAME_LIST=rac2-priv,2
+ CRS_NEW_NODEVIPS=rac2-vip
+ UNAME=/bin/uname
++ /bin/uname
+ PLATFORM=Linux
+ '[' -z '' ']'
+ AWK=/bin/awk
+ '[' -z '' ']'
+ SED=/bin/sed
+ '[' -z '' ']'
+ ECHO=/bin/echo
+ '[' -z '' ']'
+ CUT=/usr/bin/cut
+ '[' -z '' ']'
+ ID=/usr/bin/id
+ '[' -z '' ']'
+ SU=/bin/su
+ '[' -z '' ']'
+ GREP=/bin/grep
+ '[' -z '' ']'
+ CAT=/bin/cat
++ /usr/bin/id
++ /bin/awk '-F(' '{print $2}'
++ /bin/awk '-F)' '{print $1}'
+ RUID=root
+ '[' root '!=' root ']'
+ case $PLATFORM in
+ LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/crs_1/lib
+ OCRCONFIG=/etc/oracle/ocr.loc
+ SU='/bin/su -l'
+ export LD_LIBRARY_PATH
+ CLSCFG=/u01/app/oracle/product/10.2.0/crs_1/bin/clscfg
+ /u01/app/oracle/product/10.2.0/crs_1/bin/clscfg -add -nn rac2,2 -pn rac2-priv,2 -hn rac2,2
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Attempting to add 1 new nodes to the configuration
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 2: rac2 rac2-priv rac2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
++ /bin/awk '{
        nElems = split($1, nodeList, ",");
        for (i = 1; i < nElems;)
        {
            print nodeList[i];
            i += 2;
        }
      }'
++ /bin/echo rac2,2
+ NODES_LIST=rac2
++ /u01/app/oracle/product/10.2.0/crs_1/bin/olsnodes -l
+ LOCALNODE=rac1
++ /u01/app/oracle/product/10.2.0/crs_1/bin/srvctl config nodeapps -a -n rac1
+ VIP_STRING='VIP exists.: /rac1-vip/192.168.100.47/255.255.255.0/eth0'
++ /bin/echo VIP exists.: /rac1-vip/192.168.100.47/255.255.255.0/eth0
++ /bin/awk -F/ '{ print $(NF-1)}'
+ NETMASK=255.255.255.0
++ /bin/echo VIP exists.: /rac1-vip/192.168.100.47/255.255.255.0/eth0
++ /bin/awk -F/ '{ print $NF}'
+ NETIFs=eth0
++ /bin/echo eth0
++ /bin/sed 's|:|\||g'
+ NETIFs=eth0
+ Ni=1
++ /bin/echo rac2
+ for i in '`$ECHO $NODES_LIST`'
+ NODE_NAME=rac2
++ /bin/echo rac2-vip
++ /usr/bin/cut -d, -f1
+ NODE_VIP=rac2-vip
+ NODEVIP=rac2-vip/255.255.255.0/eth0
+ /bin/echo /u01/app/oracle/product/10.2.0/crs_1/bin/srvctl add nodeapps -n rac2 -A rac2-vip/255.255.255.0/eth0 -o /u01/app/oracle/product/10.2.0/crs_1
/u01/app/oracle/product/10.2.0/crs_1/bin/srvctl add nodeapps -n rac2 -A rac2-vip/255.255.255.0/eth0 -o /u01/app/oracle/product/10.2.0/crs_1
+ /u01/app/oracle/product/10.2.0/crs_1/bin/srvctl add nodeapps -n rac2 -A rac2-vip/255.255.255.0/eth0 -o /u01/app/oracle/product/10.2.0/crs_1
++ expr 1 + 1
+ Ni=2
+ . /u01/app/oracle/product/10.2.0/crs_1/install/paramfile.crs
++ ORA_CRS_HOME=/u01/app/oracle/product/10.2.0/crs_1
++ CRS_ORACLE_OWNER=oracle
++ CRS_DBA_GROUP=oinstall
++ CRS_VNDR_CLUSTER=false
++ CRS_OCR_LOCATIONS=/dev/raw/raw1,/dev/raw/raw2
++ CRS_CLUSTER_NAME=crs
++ CRS_HOST_NAME_LIST=rac1,1,rac2,2
++ CRS_NODE_NAME_LIST=rac1,1,rac2,2
++ CRS_PRIVATE_NAME_LIST=rac1-priv,1,rac2-priv,2
++ CRS_LANGUAGE_ID=AMERICAN_AMERICA.WE8ISO8859P1
++ CRS_VOTING_DISKS=/dev/raw/raw3,/dev/raw/raw4,/dev/raw/raw5
++ CRS_NODELIST=rac1,rac2
++ CRS_NODEVIPS=rac1/rac1-vip/255.255.255.0/eth0,rac2/rac2-vip/255.255.255.0/eth0
++ eval echo '$CRS_ORACLE_OWNER'
+++ echo oracle
+ PARAM_VALUE=oracle
++ /bin/echo oracle
++ /bin/awk '/^%/ { print "false"; }'
+ valid=
+ '[' '' = false ']'
++ /bin/echo rac2
++ /bin/sed 's| |,|g'
+ COMMASEPARATED_NODE_LIST=rac2
+ /bin/su -l oracle -c '/u01/app/oracle/product/10.2.0/crs_1/bin/cluutil -sourcefile /etc/oracle/ocr.loc -destfile /u01/app/oracle/product/10.2.0/crs_1/srvm/admin/ocr.loc -nodelist rac2'
[root@rac1 install]# cat /u01/app/oracle/product/10.2.0/crs_1/opmn/conf/ons.config
localport=6113 
remoteport=6200 
loglevel=3
useocr=on

[root@rac2 ~]# cd /u01/app/oracle/product/10.2.0/crs_1/
[root@rac2 crs_1]# sh -x root.sh 
+ /u01/app/oracle/product/10.2.0/crs_1/install/rootinstall
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
+ /u01/app/oracle/product/10.2.0/crs_1/install/rootconfig
Checking to see if Oracle CRS stack is already configured
/etc/oracle does not exist. Creating it now.
OCR LOCATIONS =  /dev/raw/raw1,/dev/raw/raw2
OCR backup directory '/u01/app/oracle/product/10.2.0/crs_1/cdata/crs' does not exist. Creating now
Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root
WARNING: directory '/u01/app/oracle/product' is not owned by root
WARNING: directory '/u01/app/oracle' is not owned by root
WARNING: directory '/u01/app' is not owned by root
WARNING: directory '/u01' is not owned by root
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: rac1 rac1-priv rac1
node 2: rac2 rac2-priv rac2
clscfg: Arguments check out successfully.

NO KEYS WERE WRITTEN. Supply -force parameter to override.
-force is destructive and will destroy any previous cluster
configuration.
Oracle Cluster Registry for cluster has already been initialized
Startup will be queued to init within 30 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
CSS is active on these nodes.
        rac1
        rac2
CSS is active on all nodes.
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Waiting for the Oracle CRSD and EVMD to start
Oracle CRS stack installed and running under init(1M)
Running vipca(silent) for configuring nodeapps

Creating VIP application resource on (0) nodes.
Creating GSD application resource on (0) nodes.
Creating ONS application resource on (0) nodes.
Starting VIP application resource on (2) nodes.1:CRS-0233: Resource or relatives are currently involved with another operation.
Check the log file "/u01/app/oracle/product/10.2.0/crs_1/log/rac2/racg/ora.rac2.vip.log" for more details
..
Starting GSD application resource on (2) nodes...
Starting ONS application resource on (2) nodes.1:CRS-0233: Resource or relatives are currently involved with another operation.
Check the log file "/u01/app/oracle/product/10.2.0/crs_1/log/rac2/racg/ora.rac2.ons.log" for more details
..


Done.

[oracle@rac1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.orcl.db    application    ONLINE    ONLINE    rac1        
ora....l1.inst application    ONLINE    ONLINE    rac1        
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   application    ONLINE    ONLINE    rac1        
ora.rac2.gsd   application    ONLINE    ONLINE    rac2        
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   application    ONLINE    ONLINE    rac2

7. 在rac1执行远程节点的crs添加任务 

[root@rac1 bin]# pwd
/u01/app/oracle/product/10.2.0/crs_1/bin
[root@rac1 bin]# ./racgons add_config rac2:6200

[root@rac2 crs_1]# cat /u01/app/oracle/product/10.2.0/crs_1/opmn/conf/ons.config
localport=6113 
remoteport=6200 
loglevel=3
useocr=on

8. 在rac1执行节点添加任务向导  (图形化) 

[oracle@rac1 ~]$ $ORACLE_HOME/oui/bin/addNode.sh


[root@rac2 crs_1]# cd /u01/app/oracle/product/10.2.0/db_1/
[root@rac2 db_1]# sh root.sh
Running Oracle10 root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/10.2.0/db_1

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.sh script.
Now product-specific root actions will be performed.

9. 添加实例，有两种方法，一是图形化添加，简单方便，二是手动添加


9.1 使用图形化添加实例
    dbca   instance management   add an instance

至此，全部结束



9.2  以下是使用手动添加实例，如果9.1能添加成功，以下不需要做

在rac2手工创建asm所需的目录

[oracle@rac2 oracle]$ mkdir -p /u01/app/oracle/admin/+ASM
[oracle@rac2 oracle]$ cd admin/+ASM/
[oracle@rac2 +ASM]$ mkdir bdump cdump hdump pfile udump

将rac1的init+ASM1和orapw+ASM1文件改为2结尾的，拷贝到rac2的$ORACLE_HOME/dbs 

[oracle@rac1 ~]$ scp $ORACLE_HOME/dbs/init+ASM1.ora rac2:$ORACLE_HOME/dbs/init+ASM2.ora
scp $ORACLE_HOME/dbs/orapw+ASM1 rac2:$ORACLE_HOME/dbs/orapw+ASM2
scp $ORACLE_HOME/dbs/initorcl1.ora  rac2:$ORACLE_HOME/dbs/initorcl2.ora
scp $ORACLE_HOME/dbs/orapworcl1 rac2:$ORACLE_HOME/dbs/orapworcl2


启动rac1的asm 

[oracle@rac1 ~]$ srvctl add asm -n rac2 -i +ASM2 -o $ORACLE_HOME
[oracle@rac1 ~]$ srvctl start asm -n rac2

在rac2查询asm磁盘组是否正确 

[oracle@rac2 ~]$ export ORACLE_SID=+ASM2
[oracle@rac2 ~]$ 
[oracle@rac2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jun 4 12:11:39 2015

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> select name,state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
DATA                           MOUNTED
FRA                            MOUNTED

SQL> select name, value from v$spparameter where sid = 'orcl1';

no rows selected

在rac2手工创建所需的目录，注意权限 

[oracle@rac2 admin]$ mkdir orcl
[oracle@rac2 orcl]$ mkdir adump bdump cdump dpdump hdump pfile udump

在rac1通过sqlplus创建rac2的相关参数  --使用手动添加的原rac2的好处，如果是改为添加rac4 ，那数据库里面就要相应的建立以下信息 （如果使用dbca添加实例则会自动添加，但是原来rac2的信息还是要在数据库里手动删除如undotbs2） 

alter system set instance_number=1 scope=spfile sid='wql1';

create undo tablespace undotbs1 datafile '+WQL' size 200M; 可选

alter system set undo_tablespace='undotbs1' scope=spfile sid='wql1';

alter database add logfile thread 1 group 1 '+WQL' size 50M;

alter database add logfile thread 1 group 2 '+WQL' size 50M;

alter system set thread=1 sid='wql1';

alter database enable thread 1 ;

重启实例1  启动实例2


在RAC1上使用 netca （图形化） 配置监听 


在RAC1上使用 dbca  （图形化） 添加RAC2实例 


[oracle@rac1 orcl]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.orcl.db    application    ONLINE    ONLINE    rac1        
ora....l1.inst application    ONLINE    ONLINE    rac1        
ora....l2.inst application    ONLINE    ONLINE    rac2        
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    ONLINE    ONLINE    rac1        
ora.rac1.gsd   application    ONLINE    ONLINE    rac1        
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   application    ONLINE    ONLINE    rac1        
ora....SM2.asm application    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    ONLINE    ONLINE    rac2        
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   application    ONLINE    ONLINE    rac2

至此，全部结束 


参考文档：

https://blogs.oracle.com/Database4CN/entry/%E8%8A%82%E7%82%B9os%E9%87%8D%E8%A3%85%E5%90%8E%E5%8A%A0%E5%9B%9E%E9%9B%86%E7%BE%A4%E7%9A%84%E6%AD%A5%E9%AA%A4_10g_rac

Removing a Node from a 10gR1 RAC Cluster (Doc ID 269320.1)


Adding New Nodes to Your Oracle RAC 10g Cluster on Linux


http://www.oracle.com/technetwork/articles/vallath-nodes-095339.html















张玉龙
关注
专栏目录
(超详细)Oracle 10g RAC 删除节点实验操作总结
Samdy_Chan的专栏
09-02 3573
Oracle10g RAC 删除节点实验操作总结   目  录   RAC物理结构... 3 一.     DBCA删除dbi节点的Database实例... 4 1.1、   检查删除dbi节点的wxxrdb3实例前的crs_stat -t -v 状态... 4 1.2、   先停掉RAC 上的dbi节点实例的服务... 4 1.3、   用Xmanager连
oracle更换rac节点,oracle11g rac 如何删除损坏节点并添加新节点
weixin_39749243的博客
04-04 772
今天是2017年10月25日，之前遇到一个客户来电，大体问题是：aix 5.3+oracle 11.2.0.1 数据库为rac。其中节点一因为本地主机磁盘损坏，导致aix系统损坏进而导致了oracle rac集群只剩一个节点的故障”对于该问题，其实很简单，只要在存活节点删除之前数据库实例，在集群中删除故障节点信息后，新增节点即可。但在整个过程中遇到了各类问题(个人根据当时现状了解到，在我接手之前，...
Oracle RAC 10g集群节点删除[zt]
cuihu5034的博客
04-24 180
在本文中，我将讨论从现有Oracle RAC 10g第二版集群中删除节点所需要的步骤。出于演示目的，我们这里的环境是一个二节点的 RedHat Linux 集群。库名节点编号数据库版本实例编号操作系统内核版本文件系统集群管理器R...
10g rac节点的添加和删除
新路的专栏
12-20 844
前提条件: 这是对一套基于两个节点的rac环境的添加,添加节点之前已安装好操作系统; 内核参数已经进行修改;ORACLE用户已初始化;成功并正确的配置和共享存储; 相关rpm包均已配置;与当前rac环境中各个节点互通。 一 .初始化第三台节点 首先就需要对新节点进行适当的配置,以满足rac中的一员。 1.1配置hosts的文件 修改hosts中的文件,包括下面的内容,每个节点
Oracle 10g RAC 添加节点
Zhong Weicheng Study Notes
12-24 3550
目前环境是一个版本为10.2.0.5的双节点RAC,hostname分别为racnode1,racnode2需要添加新节点racnode3。 OS版本是Oracle Linux 5.7 x86_64 保证RAC正常运行 配置public IP,private IP,VIP,将这些信息配置到/etc/hosts文件中 192.168.1.51 rac
Oracle RAC 添加节点
weixin_34116110的博客
10-30 287
1安装准备工作 1.1Â加节点步骤 加节点不需要停机，在线操作，但需要在业务较低时段进行，若安排重启测试和业务测试，则视情况申请停机时间。 1、Â原生产库两台主机安装新的操作系统，连接现生产库所用的存储并进行多路径的配置 2、Â配置网络 3、Â检查系统包和配置等价性等一系列加节点操作，具体操作参考章节1.3~1.12 4、...
Oracle 10g RAC 删除、添加节点、版本升级配置手册
06-13
Oracle 10g Real Application Clusters (RAC) 是一种高可用性和可伸缩性的数据库解决方案，它允许多个服务器共享同一数据库实例，提供故障切换和负载均衡的能力。本配置手册将涵盖三个主要主题：删除节点、添加节点...
11grac删除添加节点
11-29
11grac 删除添加节点 RAC（Real Application Clusters）是一种高可用性解决方案，允许多个服务器节点组成一个集群来提供数据库服务。在 RAC 环境中，添加或删除节点是常见的维护操作。本文将详细介绍如何删除添加 ...
oracle11g rac 如何删除损坏节点并添加新节点
Rhys learn oracle！
10-25 5206
欢迎使用Markdown编辑器写博客本Markdown编辑器使用StackEdit修改而来，用它写博客，将会带来全新的体验哦： Markdown和扩展Markdown简洁的语法 代码块高亮 图片链接和图片上传 LaTex数学公式 UML序列图和流程图 离线写博客 导入导出Markdown文件 丰富的快捷键 快捷键 加粗 Ctrl + B 斜体 Ctrl + I 引用 Ctrl
Oracle10gRAC应用于数据库的优势分析.doc
最新发布
11-21
2. **可伸缩性差**：RAC允许动态添加或删除节点，根据业务需求灵活扩展，避免了大规模一次性投资。 3. **运维成本高**：RAC的集中管理和自动化特性降低了日常维护工作量，减少了人为错误的可能性。 4. **硬件升级...
Oracle 11gR2 RAC 添加节点 案例
10-09
现在的RAC环境是2节点的RAC，节点是RAC1和RAC2,在本文档中，我们要添加一个节点：RAC3。
(超详细)Oracle 10g RAC 添加节点实验操作总结.docx
09-02
本文档很详细都讲解了在 RHEL5(x86_64)+Oracle10gR2 RAC环境下添加RAC集群节点的方法，通过详细文字说明和截图附注解说的方法具体说明每一个操作步骤，相信大家都很容易看得明白。
rac 10g 添加节点详解
08-27 1720
目标：   当前我环境中是有两个节点RAC1 和RAC2 节点，现在增加一个RAC3节点。   概要：为现有的Oracle10g RAC 添加节点大致包括以下步骤: 1. 配置新的服务器节点上的硬件及操作系统环境 2. 向 Cluster 集群中加入该节点 3. 在新节点上安装 Oracle Database software 4. 为新的节点配置监听器 LISTENER 5.
10g_rac 增 删 节点
数据库专栏
10-02 693
2种加法  图形化或命令行 一.
Oracle Rac 11R2添加节点
weixin_34068198的博客
09-22 104
Oracle Rac 11R2添加节点 一、完成以下步骤，准备将节点添加到集群: 1、安装操作系统（版本和集群其他节点一致），同时配置hosts文件、内核参数，网络参数，及oracle rac依赖的patch 2、配置网络连接，配置共享存储映射到要添加的节点 3、创建grid、及oracle用户及相关目录及环境变量. 4、确保在节点上配置了SSH. 5、...
oracle rac删除添加节点,11G RAC 节点删除与添加
weixin_26717737的博客
04-05 352
RAC删除节点并添加节点oracle用户更新Inventory$ORACLE_HOME/oui/bin/runInstaller -updateNodelist ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES=zycdbtst3" -local删除db软件$ORACLE_HOME/deinstall/deinstall -local再在其他主机oracle 用户更新...
oracle 10g rac 卸载,Oracle 10G RAC 删除已有节点
weixin_39926014的博客
04-10 89
如果现在在RAC集群中有三个节点c1、c2、c3：如果想要卸载c3节点。1、在c1或者c2上删除c3实例运行dbca然后选择Oracle Real Application Clusters database选择Instance Management选择Delete an instance选择实例，填写用户名密码，Next选择c3: instance3，Next执行完毕2、删除r3的ASM实例(如果...
oracle 10g rac，删除故障节点并添加新节点
coujiongyong0208的博客
01-26 171
最近客户报障说一个节点失败，目前只有单节点运行，叫我们现场支持一下。到现场后，我们发现一个节点已经失败，同时他们打算用一台新机器来做，我们在现场部署后，添加节点，现在把过程记下来！ ...
『ORACLE』RAC增加节点（11g）
OFF-LINE
06-29 779
1.主机规划   节点1 节点2 节点4 Hostname rac1 Rac2 Rac2 Public IP 10.10.10.10 10.10.10.20 10.10.10.30 VIP 10.10.10.11 10
Oracle RAC 11g 添加与删除节点步骤记录
"这篇文档详细介绍了在Oracle 11g RAC环境中如何删除并添加节点，主要针对的是在节点1损坏后，如何重新安装节点1，并确保与节点2之间的正常通信。文档作者通过实际操作进行了测试和整理，以供参考。" 在Oracle RAC ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值