Generating AWR report from Active Dataguard

Oracle 12.2 came up with a new feature that we can generate AWR report from Physical Standby database if we have enabled active datagaurd. We need to perform the following steps to enable AWR reporting from a physical standby database. Step 1: Unlock SYS$UMF user and change its password using SYS user. SYS$UMF account is used […]

Read More

Upgrade and Patch Application in Application Container

In previous article we have seen Installing Application and Synchronizing it with Application PDB. Introduction to Application Container Application Container Creation and Installation of Application In this article, we will see upgrading Application and Patching Application. 1. Upgrade Application in Application Container : Before starting application upgrade you need to know the current version of […]

Read More

Application Container Creation and Installation of Application

In the previous article, we have seen Introduction of Application Container Introduction to Application Container   In this article we will see creating Application Container, Installing Application in Container, Creating Application PDBs and syncing application PDB with application root. Step 1: Create an application root database

Step 2: Open application root database

Step 3: Save […]

Read More

Introduction to Application Container

Application container is a new feature introduced in Oracle 12c Release 2. The main benefit of an application container in your environment is it makes application level patching and upgrade easy. Introduction of Multitenant Architecture In a product based company where you have multiple customers which are having same application running in your PDBs. We […]

Read More

Standby with DBCA in Oracle Database 12cR2

In the new features of Oracle Database 12cR2 (12.2.0.1) DBCA can already be used to create dataguard on the standby side. Below is the environment detail: Type Hostname db_unique_name Primary host01 orclpri Standby host02 orclsby Enable force logging on primary.

2. Create standby with DBCA. Assume we have listener is running on primary side. […]

Read More

Prepare standby and configure primary database for far sync

This depend on distance between primary and standby and network bandwidth. So this feature that came with 12c resolve this situation. We are preparing a database one more. This database take archive–log primary database and then send this archive–log to standby. Primary and far sync standby database are sync, whereas far sync standby database and physical standby database are async. Let’s begin with creating the physical standby with FAR SYNC instance in place. First of […]

Read More

TWO_TASK Environment Variables Oracle 12c

There are two environment variables for Unix to connect an Oracle database.One of them is ORACLE_SID and the other one is TWO_TASK. ORACLE_SID is used for connecting a database which is installed to the same host. TWO_TASK is used for connecting an oracle database which is installed another host. I must thank to my fellow DBA […]

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

File Group in a Flex Disk Group

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. In the goal here is to know a bit more about the Flex Disk Group. Let’s see here what a File Group is. In a Flex Disk Group we can separate our databases, be they PDBs, CDBs or non-CDBs, in different File Group. Each […]

Read More