CNDBA社区
1.准备一台新主机：
2.关闭selinux，防火墙
3.为新主机创建用户 、组和目录，并授权
4.系统文件设置
5.yum安装
6.配置IP和hosts、hostname
7.配置grid和oracle用户环境变量
8.配置裸盘
9.安装cvuqdisk包：rpm -ivh cvuqdisk-1.0.7-1.rpm
10.配置grid，oracle互信
11.准备环境必须与现有环境保持一致。
oracle rac添加新的节点
192.168.56.250 rac01
172.168.56.250 rac01-priv
192.168.56.252 rac01-vip
192.168.56.251 rac02
172.168.56.251 rac02-priv
192.168.56.253 rac02-vip
192.168.56.254 rac-scan
###new node
192.168.56.150 rac03
172.168.56.150 rac03-priv
192.168.56.152 rac03-vip
192.168.56.151 rac04
172.168.56.151 rac04-priv
192.168.56.153 rac04-vip
[grid@rac01 ~]$ cluvfy comp peer -refnode rac01 -n rac03 -verbose
Verifying Peer Compatibility ...PASSED
Verification of peer compatibility was successful.
CVU operation performed: peer compatibility
Date: Feb 15, 2023 11:10:33 AM
CVU home: /u01/app/19.3.0/grid/
User: grid
[grid@rac01 ~]$ cluvfy stage -pre nodeadd -n rac03 -fixup -verbose
[grid@rac01 ~]$ cd $ORACLE_HOME/addnode
[grid@rac01 ~]$ ./addnode.sh -silent -ignoreSysPrereqs -ignorePrereqFailure "CLUSTER_NEW_NODES={rac03}" "CLUSTER_NEW_PRIVATE_NODE_NAMES={rac03-priv}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac03-vip}"
在rac03节点:
[root@rac03 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@rac03 ~]# /u01/app/19.3.0/grid/root.sh
Check /u01/app/19.3.0/grid/install/root_rac03_2023-02-15_14-39-23-265431395.log for the output of root script
[grid@rac01 addnode]$ su - oracle
[oracle@rac01 ~]$ cd $ORACLE_HOME/addnode
[oracle@rac01 ~]$ ./addnode.sh -silent -ignoreSysPrereqs -ignorePrereqFailure "CLUSTER_NEW_NODES={rac03}"
[oracle@rac01 addnode]$ dbca -ignorePreReqs -ignorePrereqFailure -silent -addInstance -nodeName rac03 -gdbName cxmtdb -instanceName cxmtdb3 -sysDBAUserName sys -sysDBAPassword wwwwww
Prepare for db operation
40% complete
Adding instance
48% complete
52% complete
56% complete
60% complete
64% complete
68% complete
72% complete
80% complete
Completing instance management.
86% complete
100% complete
Instance "cxmtdb3" added successfully on node "rac03".
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cxmtdb/cxmtdb.log" for further details.
[oracle@rac01 .ssh]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 15 18:57:55 2023
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> select inst_id,open_mode from gv$database;
INST_ID OPEN_MODE
---------- ----------------------------------------
1 READ WRITE
2 READ WRITE
3 READ WRITE
版权声明：本文为博主原创文章，未经博主允许不得转载。
oracle
