Install Oracle 12C Release 1 RAC (12.1) on Windows 2008

Article presents quick installation of Oracle Enterprise RAC 12.1.0.1 on Windows 2008 using Oracle Virtual Box.

Architecture

w2008_architecture_rac

Software used:

  • Oracle Virtual Box – 64 bit
  • Windows 2012 – 64 bit
  • Oracle Database 12C Release 1(12.1.0.1) – 64 bit for Windows

Binaries 12.1.0.1

winx64_12c_database_1of2.zip - database software
winx64_12c_database_2of2.zip - database software
winx64_12c_grid_1of2.zip - grid software
winx64_12c_grid_2of2.zip - grid software

Two virtual machines are created:

  • rac1
  • rac2
public private vip
rac1 192.168.0.50 192.168.1.60 192.168.0.70
rac2 192.168.0.51 192.168.1.61 192.168.0.71

with single client access name (SCAN) address

public
rac-scan 192.168.0.20
192.168.0.21
192.168.0.22

Each virtual machines consist of:

  • 64G local disk (dynamic space allocation)
  • 4G ram memory
  • 3 network cards (2 dedicated just for RAC + 1 for Internet connection)

NOTE to save space rac2 is linked clone of rac1

Shared storage visible on each node:

  • 20G shared virtual disk (fixed size)

Virtual Machine configuration

1. Start virtual box manager and click “New” button.

2. Click “Hide Description” to see more options. Enter virtual machine name “w2008_121_rac1”, select type “Microsoft Windows”, version “Windows 2008(64bit)”, set memory to 4096M. Click “Create” button to allocate storage for this machine.

w2008_121_rac1_vm1 w2008_121_rac1_vm2

3. Enter storage attributes: name, size 64G, type VDI, dynamically allocated then click “Create” button.

w2008_121_rac1_vm3

4. Virtual machine is ready click “Settings” to change some details.

w2008_121_rac1_vm3a

5. Select “System” option, tab “Processor” in case you want to assign more processor to your virtual machine. I have 4 core machines so I assigned to rac1 2 CPU.

w2008_121_rac1_vm4

6. Select “Option” option, “Video” tab and assign 256MB of memory and enable 3D acceleration to improve graphics in your virtual machine.

w2008_121_rac1_vm5

7. Select “Network” option and select “Internal Network” for Adapter 1 and 2 and “NAT” for Adapter 3. Adapter 1 will be used as public RAC interface, Adapter 2 as private and Adapter 3 to connect to internet(it’s optional but I use it to have access to internet from my virtual machine).

w2008_121_rac1_vm6 w2008_121_rac1_vm7 w2008_121_rac1_vm8

8. On “Storage” tab assign iso file to “CD/DVD Drive” to install Windows 2008 64 bit. Once it’s done click “OK” button.

w2008_121_rac1_vm9

9. Virtual box is ready to install Windows 2008 so click “Start” button.

w2008_121_rac1_vm10

Install and configuration of Windows 2008

Install Windows 2008 Standard Full edition.

w2008_121_rac1_vm11

w2008_121_rac1_vm12

When installation is completed apply latest updates for Windows 2008. To speed up this process I suggest to download service pack 2 for Windows 2008.

w2008_121_rac1_vm13

OS changes

1. Modify hosts file

Do modifications in file  “C:\windows\system32\drivers\etc\hosts”.

127.0.0.1       localhost
::1             localhost

#public
192.168.0.50 rac1
192.168.0.51 rac2

#private
192.168.1.60 rac1-priv
192.168.1.61 rac2-priv

#virtual
192.168.0.70 rac1-vip
192.168.0.71 rac2-vip

#scan
192.168.0.20 rac-scan
192.168.0.21 rac-scan
192.168.0.22 rac-scan

3. Change network settings

Click “Start” -> “Control Panel” -> “Network and Sharing Center” -> “Manage network connections”.

w2008_121_rac1_network00

w2008_121_rac1_network0

Rename network interfaces to following names

Unidentified network (public)

  • “Local Area Connection” to “public”
  • “Local Area Connection 2” to “private”

Network (public)

  • “Local Area Connection 3” to “internet”

Just right click on each network card you should see menu and option “rename”. Once it’s done you should see following

w2008_121_rac1_network1

In the same window click “Advanced” -> “Advanced Settings …” to change order binding. In “Connections:” area change connections order to following – use green arrows on right side

  • public
  • private
  • internet

w2008_121_rac1_network4

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”

w2008_121_rac1_network1

public

  • IP Address: 192.168.0.50
  • 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.

w2008_121_rac1_network5

apply ip address for “public” interface and click “Advanced” button

w2008_121_rac1_network2

on DNS tab uncheck checkbox “Register this connection’s addresses in DNS” then click “OK” buttons in each window to apply all the changes.

w2008_121_rac1_network6

private:

  • IP Address: 192.168.1.60
  • Subnet: 255.255.255.0

Repeat the same steps for “private”. The only difference is ip address.

w2008_121_rac1_network3

Verify network connections with ipconfig and ping

ipconfig command should show NIC in proper order:

  • public
  • private
  • internet
C:\Users\Administrator>ipconfig

Windows IP Configuration

Ethernet adapter public:

   Connection-specific DNS Suffix  . :
   IPv4 Address. . . . . . . . . . . : 192.168.0.50
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . :

Ethernet adapter private:

   Connection-specific DNS Suffix  . :
   IPv4 Address. . . . . . . . . . . : 192.168.1.60
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . :

Ethernet adapter internet:

   Connection-specific DNS Suffix  . :
   Link-local IPv6 Address . . . . . : fe80::94b:3a59:fdd8:2089%12
   IPv4 Address. . . . . . . . . . . : 10.0.4.15
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . : 10.0.4.2

Tunnel adapter Local Area Connection* 8:

   Media State . . . . . . . . . . . : Media disconnected
   Connection-specific DNS Suffix  . :

Tunnel adapter Local Area Connection* 12:

   Media State . . . . . . . . . . . : Media disconnected
   Connection-specific DNS Suffix  . :

Tunnel adapter Local Area Connection* 13:

   Media State . . . . . . . . . . . : Media disconnected
   Connection-specific DNS Suffix  . :

check with ping command response from NIC

C:\Users\Administrator>ping rac1 -n 1

Pinging rac1 [192.168.0.50] with 32 bytes of data:
Reply from 192.168.0.50: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.0.50:
    Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\Administrator>ping rac1-priv -n 1

Pinging rac1-priv [192.168.1.60] with 32 bytes of data:
Reply from 192.168.1.60: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.1.60:
    Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

4. 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 but don’t do it right now.

5. Change host name

Open the “System Properties” dialog (Start-> Control Panel -> System -> Change Settings)

w2008_121_rac1_network7

click “Change” button

w2008_121_rac1_network8

Enter computer name: rac1 and click “OK” button. It will ask to reboot machine.

w2008_121_rac1_network9

After reboot verify new – hostname

C:\Users\Administrator>hostname
rac1

and media sense is disabled – netsh interface ipv4 show global

C:\Users\Administrator>netsh interface ipv4 show global
Querying active state...

General Global Parameters
---------------------------------------------
Default Hop Limit                   : 128 hops
Neighbor Cache Limit                : 256 entries per interface
Route Cache Limit                   : 128 entries per compartment
Reassembly Limit                    : 33543424 bytes
ICMP Redirects                      : enabled
Source Routing Behavior             : dontforward
Task Offload                        : enabled
Dhcp Media Sense                    : disabled
Media Sense Logging                 : enabled
MLD Level                           : all
MLD Version                         : version3
Multicast Forwarding                : disabled
Group Forwarded Fragments           : disabled
Randomize Identifiers               : enabled
Address Mask Reply                  : disabled

Current Global Statistics
---------------------------------------------
Number of Compartments              : 1
Number of NL clients                : 7
Number of FL providers              : 4

Shared storage

1. To add shared storage virtual machine rac1 must be down. Once it’s down go to “Settings” select “Storage” then click on icon with plus on disk.

w2008_121_rac1_shared1

2. Click on “Create new disk” button.

w2008_121_rac1_shared2

3. Default option “VDI” is fine click “Next” button.

w2008_121_rac1_shared3

4. Select “Fixed size” then click “Next” button.

w2008_121_rac1_shared4

5. Enter storage name “Shared” and set size to 20G then click “Create” button.

w2008_121_rac1_shared5

6. Once created you should see new disk attached to our virtual machine. Click “OK” button.

w2008_121_rac1_shared6

7. From main menu you need to select File->Virtual Media Manager to change “Shared” disk attribute. Select “Shared.vdi” and click “Modify” button.

w2008_121_rac1_shared7

8. Select “Sharable” and click “OK” button. It will prepare this storage to be shareable between RAC instances. Please start virtual machine to create partitions on shared storage.

w2008_121_rac1_shared8

Host configuration

It’s time to add shared device to rac1 node using diskpart.exe tool.

1. List available disks on computer. There are two disks. “Disk 1” is dedicated for ASM partitions.

C:\Users\Administrator>diskpart

Microsoft DiskPart version 6.0.6002
Copyright (C) 1999-2007 Microsoft Corporation.
On computer: RAC1

DISKPART> list disk

  Disk ###  Status      Size     Free     Dyn  Gpt
  --------  ----------  -------  -------  ---  ---
  Disk 0    Online        64 GB    32 GB
  Disk 1    Online        20 GB    20 GB

2. Enable automount option. It is required for ASM installation.

DISKPART> automount enable

Automatic mounting of new volumes enabled.

3. Select “Disk 1” and create extended and logical 2 partitions each 10G size

DISKPART> select disk 1

Disk 1 is now the selected disk.

DISKPART> create partition extended

DiskPart succeeded in creating the specified partition.

DISKPART> create partition logical size=10240

DiskPart succeeded in creating the specified partition.

DISKPART> create partition logical

DiskPart succeeded in creating the specified partition.

4. Verify partitions

DISKPART> list partition

  Partition ###  Type              Size     Offset
  -------------  ----------------  -------  -------
  Partition 0    Extended            20 GB  1024 KB
  Partition 1    Logical             10 GB  2048 KB
* Partition 2    Logical             10 GB    10 GB

5. Set “Elevate without prompting” for security

Run

C:\Users\Administrator>secpol.msc

to start “Local Security Policy”. Then select “Security Settings”->”Local Policies”->”Security Options” and change policy “User Account Control: Behavior of the evaluation prompt for administrators in Admin Approval Mode” to value “Elevate without prompting”.

w2008_121_rac1_sec1

6. 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..

w2008_121_rac1_sec2

7. 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.

8. 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

9. Change environment variables

create directory c:\temp

C:\Users\Administrator>mkdir c:\temp

Click “Start”->”Control Panel”->”System”. Then click “Advanced system settings” to see System properties.

w2008_121_rac1_env1

click “Environment variables” and modify “User variables for Administrator” TEMP and TMP

w2008_121_rac1_env2

w2008_121_rac1_env3

w2008_121_rac1_env4

once it’s done verify it

C:\Users\Administrator>set temp
TEMP=c:\temp

C:\Users\Administrator>set tmp
TMP=c:\temp

10. Unpack grid software

unzip winx64_12c_grid_1of2.zip
unzip winx64_12c_grid_2of2.zip

11. Verify host is ready to install oracle grid software

runcluvfy.bat stage -pre crsinst -n rac1 -verbose

Problems I have noticed were memory and domain. Both can be ignored. From 4GB 256MB was consumed by graphic and my Window Server is not registered in domain.

Check: Total memory
  Node Name  Available              Required           Status
  ---------- ---------------------- ------------------ ----------
  rac1       3.9987GB (4192928.0KB) 4GB (4194304.0KB)  failed
Result: Total memory check failed

Checking if current user is a domain user...
Check: If user "Administrator" is a domain user

ERROR:
PRVF-10000 : Unable to check if user "RAC1\Administrator" is 
a domain user: "PRCZ-1091 : Failed to verify that user 
name "RAC1\Administrator" is a valid Windows user"

Shutdown rac1 machine to clone it.

Cloning machine

New machine rac2 is cloned from machine rac1 using “linked clone” method. It allows to speed up process of cloning. It’s especially useful for development environments.

  • Full clone: In this mode all depending disk images are copied to the new VM folder. The clone can fully operate without the source VM.
  • Linked clone: In this mode new differencing disk images are created where the parent disk images are the source disk images. If you selected the current state of the source VM as clone point, a new snapshot will be created implicitly.

1. Before we create “linked clone” we need to remove shared storage. On Storage tab select Shared.vdi then click “Remove Attachment”.

w2008_121_rac1_clone1

2. Now you should see w2008_121_rac1 without Shared storage.

w2008_121_rac1_clone2

3. In menu of VirtualBox select “Machine”-“Clone” option. Enter name for new machine w2008_121_rac2. Check checkbox “Reinitialize the MAC address of all network cards” and click “Next” button.

w2008_121_rac1_clone3

4. Select “Linked clone” option and click “Clone” button.

w2008_121_rac1_clone4

5. You should see new machine w2008_121_rac2

w2008_121_rac1_clone5

6. It’s time to attach Shared.vdi disk to both machine. Select first machine w2008_rac121_rac1 then click “Storage”. Select “Controller:SATA” and click last button “Add Hard Disk”.

w2008_121_rac1_clone6

7. Click “Choose existing disk”. You should see standard window to select a file. Select “Shared.vdi” to attach it to machine.

w2008_121_rac1_clone7

8. Once it’s done shared disk should be visible by machine w2008_121_rac1. Click “OK” button to save your configuration.

w2008_121_rac1_clone8

9. You need to repeat the same steps 6,7 to attach shared disk to machine w2008_121_rac2. Don’t be surprised that both machines are using the same disk “w2008_121_rac1.vdi”. New machine w2008_121_rac2 is linked clone.

w2008_121_rac1_clone9

Network settings for second machine

Start second linked machine w2008_121_rac2 and set new static ip address for eth0 and eth1.

  • 192.168.0.51/255.255.255.0 for eth0 (public)
  • 192.168.1.61/255.255.255.0 for eth1 (private)

and change host name to

  • rac2

1. Click “Start”->”Network and Sharing Center”. Then click “Manage network connections”.

w2008_121_rac2_network4

Right click on “public” and “private” network to display menu and select “Properties”. Then select “Internet Protocol Version 4(TCP/IPv4)” and click “Properties” button and change ip address for each network card.

w2008_121_rac2_network5 w2008_121_rac2_network6 w2008_121_rac2_network7

2. Change hostname to rac2. Click “Start”->”Control Panel”->”System”->”Change settings”.

w2008_121_rac2_network1

Click “Change” button

w2008_121_rac2_network2

Enter computer name rac2 and click “OK” button. Once it’s done you will be asked to restart computer.

w2008_121_rac2_network3

Reboot machine rac2 and start rac1 machine.

Verify network between nodes

It’s good time to run verify network on each node: rac1 and rac2

hostname
ping rac1 -n 1
ping rac2 -n 1
ping rac1-priv -n 1
ping rac2-priv -n 1

test on rac1

C:\Users\Administrator>hostname
rac1

C:\Users\Administrator>ping rac1 -n 1

Pinging rac1 [192.168.0.50] with 32 bytes of data:
Reply from 192.168.0.50: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.0.50:
    Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\Administrator>ping rac2 -n 1

Pinging rac2 [192.168.0.51] with 32 bytes of data:
Reply from 192.168.0.51: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.0.51:
    Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\Administrator>ping rac1-priv -n 1

Pinging rac1-priv [192.168.1.60] with 32 bytes of data:
Reply from 192.168.1.60: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.1.60:
    Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\Administrator>ping rac2-priv -n 1

Pinging rac2-priv [192.168.1.61] with 32 bytes of data:
Reply from 192.168.1.61: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.1.61:
    Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

test on rac2

C:\Users\Administrator>hostname
rac2

C:\Users\Administrator>ping rac1 -n 1

Pinging rac1 [192.168.0.50] with 32 bytes of data:
Reply from 192.168.0.50: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.0.50:
    Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\Administrator>ping rac2 -n 1

Pinging rac2 [192.168.0.51] with 32 bytes of data:
Reply from 192.168.0.51: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.0.51:
    Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\Administrator>ping rac1-priv -n 1

Pinging rac1-priv [192.168.1.60] with 32 bytes of data:
Reply from 192.168.1.60: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.1.60:
    Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Users\Administrator>ping rac2-priv -n 1

Pinging rac2-priv [192.168.1.61] with 32 bytes of data:
Reply from 192.168.1.61: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.1.61:
    Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms

Verify hosts rac1,rac2 before upgrade. Problems with memory and domain can be ignored.

runcluvfy.bat stage -pre crsinst -n rac1,rac2 -verbose

c:\install\grid>runcluvfy.bat stage -pre crsinst -n rac1,rac2 -verbose

Check: Total memory
  Node Name  Available              Required           Status
  ---------- ---------------------- ------------------ ----------
  rac2       3.9987GB (4192928.0KB) 4GB (4194304.0KB)  failed
  rac1       3.9987GB (4192928.0KB) 4GB (4194304.0KB)  failed
Result: Total memory check failed

Checking if current user is a domain user...
Check: If user "Administrator" is a domain user

ERROR:
PRVF-10000 : Unable to check if user "RAC1\Administrator" 
is a domain user: "PRCZ-1091 : Failed to verify that user name
 "RAC1\Administrator" is a valid Windows user"

Pre-check for cluster services setup 
was unsuccessful on all the nodes.

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

1. Select “Skip software updates” and click “Next” button.

w2008_121_rac1_grid1

2. Select “Install and Configure Oracle Grid Infrastructure for a Cluster” and click “Next” button.

w2008_121_rac1_grid2

3. Accept default “Typical installation” and click “Next” button

w2008_121_rac1_grid3

4. Enter SCAN Name “rac-scan” then click “Add” button to add second node rac2

w2008_121_rac1_grid4

5. Enter public and virtual host name for second node and click “OK” button

w2008_121_rac1_grid5

6.Click on “Identify network interfaces” button

w2008_121_rac1_grid6

7. Ensure 192.168.0.0 subnet is public and 192.168.1.0 subnet is private and click “OK” button. You should be back on main screen so click “Next” button.

w2008_121_rac1_grid7

8. Validations are started for memory, network interfaces etc.

w2008_121_rac1_grid8

9. On the screen you can enter or accept default ORACLE_BASE and software location for grid software. You need to enter password for SYSASM. Once it’s done click “Next” button.

w2008_121_rac1_grid9

10. Click “Stamp disk” to add devices for ASM grid software.

w2008_121_rac1_grid10

11. Graphical interface for asmtool is started to stamp disks for ASM grid software. Click “Next” button.

w2008_121_rac1_grid11

12. You should see two devices which are candidate for ASM disks. Both devices where created using diskpart.exe as logical partitions. Accept default prefix “DATA” and click “Next” button.

w2008_121_rac1_grid12

13. Just click “Next” button then “Finish” button to return to main screen.

w2008_121_rac1_grid13 w2008_121_rac1_grid14

14. Now stamped devices should be visible. Change redundancy to “External” and select first devices “\\ORCLDISKDATA0” which will be assigned to diskgroup DATA. Then click “Next” button.

w2008_121_rac1_grid15

15. Additional check are conducted

w2008_121_rac1_grid16 w2008_121_rac1_grid17

16. You should see 2 problems. Check checkbox “Ignore All” and click “Next” button.

  • Physical Memory – grid requires 4GB so i allocated 4GB. However part of it (256MB) is consumed by VirtualBox graphical card. You can ignore this problem.
  • Administrator is not domain user – my installation is without domain that’s why we have this error. You can safely ignore it.

w2008_121_rac1_grid18

17. Click “Yes” button to continue with installation.

w2008_121_rac1_grid19

18. Summary window appears. Here you can see all your selections. It’s last moment to make changes. if you are happy with your choices click “Install” button.

w2008_121_rac1_grid20

19. Installation starts …

w2008_121_rac1_grid21 w2008_121_rac1_grid22

20. Once it’s done click “Close” button. Grid software is successfully installed.

w2008_121_rac1_grid23

21. Verify grid software installation

C:\Users\Administrator>srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac1,rac2

C:\Users\Administrator>srvctl status asm
ASM is running on rac1,rac2

ASM configuration assistant

So far we have created only one ASM group DATA. I want to show you how quickly you can add extra group to ASM instance.

Please start ASMCA.

ASMCA – ASM configuration assistant is part of grid software so run it from directory where grid software is installed

c:\app\12.1.0\grid\BIN>asmca

1. ASMCA started click “Disk Groups” tab.

w2008_121_rac1_asm1

2. Click “Create” button to add new ASM diskgroup.

w2008_121_rac1_asm2

3. Enter group name BACKUP, check checkbox for “\\ORCLDISKDATA1″ device, select redundancy “External(None)” and click “OK” button.

w2008_121_rac1_asm3

4. You should see following screen. Click “OK”.

w2008_121_rac1_asm4

5. Now you should see we have two ASM groups “BACKUP” and “DATA”. Click “Exit” button.

w2008_121_rac1_asm5

Now you can verify in sqlplus you have 2 ASM groups.

c:\app\12.1.0\grid\BIN>sqlplus

SQL*Plus: Release 12.1.0.1.0 Production on Sun Jul 28 07:28:31 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Enter user-name: / as sysasm

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit 
Production With the Real Application Clusters 
and Automatic Storage Management options

SQL> select name from v$asm_diskgroup;

NAME
------------------------------
BACKUP
DATA

Database software installation

Unzip database software then run setup.exe to start database software installation.

unzip winx64_12c_database_1of2.zip
unzip winx64_12c_database_2of2.zip

1. Uncheck checkbox “I wish to receive security updates via My Oracle Support” and click “Next” button.

w2008_121_rac1_db1

2. Ignore this message and click “Yes”.

w2008_121_rac1_db2

3. Select “Skip software updates” and click “Next” button.

w2008_121_rac1_db3

4. Select “Create and configure a database” and click “Next” button.

w2008_121_rac1_db4

5. Select “Server Class” and click “Next” button.

w2008_121_rac1_db5

6. Select “Oracle Real Application Clusters database installation” then click “Next” button.

w2008_121_rac1_db6

7. Accept default policy “Admin managed” then click “Next” button.

w2008_121_rac1_db7

8. Make sure both nodes are selected, then click the “Next” button.

w2008_121_rac1_db8

9. Accept default “Typical install” and click “Next” button.

w2008_121_rac1_db9

10. Decide about credential used for database software. I selected “Use Windows Built-in Account” then click “Next” button.

w2008_121_rac1_db10

11. Ignore warning message. Just click “Yes” button.

w2008_121_rac1_db11

12. There are many options for installation here:

  • Oracle base – directory for ORACLE_BASE accept default
  • Software location – directory for ORACLE_HOME accept default
  • Storage type – select “Oracle Automatic Storage Management”
  • Database file location – select diskgroup DATA
  • Database edition – accept default “Enterprise Edition” or select other eg. “Standard Edition”
  • Global database name – your database global name, in my case it’s ORA12C
  • Administrator password – password for user SYS
  • Create as Container database – check checkbox to create database ORA12C as container database and enter pluggable database name in my case PORA12C1

Then click “Next button to continue

w2008_121_rac1_db12

13. Many checks are started to verify if your hosts are ready to install database software like: remote access to directories, OS parameters, settings etc.

w2008_121_rac1_db13 w2008_121_rac1_db14

14. On summary screen you can see all selected options. It’s the last time to make changes. If you are happy with selections click “Install” button.

w2008_121_rac1_db15

15. It will take some time to install software so be patient.

w2008_121_rac1_db16

16. In the end of installation DBCA(database configuration assistant) is started to create your rac database.

w2008_121_rac1_db17

17. Summary window for our new rac database ORA12C. Just click “OK” button. it’s worth to change passwords for our important users like SYS, SYSTEM etc “Password Management”.

w2008_121_rac1_db18

18. Installation of database software and new database ORA12C is completed. Click “Close” button. Run extra script <Oracle Home>\bin\selecthome.bat on each remote node(rac2) to active extra products.

w2008_121_rac1_db19

Verify RAC installation

C:\Users\Administrator>srvctl config database -d ORA12C
Database unique name: ORA12C
Database name: ORA12C
Oracle home: C:\app\Administrator\product\12.1.0\dbhome_1
Oracle user: nt authority\system
Spfile: +DATA/ORA12C/spfileORA12C.ora
Password file: +DATA/ORA12C/orapwora12c
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ORA12C
Database instances: ORA12C1,ORA12C2
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
Database is administrator managed

C:\Users\Administrator>srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac1,rac2

C:\Users\Administrator>srvctl status asm
ASM is running on rac1,rac2

C:\Users\Administrator>srvctl status database -d ORA12C
Instance ORA12C1 is running on node rac1
Instance ORA12C2 is running on node rac2

c:\install\grid>srvctl status nodeapps
VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
VIP rac2-vip is enabled
VIP rac2-vip is running on node: rac2
Network is enabled
Network is running on node: rac1
Network is running on node: rac2
ONS is enabled
ONS daemon is running on node: rac1
ONS daemon is running on node: rac2

Status of your database can be visible in OEM https://rac1:5500/em

w2008_121_rac1_express1 w2008_121_rac1_express2

Have a fun 🙂

Tomasz

4 thoughts on “Install Oracle 12C Release 1 RAC (12.1) on Windows 2008

  1. Keep getting an error when installing saying file not found for crsconfig_params
    but when I look in the specified path there it is

  2. got the same crsconfig_params error. Erase everything, redownload the package and make sure you check the cksum values match vs what is posted on Oracle website and then copy and unzip the install package on the node where you want to stall install from. I was able to get past this error.

  3. Pingback: Install Oracle 12c on Windows env. - TechBoom

Leave a Reply

Your email address will not be published. Required fields are marked *