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 […]
All posts by Jagruti Jasleniya
Jagruti Jasleniya
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: […]
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 […]
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 […]
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 […]
ora-02097 parameter cannot be modified because specified value is invalid
You might get ORA-02097 while changing PGA_AGGREGATE_LIMIT. SQL> show parameter PGA_AGGREGATE_LIMIT NAME TYPE VALUE ———————————— ——————————– —————————— pga_aggregate_limit big integer 2G SQL> SQL> alter system set PGA_AGGREGATE_LIMIT=5G scope=both; alter system set PGA_AGGREGATE_LIMIT=5G scope=both * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-00093: pga_aggregate_limit must be between 6000M and […]
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 : [oracle@rac1 […]
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 […]
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 […]
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 […]