Background Processes in Oracle RAC

Oracle RAC Background Processes Image Source The GCS and GES processes, and the GRD collaborate to enable Cache Fusion. The Oracle RAC processes and their identifiers are as follows: 1. ACMS: Atomic Controlfile to Memory Service (ACMS) In an Oracle RAC environment, the ACMS per-instance process is an agent that contributes to ensuring a distributed […]

Read More

RAC : 11gR2 Clusterware Startup Sequence

Here is the brief explanation that how the clusterware brings up step by step . 1. When a node of an Oracle Clusterware cluster start/restarts, OHASD is started by platform-specific means. OHASD is the root for bringing up Oracle Clusterware. OHASD has access to the OLR (Oracle Local Registry) stored on the local file system. […]

Read More

Back Up & Restore an Oracle ASM Password File with pwget Command

In this article we are showing how to backup and restore password file of Oracle ASM with pwget command. pwget Purpose Returns the location of the password file for the Oracle ASM or database instance. pwcopy Purpose Copies an Oracle ASM or database instance password file to the specified location. pwset Purpose Sets the location […]

Read More

Use spget and spmove command in Oracle ASM

Starting with ASM version 11.2, the ASM spfile can be stored in an ASM disk group. Indeed, during a new ASM installation, the Oracle Universal Installer (OUI) will place the ASM spfile in the disk group that gets created during the installation. New ASMCMD commands To support this feature, new ASMCMD commands were introduced to […]

Read More

Rename Empty Diskgroup on ASM 11gR2

The goal here is to rename the DATA diskgroup to DG_PROD_DATA – here is the situation before the rename operation :

1) First of all, the desired diskgroup needs to be dismounted (from each node if this is a RAC configuration):

2) Verify that the desired diskgroup was dismounted:

3) Then execute the rename […]

Read More

Quorum failure group in Oracle ASM

Voting files manage information about node membership. OCR is a system that manages cluster and Oracle Real Application Clusters (Oracle RAC) database configuration information. A quorum failure group is a special type of failure group and disks in these failure groups do not contain user data. A quorum failure group is not considered when determining […]

Read More

Upgrade Oracle Grid and Database (11.2.0.1 to 11.2.0.4)

This article is about upgrade of oracle database 11.2.0.1_to 11.2.0.4).

Download the 9413827 or 9706490 patch from oracle support and get apply

Below are attachment to findout patch steps. Now we can update the grid home and oracle home from 11.2.0.1 to 11.2.0.4 .

1) check the pre-req before upgrading the grid home […]

Read More

Converting Standard to Flex Cluster

Introduction Oracle Real Application Cluster (RAC) is a well-known product among Oracle’s solutions to maintain high availability of your business data. Oracle RAC allows the work load to be shared among all the cluster nodes, with N-1 tolerance configuration in case of node failures, where N is the total number of nodes. Oracle RAC is […]

Read More

Oracle Upgrade Grid and Database Home to 12.1.0.2 with GUI

What is Upgration? It is the process of replacing your existing software with an advance version of the identical product.Upgrading your applications usually do not require special tools. Your existing reports should look and behave the same in both products. For Example: Replacing Oracle 9i release to Oracle 10g release, SQL Server 2005 to SQL Server 2008 etc. Why […]

Read More

Steps to change SCAN IP address in RAC

To Change the SCAN IP  address it must be available and need to changes on the DNS by the network admin. So we have SCAN IP address available. Steps: 1. To check the current status SCN IP address on  DNS

2. Check the current status SCAN-VIP in the resource file

3. Request network […]

Read More