Oracle Team

Lost in the Cloud? My Cloud vs. My Services

By Franck Pachot . The Oracle Cloud has two interfaces that are very similar visually and it's easy to get lost and don't find what we are looking for in the menus.

Cloning a PDB to the Oracle Cloud Service

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(…)

How to check Multitenant Option feature usage

By Franck Pachot . Matching the Feature Usage Statistics to licensed options is not always easy. And once a feature usage is recorded, it is usually stored definitively. Let's see how the multitenant option is recorded there.

RAC to RON then RON to RAC and singleton service

By Franck Pachot . You will probably never do it, but let's imagine you have a RAC database, policy managed, with singleton service. Then you convert it to RAC One Node and you change your mind and convert it back(…)

RMAN 12c Push and Pull duplicate explained

By Franck Pachot . Oracle Database 12c introduced the 'restore from service' where you can restore and recover by requesting backupsets from the source. With that feature, the duplicate from active can work in the opposite way: instead of asking(…)

12c Multitenant: PDB spfile parameters for standby database

By Franck Pachot . In multitenant, the spfile parameters at pluggable database level are not stored in the spfile but in the CDB$ROOT table SYS.PDB_SPFILE$ If you open the standby database in read only for reporting, which is one reason(…)

The privileges to connect to a container

By Franck Pachot . In Multitenant, there are two ways to connect to a pluggable database. This means that if you want to prevent access to a pluggable database you need to revoke two privileges.

12c Multitenant internals: AWR tables and views

By Franck Pachot . I received a question about multitenant. AWR tables are often raised as an example of Object Links because automatic workload repository is stored only in CDB$ROOT. However, neither the views DBA_HIST... nor the tables WRH$_... are(…)

12c multitenant: Cursor sharing in CDB

By Franck Pachot . In multitenant, there are two goals: consolidation within the same container database and isolation of pluggable databases. I see multitenant consolidation as an extension of schema consolidation. What is not possible in schema consolidation, such as(…)

Conversion to Flex ASM with asmca takes 5 minutes

By Franck Pachot . In 12c Oracle recommands Flex ASM. You can opt for it at Grid Infrastructure installation, but it's very easy to convert to it later from asmca. It has to configure(…)