Infrastructure at your Service

Tag

multitenant Archives - Page 3 of 13 - Blog dbi services

Oracle Team

Unplug an Encrypted PDB (ORA-46680: master keys of the container database must be exported)

By | Oracle | No Comments

By Franck Pachot . In the Oracle Database Cloud DBaaS you provision a multitenant database where tablespaces are encrypted. This means that when you unplug/plug the pluggable databases, you also need to export /import the encryption keys. You cannot just copy the wallet because the wallet contains all CDB keys. Usually, you can be guided by the error messages, but this one needs a little explanation and an example.

Read More
Oracle Team

12c Multitenant internals: PDB replay DDL for common users

By | Oracle | No Comments

By Franck Pachot . In multitenant, you can create common Users, Roles, and Profiles. You create them in CDB$ROOT, with the CONTAINER=ALL clause (which is optional because it is the only possible value when connected to CDB$ROOT) but they are visible to all containers. As the goal of multitenant is to avoid to duplicate common metadata to all containers, You may think that they are visible through those magic metadata links. But that’s actually wrong:…

Read More
Oracle Team

Drop PDB including datafiles may keep files open

By | Oracle | No Comments

By Franck Pachot . I like that Oracle drops the datafiles from the operating system when we remove them from the database (with drop tablespace or drop pluggable database) because I don’t like to have orphean files remaining in the filesystem. However, to ensure that space is reclaimed, we must be sure that Oracle did not leave a process with this file opened. Linux allows to drop an open file but then drops only the…

Read More
Oracle Team

#UKOUG_TECH17

By | Oracle | No Comments

By Franck Pachot . Award I’ve received an award for an article I’ve written last year, the Most Read Oracle Scene Article in 2016 – Technology. I like to write for Oracle Scene magazine. It is rare today to have a magazine both available in a paper version, and also publicly available on the web. And I must say that as an author, all the people behind are doing a great work. Thanks to them…

Read More
Oracle Team

12c Multitenant Internals: compiling system package from PDB

By | Oracle | No Comments

By Franck Pachot . When I explain the multitenant internals, I show that all metadata about system procedures and packages are stored only in CDB$ROOT and are accessed from the PDBs through metadata links. I take an example with DBMS_SYSTEM that has nothing in SOURCE$ of the PDB. But I show that we can compile it from the PDB. This is my way to prove that the session can access the system objects, internally switching…

Read More
Oracle Team

Multitenant internals: INT$ and INT$INT$ views

By | Oracle | No Comments

By Franck Pachot . This month, I’ll talk – with lot of demos – about multitenant internals at DOAG conference. The multitenant dictionary architecture starts with a simple idea: system metadata and data are in CDB$ROOT and user metadata and data are in PDB. And it could have been that simple. When a session connected to a PDB needs to read some system information, the session context is switched to the CDB$ROOT container and reads…

Read More
Oracle Team

Database is more than persistence. It is shared. My thoughts about Microservice Database.

By | Oracle | 4 Comments

By Franck Pachot . The development teams often see the database as a ‘persistence layer’ only. And sometimes it is mentioned that the database is always the cause of the problems, especially when implementing continuous integration and trying to be agile. Then cames the idea to have this ‘persistence layer’ in an isolated environment, such as a docker container, with the database for each developer. However, this overlooks the real cause of the problems, which…

Read More
Oracle Team

Autonomous Database

By | Oracle | 3 Comments

By Franck Pachot . Larry Ellison has announced Oracle 18c to be the Autonomous Database, the no-human labor, and self-driven, database. Here is a quick recap of what it is behind the marketing words. My opinion only.

Read More