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

Creating Application PDB and Syncing with Application Root

In a previous post, we have seen creation steps of Application Container and Installation of Application in the Application container. Application Container Creation and Installation of Application In this article, we will see Creation Steps of Application PDB and synchronization of Application PDB with Application Container. Create application PDB: Step1: Connect to application root : […]

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

Manually Create and configure CDB database and PDB database

In the previous article, we can see that the architecture of multitenant. In this post, we will configure manually CDB and PDB. Introduction of Multitenant Architecture Step 1: create initmycdb.ora

Step 2: Create necessary directories.

Step 3: export ORACLE_SID and start the database in the nomount stage

Step 4: Create a script […]

Read More

Describe the CDB root and pluggable database containers

In the previous article, we have explored Multitenant architecture. Introduction of Multitenant Architecture We have heard this word container database and pluggable database many times after 12c came into the market. Today we will see what does it mean by a pluggable database and container database. Container Database and Pluggable Database : In a multi-tenant […]

Read More

Introduction of Multitenant Architecture

Oracle databases are always extremely advanced and sophisticated software components that are state of the art for RDBMS. Till 12.1 came into the market we used to have Single Database associated with Single Instance [Except RAC environment], to support each application we need to create a new database. So the organization which handles 50 different […]

Read More

Creating Data Guard with 2 node RAC Primary and 2 node RAC standby

In this article, we will see the creation of DataGuard with 2 node RAC Primary Database and 2 node RAC Standby database. Primary Database Standby Database Primary Instance Standby Instance RACDB DGRACDB RAC1 DGRAC RAC2 DGRAC1 What I have already done 1. My production database is up and running with 2 node RAC Oracle Version […]

Read More

Using DBMS_ROLLING to Upgrade the Oracle Database

We know the pain of Upgrading Database, taking hours of downtime. But, Oracle comes with a new feature called DBMS_ROLLING from 12C Release 1. If you are having a license for Active Data Guard this method will minimize your downtime for upgrade or patching. This method is well automated. You just need 90 seconds 120 […]

Read More