Infrastructure at your Service

Tag

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

Franck Pachot

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
Franck Pachot

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
Franck Pachot

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
Franck Pachot

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
Franck Pachot

Am I a DBA 3.0 or just an SQL*DBA?

By | Oracle | 2 Comments

By Franck Pachot . There are currently a lot of new buzz words and re-namings which suggest that our DBA role is changing, most of them escorted with a #cloud hashtag. Oracle Technology Network is now called Oracle Developer Community. Larry Ellison announced the database that does not need to be operated by humans. And people talking about the death of DBA, about the future of DBA, about DBA 3.0,… Those are all generalizations and…

Read More
Franck Pachot

Wrong result with multitenant, dba_contraints and current_schema

By | Oracle | One Comment

By Franck Pachot . Multitenant architecture is not such a big change and this is why I recommend it when you start a project in 12c or if you upgrade to 12.2 – of course after thoroughly testing your application. However, there is a point where you may encounter problems on dictionary queries, because it is really a big change internally. The dictionary separation has several side effects. You should test carefully the queries you…

Read More
Franck Pachot

Active Data Guard services in Multitenant

By | Oracle | No Comments

By Franck Pachot . A database (or the CDB in multitenant) registers its name as the default service. When a standby database is on the same server, or same cluster, you have no problem because this database name is the db_unique_name which is different between the primary and the standby(s). In multitenant, in addition to that, each PDB registers its name as a service. But the PDB name is the same in the primary and…

Read More
Franck Pachot

When PDB name conflicts with CDB name

By | Business Intelligence, Oracle | 3 Comments

By Franck Pachot . Going to multitenant architecture is not a big change. The administration things (DBA, monitoring, backups) connect to the CDB and the application things connect to the PDB. Without the multitenant option, it is still recommended to go to the CDB architecture. The non-CDB is deprecated and the multitenant architecture brings interesting features. People often ask how to name the CDB and the PDB, especially when they have naming rules or policies…

Read More
Franck Pachot

Bequeath connect to PDB: set container in logon trigger?

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . There are little changes when you go to multitenant architecture and one of them is that you must connect with a service name. You cannot connect directly to a PDB with a beaqueath (aka local) connection. This post is about a workaround you may have in mind: create a common user and set a logon trigger to ‘set container’. I do not recommend it and you should really connect with a…

Read More