Oracle 12c Pluggable Database (PDB) – FAQ

March 4, 2013 by 10 Comments 

Let’s continue my series of articles on Oracle 12c Pluggable Database feature including SQL code.  I strongly recommend first reading my previous articles on this topic to understand the rest of the material:
Oracle 12c Pluggable Database is a fundamental architectural change
Oracle 12c Pluggable Database feature insights
Oracle 12c Pluggable Database (PDB) feature hands-on experience
Oracle 12c Pluggable Database – Plug Unplug and Clone

Oracle 12c Pluggable Database Point-In-Time recovery

Oracle 12c Pluggable Database Point-In-Time recovery

There are several questions on Oracle 12c Pluggable Database feature came up on my presentation at the German Oracle User Group (DOAG) regional meeting and from other users. Some of them I’ll clarify in this article. Read more »

Oracle 12c Pluggable Database – Plug Unplug and Clone

February 25, 2013 by 2 Comments 

My presentation of Oracle 12c Pluggable Database feature at DOAG

My presentation of Oracle 12c Pluggable Database feature at DOAG

Last week I gave a presentation called “12c Pluggable Database Feature Insights”at the German Oracle User Group (DOAG) regional meeting in Nuremberg. Not only the presentation itself but also a later discussion was very interesting and valuable. I encourage my nearby German colleagues joining DOAG and visiting regular Regional DOAG meetings in Nuremberg.

Let’s continue my series of articles on Oracle 12c Pluggable Database feature including SQL code.  I strongly recommend first reading my previous articles on this topic to understand the rest of the material:
Oracle 12c Pluggable Database is a fundamental architectural change
Oracle 12c Pluggable Database feature insights
Oracle 12c Pluggable Database (PDB) feature hands-on experience

This time I’ll show how to plug a Pluggable Database (PDB) into another Container Database (CDB), how to clone PDBs and how to adopt non-CDB as a PDB into a pre-existing CDB. To start with, I will use a Pluggable Database MY_PDB which I unplugged in my previous article and will plug it into another Oracle 12c Container database called cdb2. Read more »

Oracle 12c Pluggable Database (PDB) feature hands-on experience

February 1, 2013 by Leave a comment 

I strongly recommend first reading my previous articles on this topic to understand the rest of the material:
Oracle 12c Pluggable Database is a fundamental architectural change
Oracle 12c Pluggable Database feature insights

As I wrote previously Pluggable Databases is a brand-new capability in Oracle Database 12c that will be released soon. In this article I continue giving more practical insights of an Oracle 12c Pluggable Database future including SQL statement examples. The SQL code I mention below is applicable to Oracle database 12.1 Beta2.

Let’s repeat the step of connecting to a Container database (CDB) called cdb1 from my last article.

sqlplus sys/pass@localhost:1521/cdb1 as sysdba
Read more »

Oracle 12c Pluggable Database feature insights

January 25, 2013 by 6 Comments 

I’m excited about a new version of Oracle database 12c that will be released soon. In the last article I wrote about a considerable architectural change that Oracle is going to introduce with help of Oracle 12c Pluggable database feature. Let’s continue and explore some details of Oracle 12c Pluggable database feature.

Bear in mind that conventional database mode will be still available in 12c database. That means you will have two options of creating a usual old-fashioned Oracle database (non-CDB) or creating a Container Database (CDB) that will hold all your Pluggable Databases (PDB) that you will create or plug later. See below more details.

12c Pluggable Database details

– Each PDB has its own private data dictionary for customer-created database objects; CDB on the other hand as a whole has the data dictionary for the Oracle-supplied system each data dictionary defines its own namespace. In other words, there is global Data dictionary (CDB level) and local one (PDB level).

– There is a new split data dictionary architecture that allows a PDB to be quickly unplugged from one CDB and plugged into a different CDB

– Each PDB sees a read-only definition of the Oracle-supplied system

Read more »

Oracle 11gR2 ASM and ACFS – Cloud File System License

February 10, 2012 by 5 Comments 

I sense the confusion between Oracle users running Oracle Grid Infrastructure 11gR2 with Automatic Storage Management (ASM) and Automatic Storage Management Cluster File System (ACFS) about the new license policy from Oracle. Oracle introduced a new all in one license called Cloud File System. Since this new Oracle licensing policy is not so straight forward, I’ll try to put some light on the topic. But first let’s see what Oracle Cloud File System itself is. Read more »

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email