Transparent Application Fail-over in Oracle RAC

Transparent Application Failover (TAF) is a feature of the Java Database Connectivity (JDBC) Oracle Call Interface (OCI) driver. It enables the application to automatically reconnect to a database, if the database instance to which the connection is made fails. This is true regardless of how the connection was lost. When an Instance shut down unexpectedly […]

Read More

Grid Plug and Play [GPNP] Profile in Oracle RAC

Grid Plug and Play [GPNP] Profile : It is small xml file located  in $GRID_HOME/gpnp/<hostname>/profiles/peer under the name profile.xml. It is used to establish the correct global personality of a node. Each node maintains a local copy of the GPnP Profile and is maintanied by the GPnP Deamon (GPnPD) .

Now , with above file we […]

Read More

Oracle RAC Dynamic Remastering

In Oracle RAC , Each and every data block is mastered by an Instance. That Instance is called Resource Master for that data block. Master Instance keeps track of the status of the data block like which instance is holding instance for this block , in which state it is being held etc.This Information is […]

Read More

SCAN listener in Oracle RAC

What is SCAN in Oracle RAC? Single Client Access Name (SCAN) is an Oracle Real Application Clusters (Oracle RAC) feature that provides a single name for clients to access Oracle Databases running in a cluster. And we can say that SCAN is a cluster alias for database. The benefit is that SCAN-NAME you provide for […]

Read More

Convert Single Instance Database to Oracle RAC using dbca

In this article, we will see the conversion of the non-RAC database to RAC database using DBCA. Single Instance DB Name RAC DB name RAC Instance Node RAC Instance Name RAC Node Name dbtest testrac Node 1 testrac1 RAC1 Node 2 testrac2 RAC2 Part 1: Create a template from existing database. Step 1: Run DBCA […]

Read More

Fast Application Notification[FAN] Events

In previous articles we have seen FAN overview Fast Application Notification [FAN] overview and benefits of using FAN In this article we will see supported event types of FAN. Node Down : This event notifies that node is not reachable.The Cluster sends this event when a node is no longer able to accept work. Service Up: […]

Read More

Connection Load Balancing in Oracle RAC

Load balancing means “to distribute load among multiple entities”. In Oracle RAC ,Load Balancing feature is very well maintained. Load is distributed among all instance. However we need to take care of some things , like creating service based on group of users connecting database.Assigning number of backup instance if service fails on preferred instance […]

Read More

Convert Single Instance Database to RAC Database using RCONFIG

In Previous article we learned about overview of RCONFIG . In this Article we will see Conversion of Single Instance DB to RAC DB with RCONFIG Prerequisites : Single Instance DB Name RAC DB name RAC Instance Node  RAC Instance Name RAC Node Name test TEST  Node 1 db1 RAC1 Node 2 db2 RAC2 Step […]

Read More

RCONFIG overview

RCONFIG is a non interactive command line utility for converting a Single-Instance database to RAC database.It is installed by default as a executable file under $GRID_HOME/bin and $ORACLE_HOME/bin. It takes XML file as input and process the conversion procedure. Benefits of using RCONFIG : It’s very light and easy to use utility for conversion of Single Instance database […]

Read More

Converting RAC DB to Non-RAC on Normal File System

To convert RAC to Non-RAC DB on normal file system we need to first convert it into ASM storage Converting RAC db to Non-RAC db In this article we will see conversion database from ASM to Normal File System : Step 1 : Check details of ASM database and create pfile from spfile :

[…]

Read More