Infrastructure at your Service

Tag

Pluggable Databases Archives - Page 8 of 12 - Blog dbi services

Oracle Team

Oracle Multitenant feature name

By | Database Administration & Monitoring | No Comments

By Franck Pachot . We all know what is the multitenant option: a container database (CDB) with multiple user pluggable databases (PDB). This requires Enterprise Edition plus option. But you can use the same architecture without the option and even in Standard Edition: a CDB with only one user PDB. It is called “single-tenant” or “lone PDB”. How do you call this new 12c architecture?

Read More
Oracle Team

Question is: upgrade now to 12.1.0.2 or wait for 12.2 ?

By | Database Administration & Monitoring | 8 Comments

By Franck Pachot . Let’s look at Release Schedule of Current Database Releases (Doc ID 742060.1) 12.2.0.1 is planned for 2HCY2016 on platforms Linux x86-64, Oracle Solaris SPARC (64-bit), Oracle Solaris x86-64 (64-bit). 2HCY2016 starts next week but we can imagine that it will not be released immediately and anyway we will have to wait a few months to download the on-premise(s) version. Add another couple of months to get at least one Proactive Bundle…

Read More
Oracle Team

DB_FLASHBACK_RETENTION_TARGET may hang your database

By | Database Administration & Monitoring | 3 Comments

By Franck Pachot . DB_FLASHBACK_RETENTION_TARGET is set to keep enough flashback logs to be able to flashback database within the specified retention window. But it’s supposed to be a target only, meaning that on space pressure some files can be deleted. But be careful, there are cases where they are not and then the database hangs until you set a lower retention.

Read More
Oracle Team

Single-Tenant vs. non-CDB: no reason to refuse it

By | Database Administration & Monitoring | 4 Comments

By Franck Pachot . When non-CDB has been declared deprecated, I was a bit upset because multitenant with a lone PDB just looks like an overhead of 3 containers instead of one. But with experience I changed my mind. First because the multitenant architecture brings some features that are available even without the option. And second, because this overhead is not a big problem. Let’s put numbers on that last point.

Read More
Oracle Team

Créer une base Oracle sur le Cloud en quelques clicks

By | Database Administration & Monitoring | No Comments

By Franck Pachot . Il n’a jamais été aussi facile de créer une base Oracle. Et ceci grâce au Database as a Service (DBaaS). C’est l’occasion de tester le cloud: Oracle Cloud Service offre une version d’essai de un mois. Si vous êtes proches de Genève, passez nous voir lors du SITB les 26-27 avril: https://www.dbi-services.com/fr/events-fr/swiss-it-business-sitb-du-26-au-27-avril-2016/ Mais j’ai aussi fait une video pour montrer comment créer sa base sur le Cloud de A à Z.

Read More
Oracle Team

Cloning a PDB to the Oracle Cloud Service

By | Database Administration & Monitoring | 3 Comments

By Franck Pachot . When you create a DBaaS on the Oracle Cloud Service you have only one way to access to your database: ssh with the public rsa key you provide. Then you can open some ports to access the VM. However, from the VM you can’t access your own network. You need it to move data between from on-premises or private cloud to the public cloud. Or to setup a Data Guard between…

Read More