Scribd Logo
Upload

Welcome to Scribd!

  • 219 views

    12c Multitenant Architecture Concepts

    Uploaded by

    anil_shenoy
    This document provides an overview of multitenant architecture in Oracle Database. It defines key concepts like CDB, PDB, and root; describes advantages like consolidated backups and upgrades; challenges around data consolidation; and includes examples of commands to work with CDBs and PDBs, such as creating, plugging, and cloning PDBs.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    12c Multitenant Architecture Concepts

    Uploaded by

    anil_shenoy
    219 views13 pages
    This document provides an overview of multitenant architecture in Oracle Database. It defines key concepts like CDB, PDB, and root; describes advantages like consolidated backups and upgrades; challenges around data consolidation; and includes examples of commands to work with CDBs and PDBs, such as creating, plugging, and cloning PDBs.

    Original Description:

    multitenant architecture basics; 12 c basic commands to create, clone

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an overview of multitenant architecture in Oracle Database. It defines key concepts like CDB, PDB, and root; describes advantages like consolidated backups and upgrades; challenges around data consolidation; and includes examples of commands to work with CDBs and PDBs, such as creating, plugging, and cloning PDBs.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    219 views13 pages

    12c Multitenant Architecture Concepts

    Uploaded by

    anil_shenoy
    This document provides an overview of multitenant architecture in Oracle Database. It defines key concepts like CDB, PDB, and root; describes advantages like consolidated backups and upgrades; challenges around data consolidation; and includes examples of commands to work with CDBs and PDBs, such as creating, plugging, and cloning PDBs.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    You are on page 1of 13

    C

    2
    1
    E
    S
    A
    B
    A
    T
    A
    D
    E
    L
    C
    A
    OR
    BASICS
    BS
    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 DBS ON A SERVER WILL NOT REQUIRE 600
    BCK PROCESSES.

    SINGLE BACKUP FOR CDB ANY PDBS 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 ADMINISTRATOR

    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 APPLICATIONS DATA OR DBAS
    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 DBS TO BACKUP, UPGRADE, MONITOR, STARTUP. DBAS
    LIFE ISNT MADE EASIER

    ANIL SHENOY
    ORACLE DATABASE ADMINISTRATOR

    CDB ROOT - PDB


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

    ROOT DOES NOT STORE USER DATA OF PDBS.


    PDB CONSISTS OF USER CREATED SCHEMAS AND OTHER LOGICAL OBJECTS, APPEARS AS A SEPARATE DATABASE.
    SEED IS A TEMPLATE FOR CREATING NEW PDB.

    ANIL SHENOY
    ORACLE DATABASE ADMINISTRATOR

    NON-CDB VS CDB

    ANIL SHENOY
    ORACLE DATABASE ADMINISTRATOR

    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 PDBS.

    ANIL SHENOY
    ORACLE DATABASE ADMINISTRATOR

    SHOW THE PDBS IN THE CDBS

    ANIL SHENOY
    ORACLE DATABASE ADMINISTRATOR

    CREATING A NEW PDB


    TO CREATE A NEW PDB, SEED PROVIDES YOU THE
    TEMPLATE

    SQL>CREATE PLUGGABLE DATABASE CRM ADMIN USER


    IDENITIFED BY PASSWORD

    STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M)

    FILE_NAME_CONVERT
    =(<LOCATION_OF_THE_SEED>,<LOCATION_OF_THE_CRM_PD
    B>);

    SQL>ALTER PLUGGABLE DATABASE CRM OPEN;

    DEFAULT TABLESPACE CRM_TBS


    DATAFILE <LOCATION_OF_TBS_DATA_FILE> SIZE 250M
    AUTOEXTEND ON

    ANIL SHENOY
    ORACLE DATABASE ADMINISTRATOR

    MOVE A PDB FROM ONE CDB TO ANOTHER CDB RAC


    CLOSE

    THE PDB

    SQL>ALTER

    UNPLUG

    PLUGGABLE DATABASE <PDB_NAME> CLOSE IMMEDIATE;

    THE PDB

    SQL>ALTER

    PLUGGABLE DATABASE UNPLUG INTO LOCATION_OF_THE_FILES;

    $cp <location_of_the_files_in_single_inst>
    PLUG THE SINGLE INSTANCE PDB TO PDB RAC

    <location_of_the_files_in_rac_inst>

    SQL>CREATE

    PLUGGABLE DATABASE <PDB_NAME> USING <location_of_the_files_in_single_inst/PDB_NAME.xml>


    SOURCE_FILE_NAME_CONVERT = (<location_of_the_files_in_single_inst> NOCOPY; //SOURCE FILES REMOVED
    FROM ORIGINAL LOCATION TO THE NEW LOCATION ON THE CDB RAC LOCATION.

    PLUG

    THE DATABASE

    SQL>ALTER

    CHECK

    PLUGGABLE DATABASE <PDB_NAME> OPEN;

    THE OPEN MODE OF THE PDB

    SQL>SELECT

    OPEN_MODE FROM V$PDBS WHERE NAME=<PDB_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 <PDB_NAME> OPEN;

    ANIL SHENOY
    ORACLE DATABASE ADMINISTRATOR

    CLONE THE PDB


    WHEN A PDB IS CLONED ITS DATA, USER ACCOUNTS AND

    PASSWORDS REMAIN THE SAME AS ORIGINAL PDBS. CHANGE THE


    PWD IF THIS NEEDS TO BE PASSWED 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 =
    (<LOCATION_OF_SALES_TEST_FILES_LOCATION>
    ,<LOCATION_OF_SALES_FILES_LOCATION>);

    OPEN

    THE PDB_TEST

    SQL>ALTER

    PLUGGABLE DATABASE SALES_TEST;

    ANIL SHENOY
    ORACLE DATABASE ADMINISTRATOR

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

    You might also like