Add a Node to Oracle 12cR1 RAC on RHEL 6
The generic steps to follow when adding the new node to the cluster are:
Install Operating System
Install required software
Add/modify users and groups required for the installation
Configure network
Configure kernel parameters
Configure services required such as NTP
Configure storage (multipathing, zoning, storage discovery,UDEV, ASMLib)
zhongwc3 node
[oracle@zhongwc1 addnode]$ ./addnode.sh -silent "CLUSTER_NEW_NODES={zhongwc3}"Starting Oracle Universal Installer...Checking Temp space: must be greater than 120 MB. Actual 45068 MB PassedChecking swap space: must be greater than 150 MB. Actual 8176 MB PassedPrepare Configuration in progress.Prepare Configuration successful................................................... 9% Done.You can find the log of this install session at: /u01/app/oraInventory/logs/addNodeActions2013-10-21_09-37-23PM.logInstantiate files in progress.Instantiate files successful................................................... 15% Done.Copying files to node in progress.Copying files to node successful................................................... 79% Done.Saving cluster inventory in progress................................................... 87% Done.Saving cluster inventory successful.The Cluster Node Addition of /u01/app/oracle/product/12.1.0/db_1 was successful.Please check '/tmp/silentInstall.log' for more details.As a root user, execute the following script(s): 1. /u01/app/oracle/product/12.1.0/db_1/root.shExecute /u01/app/oracle/product/12.1.0/db_1/root.sh on the following nodes: [zhongwc3]..........Update Inventory in progress................................................... 100% Done.Update Inventory successful.Successfully Setup Software.[root@zhongwc3 ~]# /u01/app/oracle/product/12.1.0/db_1/root.sh
[root@zhongwc3 ~]# cat /u01/app/oracle/product/12.1.0/db_1/install/root_zhongwc3_2013-10-21_21-50-25.logPerforming root user operation for Oracle 12c The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/12.1.0/db_1 Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.
Add Instance to Clustered Database
A database instance will be established on the new node. Specifically, an instance named "zwc3" will be added to "zwc" a pre-existing clustered database.
Satisfy Node Instance Dependencies
Satisfy all node instance dependencies, such as init.ora parameters, etc.
From the new node "zhongwc3", run the following commands to create the passwordfile, "init.ora" file, and "oratab" entry for the new instance
[oracle@zhongwc3 ~]$ srvctl add instance -d zwc -i zwc3 -n zhongwc3[oracle@zhongwc3 ~]$ srvctl status database -d zwc -vInstance zwc1 is running on node zhongwc1 with online services crm. Instance status: Open.Instance zwc2 is running on node zhongwc2 with online services erp. Instance status: Open.Instance zwc3 is not running on node zhongwc3[oracle@zhongwc3 ~]$ [oracle@zhongwc3 ~]$ srvctl config database -d zwcDatabase unique name: zwcDatabase name: zwcOracle home: /u01/app/oracle/product/12.1.0/db_1Oracle user: oracleSpfile: +DATADG/zwc/spfilezwc.oraPassword file: +DATADG/zwc/orapwzwcDomain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: zwcDatabase instances: zwc1,zwc2,zwc3Disk Groups: FRADG,DATADGMount point paths: Services: crm,erpType: RACStart concurrency: Stop concurrency: Database is administrator managed
Start "zwc3" Instance
Now that all the prerequisites have been satisfied and OCR updated, the "zwc3" instance will be started.
Start the newly created instance "zwc3" and verify
[root@zhongwc3 ~]# crsctl stat res -t--------------------------------------------------------------------------------Name Target State Server State details --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATADG.dg ONLINE ONLINE zhongwc1 STABLE ONLINE ONLINE zhongwc2 STABLE ONLINE ONLINE zhongwc3 STABLEora.FRADG.dg ONLINE ONLINE zhongwc1 STABLE ONLINE ONLINE zhongwc2 STABLE ONLINE ONLINE zhongwc3 STABLEora.LISTENER.lsnr ONLINE ONLINE zhongwc1 STABLE ONLINE ONLINE zhongwc2 STABLE ONLINE ONLINE zhongwc3 STABLEora.SYSDG.dg ONLINE ONLINE zhongwc1 STABLE ONLINE ONLINE zhongwc2 STABLE ONLINE ONLINE zhongwc3 STABLEora.asm ONLINE ONLINE zhongwc1 Started,STABLE ONLINE ONLINE zhongwc2 Started,STABLE ONLINE ONLINE zhongwc3 Started,STABLEora.net1.network ONLINE ONLINE zhongwc1 STABLE ONLINE ONLINE zhongwc2 STABLE ONLINE ONLINE zhongwc3 STABLEora.ons ONLINE ONLINE zhongwc1 STABLE ONLINE ONLINE zhongwc2 STABLE ONLINE ONLINE zhongwc3 STABLE--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE zhongwc1 STABLEora.MGMTLSNR 1 ONLINE ONLINE zhongwc1 169.254.198.87 172.1 68.1.31,STABLEora.cvu 1 ONLINE ONLINE zhongwc1 STABLEora.mgmtdb 1 ONLINE ONLINE zhongwc1 Open,STABLEora.oc4j 1 ONLINE ONLINE zhongwc1 STABLEora.scan1.vip 1 ONLINE ONLINE zhongwc1 STABLEora.zhongwc1.vip 1 ONLINE ONLINE zhongwc1 STABLEora.zhongwc2.vip 1 ONLINE ONLINE zhongwc2 STABLEora.zhongwc3.vip 1 ONLINE ONLINE zhongwc3 STABLEora.zwc.crm.svc 1 ONLINE ONLINE zhongwc1 STABLEora.zwc.db 1 ONLINE ONLINE zhongwc1 Open,STABLE 2 ONLINE ONLINE zhongwc2 Open,STABLE 3 ONLINE ONLINE zhongwc3 Open,STABLEora.zwc.erp.svc 1 ONLINE ONLINE zhongwc2 STABLE--------------------------------------------------------------------------------