By Mouhamadou Diaw
Oracle Grid Infrastucture can be installed on Windows platform. The steps are the same that on other platforms. In this blog we are going to install Oracle GI 18c on Windows 2016.I have two disks on my server
Disk 0 : for the system
Disk 1 : for the ASM
I am using a VirtualBox virtual machine.
We suppose that the grid infrastructure sofware is already downloaded and decompressed in the grid home.
Like on other platforms, we have to configure the ASM disk. In the documentation we can read :
The only partitions that OUI displays for Windows systems are logical drives that are on disks and have been marked (or stamped) with asmtoolg or by Oracle Automatic Storage Management (Oracle ASM) Filter Driver.
So Disk1 should not be formatted and should not be assigned to a letter.
Then the first step is to create logical partition using Windows diskpart utility.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
Microsoft Windows [Version 10.0.14393] (c) 2016 Microsoft Corporation. All rights reserved. C:\Users\Administrator>diskpart Microsoft DiskPart version 10.0.14393.0 Copyright (C) 1999-2013 Microsoft Corporation. On computer: RACWIN2 DISKPART> list disk Disk ### Status Size Free Dyn Gpt -------- ------------- ------- ------- --- --- Disk 0 Online 60 GB 0 B Disk 1 Online 20 GB 20 GB 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 DiskPart succeeded in creating the specified partition. DISKPART> |
We can then list existing partition for Disk 1
1
2
3
4
5
6
7
8
|
DISKPART> list partition Partition ### Type Size Offset ------------- ---------------- ------- ------- Partition 0 Extended 19 GB 1024 KB * Partition 1 Logical 19 GB 2048 KB DISKPART> |
Once the logical partition created we can launch the asmtool or asmtoolg utility. This utility comes with the grid software
1
|
c:\app\grid\18000\bin>asmtoolg.exe |
The first time we executed the asmtoolg.exe command, we get following error
According to this Oracle support note Windows: asmtoolg: MSVCR120.dll is missing from your computer (Doc ID 2251869.1), we have to download and install Visual C++ 2013 Redistributable Package.
Once done we launch again the asmtoolg utility
Clicking on next, we can choose the disk we want to stamp for ASM
Click on Next
Click on Next
And Click to Finish. We can then list the disks marked for ASM with the asmtool utility.
1
2
3
4
5
6
7
|
C:\Users\Administrator> cd c:\app\18000\grid\bin c:\app\18000\grid\bin>asmtool.exe -list NTFS \Device\Harddisk0\Partition1 500M NTFS \Device\Harddisk0\Partition2 60938M ORCLDISKDATA0 \Device\Harddisk1\Partition1 20477M c:\app\18000\grid\bin> |
Now it’s time to launch the gridSetup executable
1
|
c:\app\grid\18000>gridSetup.bat |
We decide to ignore the Warning
At the end, we got an error from the cluster verification utility. But it is normal because we ignored some perquisites.
We can verify that the insallation was fine
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
c:\app\18000\grid>crsctl status resource -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE racwin2 STABLE ora.LISTENER.lsnr ONLINE ONLINE racwin2 STABLE ora.asm ONLINE ONLINE racwin2 Started,STABLE ora.ons OFFLINE OFFLINE racwin2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.cssd 1 ONLINE ONLINE racwin2 STABLE ora.evmd 1 ONLINE ONLINE racwin2 STABLE -------------------------------------------------------------------------------- c:\app\18000\grid> |
We can connect to the ASM instance
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
C:\Users\Administrator> set oracle_sid=+ASM C:\Users\Administrator>sqlplus / as sysasm SQL*Plus: Release 18.0.0.0.0 - Production on Sat Apr 27 05:49:38 2019 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. SQL> select name,state from v $asm_diskgroup; NAME STATE ------------------------------ ----------- DATA MOUNTED SQL> |
Conclusion
Once the grid infrastructure configured, we have to install the Oracle database software.