Flashback Pluggable database in RDMBS 12c.

In Oracle 12.1 it is not possible to flashback a pluggable database, but starting with 12.2 it is. Here we start with a demo on how this taks can be accomplished: First we connect to the pluggable and want to create a restore point. SQL> alter session set container=pdbproda; Session altered. SQL> create restore point

18 november 2016|12c, Multitenancy, rdbms|

New Features 12c training van 7-10 december

samen met  verzorgen voor de laatste keer dit jaar een New Features 12c training. Er zijn nog 3 plaatsen vrij. Ook aan de slag met Oracle RDBMS 12c? Eerste 2 dagen lekker aan de slag met basis concept van multitenancy, pluggable databases. De andere 2 dagen RMAN, Security, Performance, VLDB en een aantal generieke RDBMS features.

28 november 2015|12c, Multitenancy, rdbms|

Plug in violations and datapatch

When you plugin/clone a pluggable from a source container into a target container it is possible you have a mismatch in parameters or patches installed. In this blog post I list an example what you will notice when you perform a pluggable cloning action, into a new container with newer installed patches. I always advise

10 november 2015|12c, Multitenancy, rdbms|

Oracle 12c FULL Database Caching – part 2

In a previous post I talked about the Force Full DB Caching feature introduced in Oracle RDBMS release 12.1.0.2.   This feature is available in two flavours. – Database Caching (when possible) – Database Caching with force option.   In this blog we look at the database caching when possible. And this one is simple,

23 oktober 2015|12c, Multitenancy, rdbms|

Oracle 12c FULL Database Caching – part 1

With the introduction of Oracle 12c, 12.1.0.2 a few new features are introduced. One of those features is FULL Database Caching. No additional licensing is required when using this feature This feature is available in two flavours. - Database Caching (when possible) - Database Caching with force option. In this blog we look at the

16 oktober 2015|12c, Multitenancy, rdbms|

Management of Pluggable databases using DBCA in silent mode

One of the great features it to make use of the command-line option available with the oracle tools, like runInstaller, asmca, netca, dbca etc., especially when no X environment is available. Below are several examples on how to manage pluggable database instances using the DBCA in silent mode for the Oracle RDBMS 12c. To list

19 maart 2014|12c, Multitenancy|