Installing Grid and configuring ASM on Windows

Download the grid 12c setup from MYORACLESUPPORT and unzip the setup.

Double click the setup.exe and initiate the installation process.

Screenshot (65).png

Select the appropriate option for the installation of your desire. Click next.

Here i will be installing the software only and will be configuring the Grid latter.

Screenshot (67).png

Select the appropriate installation option.

I will be installing Standalone software for GRID.

Screenshot (68).png

Select the desired language. Click next.

Screenshot (69).png

Select the location for installing the Oracle base and software. Click Next

Screenshot (70).png

Once done. The installer will automatically carry out a pre-requisite check.

Screenshot (71).png

If all the required packages are installed, there wont be any requirement to fixup. Oracle provides an option to fixup things automatically by using the FIX & CHECK AGAIN option.

There are some requirements which can be ignored, like I did below.

Screenshot (72).png

Once the pre-requisite check is done, a summary page gets displayed. Check the summary and click INSTALL.

Screenshot (73).png

The Installation process starts.

Screenshot (74).png

Once the installation gets completed successfully, there will be a requirement of running perl scripts. There are two types of scripts depending on the type of Installation done.

For Standalone grid copy the below command and run it on the command prompt with administrator privilege.

C:\WINDOWS\system32>C:\app\grid\Omkaar\product\12.1.0\grid\perl\bin\perl -IC:\ap
p\grid\Omkaar\product\12.1.0\grid\perl\lib -IC:\app\grid\Omkaar\product\12.1.0\g
rid\crs\install C:\app\grid\Omkaar\product\12.1.0\grid\crs\install\roothas.pl
Screenshot (76).png

Once the command is run, the Oracle system sets up the GRID infrastructure in the system.

Screenshot (81).png

Now you can see a new Oracle service getting added in the list of services. To view the list of services, Press windows + R or open the RUN prompt and type in services.msc.

OracleOHService gets started upon successfully installation of GRID.

Screenshot (83).png

Now its time to configure an ASM instance of the GRID infrastructure.

Oracle ASM(Automatic Storage Management) is a volume manager and a file system for Oracle database files that supports single-instance Oracle Database and Oracle Real Application Clusters (Oracle RAC) configurations. Oracle ASM is Oracle’s recommended storage management solution that provides an alternative to conventional volume managers, file systems, and raw devices.

Oracle ASM uses disk groups to store data files; an Oracle ASM disk group is a collection of disks that Oracle ASM manages as a unit. Within a disk group, Oracle ASM exposes a file system interface for Oracle database files. The content of files that are stored in a disk group is evenly distributed to eliminate hot spots and to provide uniform performance across the disks.

So lets create partitions to use them as ASM disks.

Screenshot (64).png

Open the command prompt and use DISKPART utility for partitioning of the disk. Use the following command for creating a primary partition.

create partition primary size=2048

Once done creating the partitions. Open the ASM Configuration Assistant from the windows menu.

Following prompt would appear.

Screenshot (84).png

Enter the SYS password , ASMSNMP password and specify the DISK GROUP.

For Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files). Specify EXTERNAL REDUNDANCY if you do not want mirroring by Oracle ASM. For example, you might choose EXTERNAL REDUNDANCY to use storage array protection features.

Various of Redundancy Level

High Redundancy (3 Mirrors)

Oracle ASM does not provide mirroring redundancy and relies on the storage system to provide RAID functionality. Any write error causes a forced dismount of the disk group. All disks must be located to successfully mount the disk group.

Normal Redundancy (2 Mirrors)

Oracle ASM provides two-way mirroring by default, which means that all files are mirrored so that there are two copies of every extent. A loss of one Oracle ASM disk is tolerated. You can optionally choose three-way or unprotected mirroring.

A file specified with HIGH redundancy (three-way mirroring) in a NORMAL redundancy disk group provides additional protection from a bad disk sector, not protection from a disk failure.

External Redundancy (No Mirror)

Oracle ASM provides triple mirroring by default. A loss of two Oracle ASM disks in different failure groups is tolerated. After a disk group is created, you cannot alter the redundancy level of the disk group. To change the redundancy level, you must create another disk group with the appropriate redundancy and then move the files to the new disk group.

Oracle recommends that you create failure groups of equal size to maintain space balance and even distribution of mirror data.

Choose the redundancy for the disk group. Then stamp the disks, so that ORACLE can identify the newly created disks as one of its own.

Now add the disks for stamping them.

Screenshot (85).png

Choose the disks for stamping the with ORACLE label.

Screenshot (86).png

Once the disks are stamped. Enter the Disk Group Name.

Select the failure group depending on the redundancy level chosen.

Finally create the DISK GROUP.

Screenshot (88).png

The ASM instance gets created.

Screenshot (91).png

Once ASM gets created,  you get a message of success.

Screenshot (92).png

With the help of ASM Configuration Assistant we can add, delete disk into a DISK GROUP, we even can create new disk groups as well.

Screenshot (93).png

The ASM instance gets listed in the services list as ORACLEASMSERVICE+ASM.

+ASM is the sid of the ASM instance.

Screenshot (94).png

Related

Installing Oracle Golden Gate

In “Oracle”

ORACLE INSTALLATION ON NON-WINDOWS PLATFORM

Greeting to all of my readers, So Let’s get started with installation of Oracle 11g on Linux/Unix operating system.   After logging onto UNIX system (using any user), the following is done: # su – root (Switches User to root; it will ask for root’s password) # id (It will…

In “Oracle”

Custom DB creation on RAC.

In “Database-Course”

Read more

How to migrate Raspberry Pi 5 OS from micro SD to NVME m.2 SSD

首先我買了Raspberry Pi CM5後來買了Raspberry Pi CM5 I/O board來當個人電腦使用,系統是安裝在256GB SD卡上運行的很好。用久了在開啟較肥的程式像Web Browser或LiberOffice會有慢半拍的反應,而有了升級NVME m.2 SSD念頭。 因為Raspberry Pi 5支援的最快PCIe gen3 x 4就不去考慮快的Gen4 or Gen5 m.2 SSD。找了ADATA出的 LEGEND 710入門級的產品,會利用HMB(Host Memory Buffer)來加速I/O速度,因為是Raspberry Pi OS kernel會認不得而無法正常使用 事先在SD卡的/boot/firmware/cmdline.txt 加入 kernel command line參數如下,然後重開機m.

By Phillips Hsieh

How to document Home Lab and Network

運維機房和跨域的網路,會遇到各式需求與問題,用對工具才能分析問題,個人覺得最重要的是使用能處理問題的工具。 推薦目前想學和正在使用的平台與軟體,協助將公司/家用機房文件化 佈告欄任務管理 Focalboard 白板可管理任務指派 網路架構文件編寫 netbox 精細管理網路設備與連接線路 IP 資源管理 phpipam 專注網路IP分配 邏輯塊文件編寫 draw.io 視覺化概念圖 機房設備管理 ITDB 管理設備生命週期與使用者

By Phillips Hsieh

如何在Raspberry Pi4上安裝Proxmox for ARM64

第一步 準備好Raspberry Pi 4 / CM4 4GB RAM,這裡要留意CM4如果是買有內建eMMC storage會限制不能使用SD卡開機而限制本地空間容量,如果沒有NAS外接空間或使用USB開機的話,建議買CM4 Lite插上大容量SD卡 第二步 去Armbian官網下載最小化Debian bookworm image https://www.armbian.com/rpi4b/ Armbian 25.2.2 Bookworm Minimal / IOT 然後寫入SD/USB開機碟,寫入方法參考官方文件 https://github.com/raspberrypi/usbboot/blob/master/Readme.md Note: 官方提供的預先設定系統方法,可以在Armbian初次啟動自動化完成系統設定。連結在此 https://docs.armbian.com/User-Guide_Autoconfig/

By Phillips Hsieh

世界越快心越慢

在晚飯後的休息時間,我特別享受在客廳瀏灠youtube上各樣各式創作者的影音作品。很大不同於傳統媒體,節目多是針對大多數族群喜好挑選的,在youtube上我會依心情看無腦的動畫、一些旅拍記錄、新聞時事談論。 尤其在看了大量的Youtube的分享後,我真的感受到會限制我的是我的無知,特別是那些我想都沒想過的實際應用,在學習後大大幫助到我的生活和工作層面。 休息在家時,我喜歡想一些沒做過的菜,動手去設計生活和工作上的解決方案,自己是真的很難閒著沒事做。 如創作文章,陪養新的習慣都能感覺到成長的喜悅,是不同於吃喝玩樂的快樂的。 創作不去限制固定的形式,文字是創作、影像聲音也是創作,記錄生活也是創作,我想留下的就是創造—》實現—》回憶,這樣子的循環過程,在留下的足跡面看到自己一路上的成長、失敗、絕望、重新再來。 雖然大部份的時候去做這些創作也不明白有什麼特別的意義,但不去做也不會留下什麼,所以呀不如反事都去試試看,也許能有不一樣的水花也許有意想不到的結果,投資自己永遠不會是失敗的決定,不是嗎?先問問自己再開始計畫下一步,未來沒人說得準。 像最近看youtube仍大一群人在為DOS開

By Phillips Hsieh