12c Multitenant Architecture Concepts 4r723o

C 2 1 E S A B A T A D E L C A OR BASICS B’S D P D N A ’S B D C H IT W S K S N TA IO T A R T IS IN M D A IC S A B G PERFORMIN

MULTITENANT ARCHTECTURE DIAGRAM

ADVANTAGES OF MULTITENANT ARCHITECTURE • MANY AS ONE – EASY RESOURCE MANAGEMENT. FOR EX:- 30 DB’S ON A SERVER WILL NOT REQUIRE 600 BCK PROCESSES.

• SINGLE BACKUP FOR CDB – ANY PDB’S PLUGGED INTO CDB IS AUTO-BACKED UP • STANDBY CONFIG – CDB NEEDS TO BE A STANDBY, ANY PDB PLUGGED INTO IT IS AUTOMATICALLY STANDBY PDB, SAME IS WITH RAC

• SINGLE CDB TO PATCH AND UPGRADE • DATA CONSOLIDATION ANIL SHENOY ORACLE DATABASE

CHALLENGES WITH DATA CONSOLIDATION • DIFFERENT DATABASES REQUIRE SAME PUBLIC SYNONYM • DIFFERENT DATABASES REQUIRE THE SAME APPLICATION SCHEMA • BUSINESS OWNERS DO NOT WANT THEIR DATA CO-MINGLED WITH OTHER APPLICATION’S DATA OR DBA’S OF ONE APPLICATION SHOULD NOT SEE THE DATA OF OTHER ‘S – HENCE IT WOULD BE TECHNICAL AND POLITICAL

• MULTIPLE DATABASES IN A SINGLE MACHINE – 30 DB’S TO BACKUP, UPGRADE, MONITOR, STARTUP. DBA’S LIFE ISN’T MADE EASIER

ANIL SHENOY ORACLE DATABASE

CDB – ROOT - PDB CDB CONTAINS CONTAINERS. EVERY CDB HAS ONE ROOT WHICH STORES SYSTEM METADATA TO BE USED BY PDB’S. ROOT CONTAINER IS THE COLLECTION OF SCHEMA, SCHEMA OBJECTS AND NON-SCHEMA OBJECTS TO WHICH ALL PDB’S BELONG.

ROOT DOES NOT STORE DATA OF PDB’S. PDB CONSISTS OF CREATED SCHEMA’S AND OTHER LOGICAL OBJECTS, APPEARS AS A SEPARATE DATABASE. SEED IS A TEMPLATE FOR CREATING NEW PDB.

ANIL SHENOY ORACLE DATABASE

NON-CDB VS CDB

ANIL SHENOY ORACLE DATABASE

S D N A M M O C C I S A B 12 C

HANDS-ON

CONNECT TO A CDB AND TO A PDB • DISPLAY THE LIST OF AVAILABLE SERVICES FOR THE ROOT AND THE PDB’S.

ANIL SHENOY ORACLE DATABASE

SHOW THE PDB’S IN THE CDB’S

ANIL SHENOY ORACLE DATABASE

CREATING A NEW PDB • TO CREATE A NEW PDB, SEED PROVIDES YOU THE TEMPLATE

•

SQL>CREATE PLUGGABLE DATABASE CRM IDENITIFED BY

• • •

STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M)

•

FILE_NAME_CONVERT =(‘ ’,’ ’);

•

SQL>ALTER PLUGGABLE DATABASE CRM OPEN;

DEFAULT TABLESPACE CRM_TBS DATAFILE ‘ SIZE 250M AUTOEXTEND ON

ANIL SHENOY ORACLE DATABASE

MOVE A PDB FROM ONE CDB TO ANOTHER CDB RAC • CLOSE

THE PDB

• SQL>ALTER

• UNPLUG

PLUGGABLE DATABASE CLOSE IMMEDIATE;

THE PDB

• SQL>ALTER

PLUGGABLE DATABASE UNPLUG INTO ‘LOCATION_OF_THE_FILES’;

• $ • PLUG THE SINGLE INSTANCE PDB TO PDB RAC



• SQL>CREATE

PLUGGABLE DATABASE USING SOURCE_FILE_NAME_CONVERT = (‘ NOCOPY; //SOURCE FILES REMOVED FROM ORIGINAL LOCATION TO THE NEW LOCATION ON THE CDB RAC LOCATION.

• PLUG

THE DATABASE

• SQL>ALTER

• CHECK

PLUGGABLE DATABASE OPEN;

THE OPEN MODE OF THE PDB

• SQL>SELECT

OPEN_MODE FROM V$PDBS WHERE NAME= ; //WHEN WE PLUG THE SINGLE INSTANCE PDB FROM SINGLE INSTANCE PDB TO ONE RAC PDB, IT WILL BE IN READ WRITE MODE. ON THE OTHER RAC INSTANCE IT WILL BE IN MOUNT MODE

• TO

OPEN THE PDB FROM MOUNTED MODE

• SQL>

ALTER PLUGGABLE DATABASE OPEN;

ANIL SHENOY ORACLE DATABASE

CLONE THE PDB • WHEN A PDB IS CLONED ITS DATA, S AND

S REMAIN THE SAME AS ORIGINAL PDB’S. CHANGE THE PWD IF THIS NEEDS TO BE WED TO DEVELOPERS

• PUT

THE PDB IN READ-ONLY MODE

• SQL>ALTER

PLUGGABLE DATABASE SALES_TEST OPEN READ ONLY FORCE;

• CLONE

THE PDB

• SQL>CREATE

PLUGGABLE DATABASE SALES_TEST FROM PDB_NAME FILE_NAME_CONVERT = (‘ ’ ,’ );

• OPEN

THE PDB_TEST

• SQL>ALTER

PLUGGABLE DATABASE SALES_TEST;

ANIL SHENOY ORACLE DATABASE

REFERENCE VIDEOS HTTPS://YOUTU.BE/2MROUEW9J88 HTTPS://YOUTU.BE/EAJ-2WEL0LY ANIL SHENOY ORACLE DATABASE