Friday 8 April 2016

Grid Install on Windows for Oracle Restart

1. Oracle software owner account creation

 Create a user oracle and assign Administrator group

Check that you can connect to Windows server with the oracle user account.

2.  Oracle software file system creation

On my server I have assigned letter H to new file system with following commands run with Administrator:

C:\Users\Administrator> diskpart

Microsoft DiskPart version 6.2.9200

Copyright (C) 1999-2012 Microsoft Corporation.
On computer: W12DC02

DISKPART> list disk

  Disk ###  Status         Size     Free     Dyn  Gpt
  --------  -------------  -------  -------  ---  ---
  Disk 0    Online           25 GB      0 B
  Disk 1    Online           25 GB    25 GB
  Disk 2    Online           10 GB    10 GB
  Disk 3    Online           10 GB    10 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>


DISKPART> list volume

  Volume ###  Ltr  Label        Fs     Type        Size     Status     Info
  ----------  ---  -----------  -----  ----------  -------  ---------  --------
  Volume 0     D   VBOXADDITIO  CDFS   CD-ROM        55 MB  Healthy
  Volume 1     E                       CD-ROM          0 B  No Media
  Volume 2         System Rese  NTFS   Partition    350 MB  Healthy    System
  Volume 3     C                NTFS   Partition     24 GB  Healthy    Boot
  Volume 4                      RAW    Partition     24 GB  Healthy

DISKPART> select volume 4

Volume 4 is the selected volume.

DISKPART> format fs=ntfs

  100 percent completed

DiskPart successfully formatted the volume.

DISKPART> assign letter=h

DiskPart successfully assigned the drive letter or mount point.

DISKPART> detail partition

Partition 1
Type  : 07
Hidden: No
Active: No
Offset in Bytes: 2097152

  Volume ###  Ltr  Label        Fs     Type        Size     Status     Info
  ----------  ---  -----------  -----  ----------  -------  ---------  --------
* Volume 4     H                NTFS   Partition     24 GB  Healthy

DISKPART> exit

Leaving DiskPart...
PS C:\Users\Administrator> cmd.exe
Microsoft Windows [Version 6.2.9200]
(c) 2012 Microsoft Corporation. All rights reserved.

C:\Users\Administrator>dir h:
 Volume in drive H has no label.
 Volume Serial Number is E837-1047

 Directory of H:\

File Not Found

C:\Users\Administrator>

ASM storage configuration

Run following commands with Administrator account from a Powershell session:

PS C:\Users\Administrator> diskpart

Microsoft DiskPart version 6.2.9200

Copyright (C) 1999-2012 Microsoft Corporation.
On computer: W12DC02

DISKPART> list disk

  Disk ###  Status         Size     Free     Dyn  Gpt
  --------  -------------  -------  -------  ---  ---
  Disk 0    Online           25 GB      0 B
  Disk 1    Online           25 GB  1024 KB
  Disk 2    Online           10 GB    10 GB
  Disk 3    Online           10 GB    10 GB

DISKPART> select disk 2

Disk 2 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> select disk 3

Disk 3 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> list volume

  Volume ###  Ltr  Label        Fs     Type        Size     Status     Info
  ----------  ---  -----------  -----  ----------  -------  ---------  --------
  Volume 0     D   VBOXADDITIO  CDFS   CD-ROM        55 MB  Healthy
  Volume 1     E                       CD-ROM          0 B  No Media
  Volume 2         System Rese  NTFS   Partition    350 MB  Healthy    System
  Volume 3     C                NTFS   Partition     24 GB  Healthy    Boot
  Volume 4     H                NTFS   Partition     24 GB  Healthy
  Volume 5                      RAW    Partition      9 GB  Healthy
* Volume 6                      RAW    Partition      9 GB  Healthy

DISKPART> exit

Leaving DiskPart...
PS C:\Users\Administrator>

Windows PowerShell
Copyright (C) 2012 Microsoft Corporation. All rights reserved.

PS C:\Users\Administrator> cd F:\winx64_12102_grid\grid\asmtool
PS F:\winx64_12102_grid\grid\asmtool> dir


    Directory: F:\winx64_12102_grid\grid\asmtool


Mode                LastWriteTime     Length Name
----                -------------     ------ ----
-----        11/09/2014     09:56      11776 asmtool.exe
-----        11/09/2014     09:56      25088 asmtoolg.exe
-----        30/04/2012     01:57     608080 msvcp100.dll
-----        30/04/2012     01:57     829264 msvcr100.dll
-----        22/05/2012     11:13     362496 msvcrt.dll
-----        11/09/2014     09:56       4608 oraasmtoolus.msb
-----        02/08/2014     02:46    1755136 oracore12.dll
-----        11/09/2014     10:51     117248 oraimr12.dll
-----        04/08/2014     16:17    1041408 oranls12.dll
-----        04/08/2014     15:53     241664 orasnls12.dll
-----        04/08/2014     15:53     105472 oraunls12.dll
-----        02/08/2014     02:46       9728 orauts.dll


PS F:\winx64_12102_grid\grid\asmtool>
PS F:\winx64_12102_grid\grid\asmtool> .\asmtool -list
NTFS                             \Device\Harddisk0\Partition1              350M
NTFS                             \Device\Harddisk0\Partition2            25248M
NTFS                             \Device\Harddisk1\Partition1            25597M
                                 \Device\Harddisk2\Partition1            10237M
                                 \Device\Harddisk3\Partition1            10237M
PS F:\winx64_12102_grid\grid\asmtool> .\asmtool -add  \Device\Harddisk2\Partition1 ORCLDISK1
PS F:\winx64_12102_grid\grid\asmtool> .\asmtool -add  \Device\Harddisk3\Partition1 ORCLDISK2
PS F:\winx64_12102_grid\grid\asmtool> .\asmtool -list
NTFS                             \Device\Harddisk0\Partition1              350M
NTFS                             \Device\Harddisk0\Partition2            25248M
NTFS                             \Device\Harddisk1\Partition1            25597M
ORCLDISK1                        \Device\Harddisk2\Partition1            10237M
ORCLDISK2                        \Device\Harddisk3\Partition1            10237M
PS F:\winx64_12102_grid\grid\asmtool>

The 2 10 Gb raw disk partitions are now ready to be used by ASM.

3. Verify Oracle Restart host cluvfy

cluvfy stage -pre  hacfg -verbose

4. Software  and ASM disk locations

/u01/app/oraInventory             --> Inventory
/u01/app/1202/grid                --> GRID_HOME     Version 12.1.0.2
/u01/app/oracle/product/11204/ors --> ORACLE_HOME
/u01/app/oracle                   --> ORACLE_BASE   Version 11.2.0.4

ASM Disk protection:
# ls -l  /dev/asm_data_11g_disk1
brw-rw----. 1 oracle oinstall 8, 17 Sep  5 15:41 /dev/asm_data_11g_disk1

5. Install 12c Oracle Grid Infracstructure for a Standalone Server

[oracle@test grid]$ ./runInstaller
  -->  Install and confgure Oracle Grid Infr. for a Standalone Server
  --> Create ASM device : DG DATA
..
[root@test12 app]# /u01/app/1202/grid/root.sh

6. Verify DG
[oracle@test12 ~]$ asmcmd lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576     10236     8712                0            8712              0             N  DATA/


2 comments:

  1. Hi Shilpa,

    Nice explanation, I am unable to create partition in my desktop by following same steps, could you help me ?

    FYI ..,


    Microsoft DiskPart version 6.1.7601
    Copyright (C) 1999-2008 Microsoft Corporation.
    On computer: XXXXXXXXXX

    DISKPART> list disk

    Disk ### Status Size Free Dyn Gpt
    -------- ------------- ------- ------- --- ---
    Disk 0 Online 465 GB 0 B

    DISKPART> select disk 1

    The disk you specified is not valid.

    There is no disk selected.

    DISKPART> select disk 0

    Disk 0 is now the selected disk.

    DISKPART> create partition extended

    Virtual Disk Service error:
    There is not enough usable space for this operation.


    DISKPART>

    ReplyDelete
    Replies
    1. Hi,

      Share the details of the Volume on your system:
      DISKPART> list volume

      Delete