Automatic Storage Management (ASM) Instance Creation

  1. First Add 4 Hard Disk in VMware.
  2. Start Machine.
  3. Then Go to Disk Management.
  4. Right Click on Unallocated Disk list. Then Click on initialize disk.
  5. Right Click on unallocated disk 1. Then Click on New Partition Then Next. Select option External Partition Button then Next --> Next --> Finish(Note:Repeat Step 5 for all Unallocated HDD).
  6. Unallocated HDD is a free space and color is Green.
  7. Right click on 1st HDD  Then Click on new logical drive Then Next -> Next --> Next 
  8. Click on do not Assign drive letter or Drive path option button Then Next
  9. Click on do not Format this partition option button Then Next ---> Finish.(Note: Repeat Step 5 for all Healthy HDD)
  10. Then free space HDD is healthy and color is Blue.
  11. Close Computer Management Window And Go to Command prompt.
  12. C:\>Documents And Settings\Administrator>Asmtoolg
  13. Asmtoolg Operation Window open.
  14. Click on Add or change label option. And then Next
  15. Then check status or ASM link name.These status is candidate device or ASM link name not set.
  16. Select All these Device Then Next-->Next-->Finish.
  17. Go to Command prompt.
  18. C:\>Documents And Settings\Administrator>DBCA
  19. Database Configuration Assistant Window open. Then Next
  20. Select Create database option button. Then Next -->Next
  21. Enter Global Database Name and SID = ASM
  22. Then Next -->Next
  23. Enter Password for all Accounts.(ADMIN)
  24. Select Automatic Storage Management (ASM).
  25. Then Next
  26. Error Message Show.
  27. Run this command in command prompt and install CSS.
  28. Then Next.
  29. Set ASM SYS Password-(ADMIN).
  30. Then Next.
  31. Click create new ( Create Diskgroup Window Open ).
  32. Enter Disk group Name.
  33. Select Any Redudency
    • High
    • Normal
    • External
  34. Select Disk path and enter Disk group name and Failgroup.
  35. Then OK. Then Next -->Next -->Next.
  36. Click on check box sample schemas.
  37. Then Next -->Next -->Next --> Finish.
  38. Asm Instance Installation Started.
  39. After the installation password window is open.
  40. Click on password management button.Set SCOTT, HR, OE, SH etc. user Password.
  41. Then ok. --->Click on Exit.
  42. After The Installation
  43. Go to Command prompt.
  44. C:\>Documents And Settings\Administrator>Set Oracle_Sid=+ASM
  45. Sqlplus Sys as sysdba
  46. Desc V$asm_disk.
  47. Select failgroup,name,path from V$asm_disk.
  48. Select failgroup,name,path,total_mb,free_mb from V$asm_disk.
  49. Create Normal Disk group and Failgroup(Add 2 Failgroup (2 way Mirroring)

  50.  Create Diskgroup Data Normal Redundancy   
                            Failgroup A Disk '\\.\ORCLDISKHDD10' Name Disk_A_1   
                            Failgroup A Disk '\\.\ORCLDISKHDD20' Name Disk_A_2  
                            Failgroup B Disk '\\.\ORCLDISKHDD30' Name Disk_B_1  
                            Failgroup B Disk '\\.\ORCLDISKHDD40' Name Disk_B_2;  
  51. Create High Disk group and Failgroup(Add 3 Failgroup (3 way Mirroring)
  52.  Create Diskgroup Fra High Redundancy  
                            Failgroup X Disk '\\.\ORCLDISKHDD10' Name Disk_X_1  
                            Failgroup X Disk '\\.\ORCLDISKHDD20' Name Disk_X_2  
                            Failgroup Y Disk '\\.\ORCLDISKHDD30' Name Disk_Y_1  
                            Failgroup Y Disk '\\.\ORCLDISKHDD40' Name Disk_Y_2  
                            Failgroup Z Disk '\\.\ORCLDISKHDD50' Name Disk_Z_1  
                            Failgroup Z Disk '\\.\ORCLDISKHDD60' Name Disk_Z_2;  

  53. Create External Disk group and Failgroup(Add only 1 Failgroup (No Mirroring))
  54.  Create Diskgroup Ext External Redundancy  
                           Failgroup EX1 Disk '\\.\ORCLDISKHDD10' Name Disk_X_1  
                           Failgroup EX2 Disk '\\.\ORCLDISKHDD20' Name Disk_X_1;  
  55. Go to non ASM window.
  56. Show parameter db_create_file_dest.
  57. Set normal diskgroup data to db_create_file_dest.
  58. Alter system set db_create_file_dest='+Data' scope=spfile sid='*';
  59. show parameter Db_recovery_file_dest.
  60. Set High diskgroup Fra to Db_recovery_file_dest.
  61. Alter system set Db_recovery_file_dest='+Fra' scope=spfile sid='*';
  62. show parameter Db_recovery_file_dest_size.
  63. Alter system set Db_recovery_file_dest_size=5g scope=spfile sid='*';
  64. Shut immediate
  65. Startup
  66. Show parameter db_create_file_dest. --> Value= +Data
  67. Show parameter Db_recovery_file_dest -->Value= +Fra
  68. Show parameter Db_recovery_file_dest_size -->Value= 5g
  69. Select failgroup,name,path,total_mb,free_mb from V$asm_disk.


Popular posts from this blog

Oracle Architecture - Explained In Detailed - Administration I

Oracle Database SQL - Practise - Question - Scott Schema Examples

Step by Step - How to resolve redo log file corruption using ALTER DATABASE CLEAR UNARCHIVED LOGFILE command