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 SQL> CREATE PLUGGABLE DATABASE APP_PDB AS APPLICATION CONTAINER ADMIN USER APP_ADMIN […]
All posts by Jagruti Jasleniya
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 […]
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 [oracle@localhost ~]$ cd $ORACLE_HOME/dbs [oracle@localhost dbs]$ cat initmycdb.ora db_name=mycdb CONTROL_FILES=’/u02/oradata/mycdb/control01.ctl’,’/u02/oradata/mycdb/control02.ctl’ ENABLE_PLUGGABLE_DATABASE=TRUE DB_CREATE_FILE_DEST=’/u02/oradata/’ DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’ DB_BLOCK_SIZE=8192 UNDO_MANAGEMENT=AUTO UNDO_TABLESPACE=undotbs USER_DUMP_DEST=’/u01/oracle/admin/mycdb/adump/’ Step 2: Create necessary directories. [oracle@localhost dbs]$ mkdir […]
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 […]
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 […]
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 […]
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 […]
Upgrading Oracle Database with a Physical Standby Database
In this article, we can upgrade the 11g database to 12c with the help of DataGaurd Primary DB Name Standby DB Name Database Version Upgrade Version UPGDB UPGDB 11.2.0.4.0 12.1.0.2.0 Step 1: Install 12.1.0.2 binaries on both Primary and Standby Server. Step 2: Shut down Primary Database. Step 3: Shut down Standby Database. Step 4: […]
Recover Datafile in Standby Database in Data Guard Environment
In the previous article, we have to seen Recovering Primary Database Datafile using Standby Database if it’s not deleted from Standby Database. Recover Data File in Primary Database in Data Guard Environment Here we will see what if datafile gets corrupted or deleted from Standby Database. Step 1: In the below code, we can see […]
Managing Client Connectivity using DBMS_SERVICE package and After Startup Trigger
In the previous Article, we have seen understanding and managing user connectivity in Data Guard Environment. Understanding and managing client connectivity In this Article, we will see Creating After Startup Trigger which will manage service for different database roles. Step 1: Create services in a Primary database with DBMS_SERVICE package. Note: We need to […]