{"id":2624,"date":"2017-05-31T23:17:45","date_gmt":"2017-06-01T02:17:45","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=2624\/"},"modified":"2017-08-01T22:29:54","modified_gmt":"2017-08-02T01:29:54","slug":"ocm-12c-preparation-create-and-manage-pluggable-databases","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2017\/05\/ocm-12c-preparation-create-and-manage-pluggable-databases\/","title":{"rendered":"OCM 12c Preparation – Create and manage pluggable databases"},"content":{"rendered":"

Creating the CDB database is one of the most elementary tasks a DBA must do in 12c. For OCM exam, you must create the container DB easily in all the ways imaginable.<\/p>\n

I can think on the following ways of creating it:<\/p>\n

    \n
  1. Create database using dbca via GUI (the fastest and recommended if the exam does not put any restrictions)<\/li>\n
  2. Create database using dbca with response file.<\/li>\n
  3. Create database using dbca with parameters in the command line.<\/li>\n
  4. Create database using the “CREATE DATABASE” statement (not recommended if the database is CDB as catcdb.sql<\/strong> takes a lot of time).<\/li>\n<\/ol>\n

    Create those databases in your Single Instance Oracle VM and also in your Oracle RAC VM, to be sure you are used to it.<\/p>\n

    But this topic also talks about “manage pluggable databases”. So, you must know all the ways of cloning, copying, removing and plugging and unplugging it:<\/p>\n

      \n
    1. Create a PDB by using the seed<\/li>\n
    2. Create a PDB by cloning an existing PDB or non-CDB (local or remote databases via DBLink)<\/li>\n
    3. Create a PDB by plugging an unplugged PDB into a CDB<\/li>\n
    4. Create a PDB by using a non-CDB<\/li>\n
    5. Unplugging a PDB from a CDB<\/li>\n
    6. Dropping a PDB<\/li>\n<\/ol>\n

      Using:<\/p>\n

        \n
      1. DBCA<\/li>\n
      2. SQL Plus<\/li>\n
      3. SQL Developer<\/li>\n
      4. EM Express Edition<\/li>\n
      5. EM Cloud Control<\/li>\n<\/ol>\n

        PS 1: Don’t forget to try to plug a PDB from different version like 12.1.0.1 or even a non-CDB 11.2 and performing the upgrade.<\/strong><\/p>\n

        PS 2: Play also unplugging\/plugging using Xml File \/ PDB Archive \/ PDB File Set (the last 2 only available with dbca in 12.1.0.2).
        \n<\/strong><\/p>\n

        PS 2: Plug something from a different charset and convert it.
        \n<\/strong><\/p>\n

        In Oracle 12.1.0.2c, we also “save time” improvements as:<\/p>\n