Encrypting PDB

In this article, we will see activating Encryption at pdb level. Before activating activation at pdb level we must open keystore at ROOT level else you will get error “ORA-46661: keystore not open in root container”. Step 1: We need to set ENCRYPTION_WALLET_LOCATION in sqlnet.ora file [oracle@localhost ~]$ mkdir -p /u01/oracle/wallet [oracle@localhost admin]$ cat sqlnet.ora […]

Read More

PDB Performance Profile

Oracle has introduced a new concept of Performance Profiles with 12c Release 2. Now, What is Performance Profile? Performance Profiles are new concept in Resource Manager. We can fairly distribute resources among pdbs as per their workload. By creating a performance profile you can set the following resource limit SHARES UTILIZATION_LIMIT PARALLEL_SERVER_LIMIT Let us understand […]

Read More

Oracle Golden Gate Components

Oracle Golden Gate Oracle GoldenGate offers a real-time, log-based replication software platform to meet the needs of today’s transaction-driven applications. The software provides capture, routing, transformation, and delivery of transactional data across heterogeneous databases in real time. Components in Oracle Golden Gate :  Following Components are used in Oracle Golden Gate to perform its tasks. Extract […]

Read More

duplicating pluggable database

In Oracle 12.2 there is a beauty in RMAN that we can restore a single pdb from whole CDB backup. In this article, we will see how we can duplicate Single PDB from CDB backup What I have : One CDB : CDB12 Three pdbs : pdb, pdb1, pdb2 What I will get : One CDB […]

Read More

PDB Creation with Various methods

In the next 2-3 posts we are going to see all the methods used to create Pluggable Database There are following methods available to create Pluggable Database : Clone a regular PDB Create remote pdb using dblink Create a regular pdb to an application PDB Unplug and Plug a non-CDB Unplug and plug a regular […]

Read More

Create Pluggable Database using dblink

We can create a pluggable database using dblink from a remote location. Step 1: Check container database SQL> select name,open_mode,cdb from v$database; NAME OPEN_MODE CDB ——— ——————– — UPDB READ WRITE YES SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- ———- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 […]

Read More

Upgrade 12.1 PDBs to PDBs in 12.2

In this post, we will see how we can upgrade the Pluggable database of Oracle 12c Release 1 to Oracle 12c Release 2. Source Version 12.1.0.2.0 Upgrade Version 12.2.0.1.0 Pluggable Database Name PDB Step 1: Check the version of the pluggable database [oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug […]

Read More

Flashback Database in Multi-Tenant Architecture

Flashback Database is a very powerful feature offered by Oracle. We can enable flashback in CDB same way we are doing in the non-cdb database. Enable Flashback Database in CDB : Step 1 : Check flashback_on from v$database SQL> select name,open_mode,cdb,flashback_on from v$database; NAME OPEN_MODE CDB FLASHBACK_ON ——— ——————– — —————— DUPCDB READ WRITE YES […]

Read More

Validating Container and Pluggable Database

The validating database is one part of the DBA job. Most DBAs wants to check the database’s health pro-actively regularly during non-peak hours. Validating Database checks the following things : 1. It scans specified files and their contents. 2. It confirms that specified files exist and they are at the correct location. 3. It checks […]

Read More

Managing Tablespace in Multi-Tenant Environment Part – II

In the previous article, we have seen System tablespace and Users tablespace. Managing Tablespace in Multi-Tenant Environment Part – I In this article we will see Temporary tablespace and Undo tablespace : Temporary Tablespace : Every CDB$ROOT can have one default temporary tablespace or tablespace group. Pluggable databases must have their own temporary tablespace to […]

Read More