In previous post we have seen various ways to connect with CDB and PDB. Establish Connection in CDB and PDB In this post we will see how we can Start and shutdown particular PDB and how to Start and shut down whole CDB. 1. How to Start Pluggable database There are two ways possible a) […]
All posts by Jagruti Jasleniya
Jagruti Jasleniya
Establish Connection in CDB and PDB
When it comes to Multi-tenant architecture, one question that comes to our mind is how to connect to container database and pluggable database. Today we will see all possible way to connect to the container database. Obviously, we connect database using service name for the non-local connection. When we create CDB, a service is created […]
Manage Lockdown Profiles in PDB
Lockdown Profiles: Its a mechanism given by Oracle to restrict PDBs from doing certain operations or from restricting them from using certain Functionalities. There are main three categories we can restrict using Lockdown Profile : Statement and clause Feature Option A statement can be Alter System and Alter Session and we can restrict clause with […]
Managing Tablespace in Multi-Tenant Environment Part – I
In this article, we will see how tablespaces are managed in a Multi-tenant architecture. Mainly we have 4 types of tablespaces System Tablespace. User permanent tablespace. Temporary tablespace. Undo tablespace. System tablespace must be created while creating a database using either DBCA or manually. SQL> select name,con_id from v$datafile where name like ‘%system%’; NAME CON_ID […]
Explore Instance of PDB
In a previous post, we have seen the creation of Container database and pluggable database Manually Create and configure CDB database and PDB database In this post, we will explore data dictionary views of CDB and PDB. We all are aware of DBA_, ALL_, and USER_ views. USER_ views show information about user-specific metadata. […]
Convert Regular PDB to Application PDB
In this article, we will see converting regular PDB to Application PDB. Step 1: Check regular PDB SQL> SELECT con_id, name, open_mode, application_root,application_pdb, application_seed from v$containers where application_root = ‘NO’ and application_PDb = ‘NO’ and application_seed = ‘NO’; 2 3 4 CON_ID NAME OPEN_MODE APP APP APP ———- ——————————————————————————————————————————– ———- — — — 1 CDB$ROOT […]
Plugging Non-CDB to CDB
In this article, we will see how we can plug the Non-CDB database as a Pluggable Database in a Container Database. Step 1: Check non-cdb Database SQL> SELECT NAME,OPEN_MODE,CDB FROM V$DATABASE; NAME OPEN_MODE CDB ——— ——————– — NCDB READ WRITE NO Step 2: Gracefully shut down Non-CDB database and open it in READ ONLY stage […]
Generating AWR report from Active Dataguard
Oracle 12.2 came up with a new feature that we can generate AWR report from Physical Standby database if we have enabled active datagaurd. We need to perform the following steps to enable AWR reporting from a physical standby database. Step 1: Unlock SYS$UMF user and change its password using SYS user. SYS$UMF account is used […]
Upgrade and Patch Application in Application Container
In previous article we have seen Installing Application and Synchronizing it with Application PDB. Introduction to Application Container Application Container Creation and Installation of Application In this article, we will see upgrading Application and Patching Application. 1. Upgrade Application in Application Container : Before starting application upgrade you need to know the current version of […]
Creating Application PDB and Syncing with Application Root
In a previous post, we have seen creation steps of Application Container and Installation of Application in the Application container. Application Container Creation and Installation of Application In this article, we will see Creation Steps of Application PDB and synchronization of Application PDB with Application Container. Create application PDB: Step1: Connect to application root : […]