Open refreshable pdb in read write mode

In this post, we can refresh the PDB in read write mode. 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: https://t.me/helporacle Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ Joel Perez’s LinkedIn: Joel Perez’s Profile LinkedIn Group: Oracle Cloud DBAAS Facebook Page: OracleHelp

Read More

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

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

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

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

Manage common and local users, roles, privileges and profiles in PDBs

Introduction of Multitenant Architecture Common users and Local users: This concept came with Oracle Database 12c. Common Users: a Common user is a user which have the same username and password authentication across PDBs of CDB. Common users are created at CDB level and the common user can connect to the root and perform operations. […]

Read More