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

Convert Non ASM database to ASM Database using Duplicate Database command

You can use these steps to migrate a NON-ASM database to ASM database in Oracle 11gR2. Prerequisite – ASM instance should be created and up and running. Single Instance Non ASM DB name Single Instance ASM DB name test testdb Step 1 : Check details of Single Instance Database :

Optionally, we can check size […]

Read More

Fast Application Notification[FAN] Benefits :

For DBA, if a database is up and running, everything seems beautiful..!! But once a state change happens in a database, we don’t know will it take 2 min to overcome it or it will eat our infinite time. When we talk about Oracle RAC, we know there are multiple resources are available to give […]

Read More

Converting an Administrator-Managed Database to a Policy-Managed Database

In this article, We can convert Administrator managed database to Policy managed database : First of all, let’s check the configuration of the database :

In above output, we can see the last line shows us my demo database is an administrator-managed database. Now next we need to create a server pool.

In […]

Read More

Relocating Service in Oracle RAC

In this article, we will see Relocation of Service from One Instance to another Instance. I have service called myservice already running at orcl1 instance. Let us check status of myservice

Now relocate service from orcl1 to orcl2

-i represents an old instance -t represents a new instance Now check the status of […]

Read More

Creating Deleting and Modifying Services in Oracle RAC

1.Creating Service in Oracle RAC : Step 1: To create a service in Oracle RAC

Here I have created service named myservice with preferred instance orcl1 and available instance orcl2. To check all available parameters of service creation :

Step 2: Check the status of service :

We can see here service […]

Read More

Network link in expdp

The export operation is performed with data that is consistent up to the specified SCN. If the NETWORK_LINK parameter is specified, then the SCN refers to the SCN of the source database. Follow following steps to the export database using network-link. Source database: demo Target database: uat Database platform : Step 1 : Create a tnsnames.ora […]

Read More

Fast Application Notification [FAN] overview

As the Oracle docs say, The Oracle RAC, FAN, Oracle 12c Fast Application Notification (FAN) feature provides a simplified API for accessing FAN events through a callback mechanism. This mechanism enables third-party drivers, connection pools, and containers to subscribe, receive and process FAN events. These APIs are referred to as Oracle RAC FAN APIs. If […]

Read More