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

ora-02097 parameter cannot be modified because specified value is invalid

You might get ORA-02097 while changing PGA_AGGREGATE_LIMIT.

To set PGA_AGGREGATE_LIMIT we should take care of following allowable values : 2 GB (default value) 200% of the PGA_AGGREGATE_TARGET value 3 MB times the value of the PROCESSES parameter. Less then 1.2 X RAM – SGA Here In my case I am changing value according my […]

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

Converting RAC db to Non-RAC db

In previous Articles we have seen conversion from Single Instance DB to RAC db using various methods.In this Article we will see conversion of RAC to Normal DB[Single Instance]. Prerequisites : RAC Instance Node RAC Node Name RAC DB Name RAC Instance Name  Single Instance DB name Node 1 RAC1 test db1 test Node 2 […]

Read More

Basic on Administrator Managed and Policy Managed Database in Oracle Rac

There are two methods to manage your cluster database. Administrator Managed database Policy Managed Database Administrator Managed Database : In Administrator Managed database , a DBA manages each instance of the database by defining specific instances to run on specific nodes in the cluster.It is traditional way of cluster management. Policy Managed Database : It’s […]

Read More

Convert Single Instance Database to Oracle RAC

In this post, we can perform Convert Single Instance Database to Oracle RAC in Oracle 11gR2. Prerequisites: we already have single instance ASM database up and running. we have already have second node with ASM running. If you want to how to convert non asm database to asm database with duplicate command: Click Here RAC […]

Read More