𝗥𝗔𝗖 𝟮 𝗡𝗼𝗱𝗲 𝗦𝗲𝘁𝘂𝗽 𝗮𝗻𝗱 𝗖𝗼𝗻𝗳𝗶𝗴𝘂𝗿𝗮𝘁𝗶𝗼𝗻 𝗼𝗻 𝘄𝗶𝗻𝗱𝗼𝘄𝘀 𝟮𝟬𝟭𝟮 𝘀𝘁𝗲𝗽 𝗯𝘆 𝘀𝘁𝗲𝗽

                                                            [̲̅O][̲̅R][̲̅A][̲̅C][̲̅L][̲̅E] [̲̅R][̲̅A][̲̅C]

Steps1) Node WIN-RAC1 installation and configuration   OS changes 1. Modify hosts file Do modifications in file “C:\windows\system32\drivers\etc\hosts”.   #public 172.22.155.10WIN-RAC1 172.22.155.11 WIN-RAC2   #private 10.0.0.11 WIN-RAC1-priv 10.0.0.12 WIN-RAC2-priv   #virtual 172.22.155.15  WIN-RAC1-vip 172.22.155.16  WIN-RAC2-vip   #SCAN 172.22.155.20  WIN-RAC12-scan

2. Change network settings Click “Start” -> “Control Panel” -> “Network and Sharing Center” -> “Manage network connections”. Rename network interfaces to following names Unidentified network (public) “Local Area Connection” to “public” “Local Area Connection 2” to “private” Network (public)    Configure IP address on each network card NOTE – IPv6 is not supported for Oracle Grid Infrastructure or Oracle RAC on Windows in the first release of Oracle RAC 12C so disable it on each network card. We start in the same window “Network Connections” public IP Address: 172.22.155.10 Subnet: 255.255.255.0 Right click on “public” network to display menu and select “Properties”. Uncheck checkbox “Internet Protocol Version 6(TCP/IPv6)” then select “Internet Protocol Version 4(TCP/IPv4)” And click “Properties” button.

3. Disable Windows Media Sensing for TCP/IP: Backup the Windows registry. Use Registry Editor to view the following key in the registry: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters Add a new key type DWORD: Value Name: DisableDHCPMediaSense Value: 1 Exit the Registry Editor. It requires reboot of machine.

4. Set Manage auditing and security log Run C:\Users\Administrator>secpol.msc to start “Local Security Policy”. Then select “Security Settings”->”Local Policies”- >”User Rights Assignment” and verify policy “Manage auditing and security log” to ensure “Administrators” group is assigned.

5. Turn off firewall During installation of grid and database software firewall must be disabled.  Just run following commands on each node. C:\Users\Administrator>netsh firewall set opmode disable Ok. C:\Users\Administrator>netsh advfirewall set allprofiles state off Ok.

6.Disable SNP features   C:\Users\Administrator>netsh int tcp set global chimney=disabled Ok. C:\Users\Administrator>netsh tcp set global rss=disabled The following command was not found: tcp set global rss=disabled. C:\Users\Administrator>netsh interface tcp show global Querying active state... TCP Global Parameters ---------------------------------------------- Receive-Side Scaling State : enabled Chimney Offload State : disabled Receive Window Auto-Tuning Level : normal Add-On Congestion Control Provider : ctcp ECN Capability : disabled RFC 1323 Timestamps : disabled

Steps 2) Node WIN-RAC2 installation and configuration   NOTE : Please follow all the above step to create NODE2 in this Post here I have showed only one node step.

Steps 3) Create ASM DISK using SAN disks through multipath in       Oracle DB Servers. External – VDATA, DATA1 and FRA.

Steps 4) Grid software installation Unzip grid software then run setup.exe to start grid software installation. unzip winx64_12c_grid_1of2.zip unzip winx64_12c_grid_2of2.zip   ☑ Install Oracle Grid Services and configure cluster.   1. Select “Install and Configure Oracle Grid Infrastructure for a Cluster” And click “Next” button.   2. Select  “Advanced installation” and click “Next” button   3. Enter SCAN Name “WIN-RAC12-scan” then click “Add” button to add second node WIN-RAC2   4. Enter public and virtual host name for second node and click “OK” Button     Validations are started for memory, network interfaces etc. Ensure 172.22.155.0 subnet is public and 10.0.0.0 subnet is private and click “OK” button. You should be back on main screen so click “Next” button.   5. select "use Standard ASM for storage"     6. Enter disk group name as showed below and press stamp disk option   7. Select Add or change label and next.   8. Select the disk label and finish.       9. Enter the disk group name ( VDATA) for creating OCR and voting disk, DATA1 for data & FRA. Select external radio button. 10. Enter the asm user password and next. 11. Select second radio button and next 12. Select buit-in account(Administrator) and then continue next 13. Enter ORACLE_BASE and software location for grid software.   14. click " ignore all" and next     15. Install

Step 5) Install Oracle RAC database software only (12cR1).   1. 2. Install database software only       3. Oracle Real Application Clusters database Installation   4. Select the available node in the cluster: 2 hosts - WIN-RAC1, WIN-RAC2.   5. Select Database Edition – Enterprise Edition. 6. Specify installation location       7. Privileged operating system groups.   8. Prerequisite Checks.   9. Select ignore all   10. Install the Software

Step 6) Create a RAC database (12cR1).   1. DBCA to create a database   2. Select Advanced mode 3. Configuration Type : Admin-Managed   4. Database name - RACDB   5. Select 2 hosts - WIN-RAC1, WIN-RAC2.   6. Storage Locations : Data files in +DATA and Recovery Area in +FRA     7. Set  Memory Size (SGA & PGA)   8. Select create database.   9.  Finish creation.

Next, Verify the RAC installation.  $ crsctl stat res –t $ crsctl check crs