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. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- ———- 2 PDB$SEED READ ONLY NO 3 PDB18C2 READ WRITE NO SQL> alter pluggable database PDB18C2 close; Pluggable database altered. SQL> drop pluggable database PDB18C2; […]

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 [oracle@rac2 ~]$ srvctl status database -d globdb Instance globdb is running […]

Read More

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

You might get ORA-02097 while changing PGA_AGGREGATE_LIMIT. SQL> show parameter PGA_AGGREGATE_LIMIT NAME TYPE VALUE ———————————— ——————————– —————————— pga_aggregate_limit big integer 2G SQL> SQL> alter system set PGA_AGGREGATE_LIMIT=5G scope=both; alter system set PGA_AGGREGATE_LIMIT=5G scope=both * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-00093: pga_aggregate_limit must be between 6000M and […]

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: [root@RAC18C ~]# $ORACLE_HOME/crs/install/rootcrs.sh -unlock Using configuration parameter file: /u01/app/18.0.0.0/grid/crs/install/crsconfig_params The log of current session can be found […]

Read More