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 […]
Articles Tagged: Oracle database 12cr2
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]