oracle19c 集群新增节点并数据库实例
#新增节点db3n2
1.db3n1节点执行GI_HOME/gridSetup.sh
2.数据库添加节点addnode.sh（ORACLE_HOME目录自动拷贝到新增加节点）
$ORACLE_HOME/addnode/addnode.sh "CLUSTER_NEW_NODES={db3n2}"
查询oracle是否具有inventory写入权限，赋权后再次执行
日志路径：
/u01/app/19c/grid/oraInventory/logs
查看资源状态
手动启动新增节点数据库资源
|
[[email protected] ~]$ srvctl start instance -i orcldb2 -db orcldb |
再次查看资源状态
3.db3n1 执行dbca（ORACLE_HOME目录手动拷贝到新增加节点）
- 确认结果
|
[[email protected] ContentsXML]$ crsctl status res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE db3n1 STABLE ONLINE ONLINE db3n2 STABLE ora.chad ONLINE ONLINE db3n1 STABLE ONLINE ONLINE db3n2 STABLE ora.net1.network ONLINE ONLINE db3n1 STABLE ONLINE ONLINE db3n2 STABLE ora.ons ONLINE ONLINE db3n1 STABLE ONLINE ONLINE db3n2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE db3n1 STABLE 2 ONLINE ONLINE db3n2 STABLE 3 ONLINE OFFLINE STABLE ora.CRSDG.dg(ora.asmgroup) 1 ONLINE ONLINE db3n1 STABLE 2 ONLINE ONLINE db3n2 STABLE 3 OFFLINE OFFLINE STABLE ora.DATADG.dg(ora.asmgroup) 1 ONLINE ONLINE db3n1 STABLE 2 ONLINE ONLINE db3n2 STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE db3n1 STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE db3n1 Started,STABLE 2 ONLINE ONLINE db3n2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE db3n1 STABLE 2 ONLINE ONLINE db3n2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE db3n1 STABLE ora.db3n1.vip 1 ONLINE ONLINE db3n1 STABLE ora.db3n2.vip 1 ONLINE ONLINE db3n2 STABLE ora.orcldb.db 1 ONLINE ONLINE db3n1 Open,HOME=/u01/app/1 9c/oracle/product/19 .3.0/db_1,STABLE 2 ONLINE ONLINE db3n2 Open,HOME=/u01/app/1 9c/oracle/product/19 .3.0/db_1,STABLE ora.qosmserver 1 ONLINE ONLINE db3n1 STABLE ora.scan1.vip 1 ONLINE ONLINE db3n1 STABLE -------------------------------------------------------------------------------- [[email protected] ContentsXML]$ |