Upgrading 12cR1 to 12cR2 Non-CDB database

In this article, we will see upgrading Oracle Database from 12c Release 1 to 12C Release 2. Step 1: Check database details [oracle@localhost u01]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 27 04:08:28 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 […]

Read More

Upgrading an Oracle Data Guard Broker Configuration

Step 1: Login to dgmgrl and disable configuration before upgradation DGMGRL> disable configuration; Disabled. Step 2: set dg_broker_start parameter to a false value. SQL> alter system set dg_broker_start=false; System altered. Step 3: upgrade database using dbua Step 4: Start dg_broker by setting dg_broker_start to the true value. SQL> alter system set dg_broker_start=true; System altered. Step […]

Read More

Dropping pluggable database

Dropping Pluggable Database : We can drop the pluggable database using DROP PLUGGABLE DATABASE statement from the root container. Let’s try dropping one pdb Step 1: Check which pdb you want to drop SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- ———- 2 PDB$SEED READ ONLY NO 3 PDB1 MOUNTED 4 PDB2 […]

Read More

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