Saturday, 4 March 2017

Add additional node to 12cR2 RAC Cluster Testing




$ ./gridSetup.sh

Launching Oracle Grid Infrastructure Setup Wizard...

 Click Next 


Pass the additional Node details . Next two screen it does all checks. Click OK.



Run the listed two scripts -

root@racdb02::/root
$ /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@racdb02::/root
$ /u01/app/grid/software/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/grid/software

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/grid/software/crs/install/crsconfig                                _params
The log of current session can be found at:
  /u01/app/grid12cR2/crsdata/racdb02/crsconfig/rootcrs_racdb02_2017-03-04_08-17-                                58PM.log
2017/03/04 20:18:06 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
2017/03/04 20:18:06 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Col                                lector.
2017/03/04 20:18:55 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2017/03/04 20:18:55 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
2017/03/04 20:18:59 CLSRSC-363: User ignored prerequisites during installation
2017/03/04 20:18:59 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
2017/03/04 20:19:00 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
2017/03/04 20:19:00 CLSRSC-594: Executing installation step 5 of 19: 'SaveParamFile'.
2017/03/04 20:19:03 CLSRSC-594: Executing installation step 6 of 19: 'SetupOSD'.
2017/03/04 20:19:07 CLSRSC-594: Executing installation step 7 of 19: 'CheckCRSConfig'.
2017/03/04 20:19:08 CLSRSC-594: Executing installation step 8 of 19: 'SetupLocalGPNP'.
2017/03/04 20:19:09 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.
2017/03/04 20:19:12 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.
2017/03/04 20:19:12 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.
2017/03/04 20:19:13 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.
2017/03/04 20:19:28 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf'
2017/03/04 20:19:56 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2017/03/04 20:21:00 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'racdb02'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'racdb02' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2017/03/04 20:21:34 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2017/03/04 20:21:35 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'racdb02'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'racdb02' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'racdb02'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'racdb02'
CRS-2677: Stop of 'ora.drivers.acfs' on 'racdb02' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'racdb02' has completed
CRS-4133: Oracle High Availability Services has been stopped.
2017/03/04 20:21:51 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start 'ora.mdnsd' on 'racdb02'
CRS-2672: Attempting to start 'ora.evmd' on 'racdb02'
CRS-2676: Start of 'ora.mdnsd' on 'racdb02' succeeded
CRS-2676: Start of 'ora.evmd' on 'racdb02' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'racdb02'
CRS-2676: Start of 'ora.gpnpd' on 'racdb02' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'racdb02'
CRS-2676: Start of 'ora.gipcd' on 'racdb02' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'racdb02'
CRS-2676: Start of 'ora.cssdmonitor' on 'racdb02' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'racdb02'
CRS-2672: Attempting to start 'ora.diskmon' on 'racdb02'
CRS-2676: Start of 'ora.diskmon' on 'racdb02' succeeded
CRS-2676: Start of 'ora.cssd' on 'racdb02' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'racdb02'
CRS-2672: Attempting to start 'ora.ctssd' on 'racdb02'
CRS-2676: Start of 'ora.ctssd' on 'racdb02' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'racdb02'
CRS-2676: Start of 'ora.crf' on 'racdb02' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'racdb02'
CRS-2676: Start of 'ora.crsd' on 'racdb02' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'racdb02' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'racdb02'
CRS-2676: Start of 'ora.asm' on 'racdb02' succeeded
CRS-6017: Processing resource auto-start for servers: racdb02
CRS-2672: Attempting to start 'ora.net1.network' on 'racdb02'
CRS-2672: Attempting to start 'ora.chad' on 'racdb02'
CRS-2672: Attempting to start 'ora.ASMNET1LSNR_ASM.lsnr' on 'racdb02'
CRS-2676: Start of 'ora.net1.network' on 'racdb02' succeeded
CRS-2672: Attempting to start 'ora.ons' on 'racdb02'
CRS-2676: Start of 'ora.chad' on 'racdb02' succeeded
CRS-2676: Start of 'ora.ASMNET1LSNR_ASM.lsnr' on 'racdb02' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'racdb02'
CRS-2676: Start of 'ora.ons' on 'racdb02' succeeded
CRS-2676: Start of 'ora.asm' on 'racdb02' succeeded
CRS-6016: Resource auto-start has completed for server racdb02
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2017/03/04 20:25:16 CLSRSC-343: Successfully started Oracle Clusterware stack
2017/03/04 20:25:16 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 12c Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
2017/03/04 20:25:34 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2017/03/04 20:26:35 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
root@racdb02::/root

CLICK OK

 

Done.

root@racdb02::/media/sf_software/Software
$ . oraenv
ORACLE_SID = [root] ? +ASM2
The Oracle base has been set to /u01/app/grid12cR2
root@racdb02:+ASM2:/media/sf_software/Software
$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
 
$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
               ONLINE  ONLINE       racdb01                  STABLE
               ONLINE  ONLINE       racdb02                  STABLE
ora.DATA.dg
               ONLINE  ONLINE       racdb01                  STABLE
               ONLINE  ONLINE       racdb02                  STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       racdb01                  STABLE
               ONLINE  ONLINE       racdb02                  STABLE
ora.chad
               ONLINE  ONLINE       racdb01                  STABLE
               ONLINE  ONLINE       racdb02                  STABLE
ora.net1.network
               ONLINE  ONLINE       racdb01                  STABLE
               ONLINE  ONLINE       racdb02                  STABLE
ora.ons
               ONLINE  ONLINE       racdb01                  STABLE
               ONLINE  ONLINE       racdb02                  STABLE
ora.proxy_advm
               OFFLINE OFFLINE      racdb01                  STABLE
               OFFLINE OFFLINE      racdb02                  STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       racdb01                  STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       racdb01                  169.254.118.32 10.0.
                                                             0.100,STABLE
ora.asm
      1        ONLINE  ONLINE       racdb01                  Started,STABLE
      2        ONLINE  ONLINE       racdb02                  Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.cvu
      1        ONLINE  ONLINE       racdb01                  STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       racdb01                  Open,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       racdb01                  STABLE
ora.racdb01.vip
      1        ONLINE  ONLINE       racdb01                  STABLE
ora.racdb02.vip
      1        ONLINE  ONLINE       racdb02                  STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       racdb01                  STABLE
--------------------------------------------------------------------------------
root@racdb02:+ASM2:/media/sf_software/Software