1.在原有节点检查新建节点是否满足需求：

[root@rac01 ~]# su - grid
[grid@rac01 ~]$ cluvfy comp peer -refnode rac01 -n rac04 -verbose
[grid@rac01 ~]$ cluvfy stage -pre nodeadd -n rac04 -fixup -verbose

2.新节点添加GI：http://www.cndba.cn/hbhe0316/article/116438http://www.cndba.cn/hbhe0316/article/116438http://www.cndba.cn/hbhe0316/article/116438

[grid@rac01 ~]$ cd $ORACLE_HOME/addnode
[grid@rac01 ~]$ ./addnode.sh -silent -ignoreSysPrereqs -ignorePrereqFailure "CLUSTER_NEW_NODES={rac04}" "CLUSTER_NEW_PRIVATE_NODE_NAMES={rac04-priv}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac04-vip}"

3.在rac04节点http://www.cndba.cn/hbhe0316/article/116438

[root@rac04 u01]# /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@rac04 u01]# /u01/app/19.3.0/grid/root.sh
Check /u01/app/19.3.0/grid/install/root_rac04_2023-02-15_20-48-57-899509433.log for the output of root script

4.在rac01节点http://www.cndba.cn/hbhe0316/article/116438

[grid@rac01 addnode]$ su - oracle
[oracle@rac01 ~]$ cd $ORACLE_HOME/addnode
[oracle@rac01 ~]$ ./addnode.sh -silent -ignoreSysPrereqs -ignorePrereqFailure "CLUSTER_NEW_NODES={rac04}"

[oracle@rac01 addnode]$ dbca -ignorePreReqs -ignorePrereqFailure -silent -addInstance -nodeName rac04 -gdbName CXMTDB -instanceName CXMTDB4 -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 "CXMTDB4" added successfully on node "rac04".
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cxmtdb/cxmtdb0.log" for further details.

5.验证是否添加完成

[oracle@rac01 addnode]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 15 22:41:17 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
---------- ----------------------------------------
         2 READ WRITE
         3 READ WRITE
         4 READ WRITE
         1 READ WRITE

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle