Share My Idea from life

Installing Grid and configuring ASM on Windows

ipstor -

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

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

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.

Select the appropriate installation option.

I will be installing Standalone software for GRID.

Select the desired language. Click next.

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

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

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.

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

The Installation process starts.

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

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

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.

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.

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.

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.

Choose the disks for stamping the with ORACLE label.

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.

The ASM instance gets created.

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

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.

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

+ASM is the sid of the ASM instance.

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”