Capture DDL statements in Oracle DB

There are many cases where we need to capture the ddl statements in our production environment where application team have direct access for create or drop any object in the application schema in the production database . What is DDL ?? DDL (Data Definition Language) is a language used by a database management system that allows users to define the database and specify data types, structures […]

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

Benefits of Implementing a Logical Standby Database

Logical Standby Database in Data Guard environment stays in a Read, Write mode that is fully updatable mode. Logical Standby Database provides following benefits over any other standby database in data guard : To know more about Logical Standby Architecture: Logical Standby Database: SQL Apply Architecture The database is opened in READ, WRITE mode in logical […]

Read More

Configure DG broker

The Data Guard broker logically groups these primary and standby databases into a broker configuration that allows the broker to manage and monitor them together as an integrated unit. You can manage a broker configuration using either the Oracle Enterprise Manager graphical user interface or the Data Guard command-line interface. To know more about it […]

Read More

ORA-65179 PDB in Oracle 12c

While dropping the PDB, we receive the error like cannot keep datafiles for a pluggable database that is not unplugged.


Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or Follow us: Telegram Channel: Skant Gupta’s LinkedIn: […]

Read More

Creating RAC database With PDBS

In this Article we will Create RAC Database with PDBS using DBCA. Step 1 : Once you use dbca , first screen that will open is as below select Create Database and click  next: Step 2 : Select Advanced Mode and click Next Step 3 : Select RAC database as database type and Admin Managed […]

Read More

Plug Single Instance PDB to RAC CDB

In this article we will Plug Single Instance PDB to RAC CDB. Single Instance CDB Name Single Instance PDB Name RAC Instance CDB RAC Instance Name RAC Node  globdb pdb1 CDB1 RAC1 Node1 RAC2 Node2 Step 1 : Check status of Globdb and CDB1

Step 2 : Check details of globdb :

Step […]

Read More

ora-02097 parameter cannot be modified because specified value is invalid

You might get ORA-02097 while changing PGA_AGGREGATE_LIMIT.

To set PGA_AGGREGATE_LIMIT we should take care of following allowable values : 2 GB (default value) 200% of the PGA_AGGREGATE_TARGET value 3 MB times the value of the PROCESSES parameter. Less then 1.2 X RAM – SGA Here In my case I am changing value according my […]

Read More

Relink Oracle 12c Grid Infrastructure and RDBMS binaries.

In order to relink the Oracle Grid Infrastructure RAC/Cluster Installation, please follow the next steps after stopping all the services running: 1) As root OS user, please unlock the Grid Infrastructure Oracle Home (on every node) as follows:

2) As the Oracle Grid Infrastructure owner (on every node) relink the Grid Infrastructure Oracle Home […]

Read More