반응형
Oracle DB S/W addnode
[oracle@datarac1 addnode]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@datarac1 addnode]$ env | grep SID
ORACLE_SID=DATARAC1
[oracle@datarac1 addnode]$ pwd
/u01/app/oracle/product/19.0.0/db_1/addnode
[oracle@datarac1 addnode]$ ls
addnode_oraparam.ini addnode_oraparam.ini.sbs addnode.pl addnode.sh
[oracle@datarac1 addnode]$
[oracle@datarac1 addnode]$
[oracle@datarac1 addnode]$ ./addnode.sh -silent -ignoreSysPrereqs -ignorePrereqFailure \
> -waitForCompletion CLUSTER_NEW_NODES=datarac3
[WARNING] [INS-13013] Target environment does not meet some mandatory requirements.
CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/addNodeActions2023-05-22_05-51-48PM.log
ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/addNodeActions2023-05-22_05-51-48PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
Prepare Configuration in progress.
Prepare Configuration successful.
.................................................. 7% Done.
Copy Files to Remote Nodes in progress.
.................................................. 12% Done.
.................................................. 18% Done.
..............................
Copy Files to Remote Nodes successful.
You can find the log of this install session at:
/u01/app/oraInventory/logs/addNodeActions2023-05-22_05-51-48PM.log
Instantiate files in progress.
Instantiate files successful.
.................................................. 52% Done.
Saving cluster inventory in progress.
.................................................. 89% Done.
Saving cluster inventory successful.
The Cluster Node Addition of /u01/app/oracle/product/19.0.0/db_1 was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2023-05-22_05-51-48PM.log' for more details.
Setup Oracle Base in progress.
Setup Oracle Base successful.
.................................................. 96% Done.
As a root user, execute the following script(s):
1. /u01/app/oracle/product/19.0.0/db_1/root.sh
Execute /u01/app/oracle/product/19.0.0/db_1/root.sh on the following nodes:
[datarac3]
Successfully Setup Software with warning(s).
.................................................. 100% Done.
[oracle@datarac1 addnode]$
추가 Node에서 root.sh 실행
[root@datarac3 ~]# id
uid=0(root) gid=0(root) groups=0(root) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[root@datarac3 ~]#
[root@datarac3 ~]# /u01/app/oracle/product/19.0.0/db_1/root.sh
Check /u01/app/oracle/product/19.0.0/db_1/install/root_datarac3.localdomain_2023-05-22_18-00-18-763394494.log for the output of root script
[root@datarac3 ~]#
DB Instance 추가
[oracle@datarac1 ~]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@datarac1 ~]$ env | grep SID
ORACLE_SID=DATARAC1
[oracle@datarac1 ~]$
[oracle@datarac1 ~]$ dbca -silent -addInstance -gdbName DATARAC -nodeName datarac3 -instanceName DATARAC3
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 "DATARAC" added successfully on node "datarac3".
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/DATARAC/DATARAC.log" for further details.
[oracle@datarac1 ~]$
최종 상태 확인
[oracle@datarac1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE datarac1 STABLE
ONLINE ONLINE datarac2 STABLE
ONLINE ONLINE datarac3 STABLE
ora.chad
ONLINE ONLINE datarac1 STABLE
ONLINE ONLINE datarac2 STABLE
ONLINE ONLINE datarac3 STABLE
ora.net1.network
ONLINE ONLINE datarac1 STABLE
ONLINE ONLINE datarac2 STABLE
ONLINE ONLINE datarac3 STABLE
ora.ons
ONLINE ONLINE datarac1 STABLE
ONLINE ONLINE datarac2 STABLE
ONLINE ONLINE datarac3 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE datarac1 STABLE
2 ONLINE ONLINE datarac2 STABLE
3 ONLINE ONLINE datarac3 STABLE
ora.DATA1.dg(ora.asmgroup)
1 ONLINE ONLINE datarac1 STABLE
2 ONLINE ONLINE datarac2 STABLE
3 ONLINE ONLINE datarac3 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE datarac1 STABLE
ora.OCRVOTE.dg(ora.asmgroup)
1 ONLINE ONLINE datarac1 STABLE
2 ONLINE ONLINE datarac2 STABLE
3 ONLINE ONLINE datarac3 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE datarac1 Started,STABLE
2 ONLINE ONLINE datarac2 Started,STABLE
3 ONLINE ONLINE datarac3 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE datarac1 STABLE
2 ONLINE ONLINE datarac2 STABLE
3 ONLINE ONLINE datarac3 STABLE
ora.cvu
1 ONLINE ONLINE datarac1 STABLE
ora.datarac.db
1 ONLINE ONLINE datarac1 Open,HOME=/u01/app/o
racle/product/19.0.0
/db_1,STABLE
2 ONLINE ONLINE datarac2 Open,HOME=/u01/app/o
racle/product/19.0.0
/db_1,STABLE
3 ONLINE ONLINE datarac3 Open,HOME=/u01/app/o
racle/product/19.0.0
/db_1,STABLE
ora.datarac1.vip
1 ONLINE ONLINE datarac1 STABLE
ora.datarac2.vip
1 ONLINE ONLINE datarac2 STABLE
ora.datarac3.vip
1 ONLINE ONLINE datarac3 STABLE
ora.qosmserver
1 ONLINE ONLINE datarac1 STABLE
ora.scan1.vip
1 ONLINE ONLINE datarac1 STABLE
--------------------------------------------------------------------------------
[oracle@datarac1 ~]$
반응형