Parameterverwaltung in CDBs und PDBs
Auch knapp acht Jahre nachdem Oracle mit der Version 12c die Container-Datenbank-Architektur veröffentlicht hat, ist diese Architektur immer noch nicht bei allen Kunden „angekommen“ und sorgt immer wieder für Fragen. Zum Beispiel auch zu dem Thema, wie Parameter in Container-Datenbanken definiert werden und wo die…
PDB_OS_CREDENTIAL and PL/SQL external libraries
In the previous blog post I have described PDB_OS_CREDENTIAL initialization parameter and when it can help you in isolating PDBs from each other. Today I’ll show you an example of how it works with PL/SQL external libraries. Of course we need to setup the whole…
PDB_OS_CREDENTIAL and external jobs
After introduction of Multitenant option, Oracle provided additional ways to ensure proper isolation between pluggable databases. PDB_OS_CREDENTIAL initialization parameter is part of them. It allows to use specified operating system user while interacting with operating system from a PDB. According to documentation, it is taken…
AWR: Multitenant-Specific Initialization Parameters
By default, the database engine automatically takes snapshots in the root container only. Such snapshots cover the root container as well as all open PDBs belonging to it. From version 12.2 onward, you can control whether the database engine automatically takes also PDB-level snapshots through…
Oracle 19c solves ORA-00026 when killing PDB sessions
Oracle Multitenant was a big architectural change for Oracle Database. I guess it was not so easy to introduce it to such a complex system. Unsurprisingly, there were some side effects introduced, but Oracle works hard to correct them. One example is ORA-00026: missing or…
Real-Time Cascade Standby Container Databases without Oracle Managed Files
OK, the title might not be the best… I just would like to add more detail to content you can already find in other blogs (E.g. this nice one from Philippe Fierens http://pfierens.blogspot.com/2020/04/19c-data-guard-series-part-iii-adding.html). I have this Cascade Standby configuration: DGMGRL> connect / Connected to „TOOLCDB1_SITE1″…
Preplugin Backups and the Missing Piece
Subheading 1: Preplugin Backups for non-CDB to PDB Conversions and the RMAN-06054 Subheading 2: PrePlugin Backups and the need for “Trick 17” The following is coming from a customer project. Imagine you have a huge non-CDB database, assume some terabytes. And you want to bring…
Multitenant Pills: Partial PDB cloning (and cleanup)
When consolidating to multitenant, there are several consolidation patterns. Big, complex databases usually have special requirements for which it might be a good choice to go to single-tenant (a single PDB in one CDB) Small, relatively easy databases are the best candidate for consolidation to…
Be careful with ‘save state’ in Data Guard configuration
Users are complaining that from time to time they are connecting to standby database which is opened read-only, instead to primary opened also for writing. What can be the root cause? Previous usage of below command: It keeps not only information about the state of…
Oracle Multitenant – SYS*-Privilegien für Pluggable Datenbanken
In einer Container-Datenbank können SYSDBA-, SYSOPER-Rechte etc. auf PDB-Ebene vergeben werden. Dies ermöglicht es, PDB-Administratoren mit ihren lokalen Rechten eine PDB zu öffnen oder zu schließen. Wie funktioniert das und wo werden diese Privilegien-Informationen gespeichert? English translation of this post Vergabe von SYS*-Rechten auf…
Social Media @trivadis