BE SHARING

Pluggable Database

Migration with Multitenant: how easy it is!

03.02.2023 by Jérôme Dubar

Introduction On Oracle Database, Multitenant feature will be turning 9 in July, but it’s not yet widely deployed as most of the databases are still running on non-CDB architecture. With 19c, Multitenant is now mature and free if you stick(…)

Database Administration & Monitoring

Move a PDB from a server to another one using NFS

03.12.2021 by Jérôme Dubar

Introduction Multitenant brings new possibilities regarding Oracle databases, and one of them is to move a database from a container to another quite easily. When containers are on the same server, it’s very easy, but when the containers are on(…)

Database Administration & Monitoring

Migrating From Oracle Non-CDB 19c to Oracle 20c

03.05.2020 by Oracle Team

By Mouhamadou Diaw With Oracle 20c, the non-multitenant architecture is no longer supported. So, people will have to migrate their databases to container if they want to use Oracle 20c. There are many methods to transform a non-cdb database to(…)

Database Administration & Monitoring

Database Vault : Rules, Rule Sets and Command Rules

13.07.2018 by Oracle Team

By Mouhamadou Diaw In a previous blog I talked about protecting data using Realms. With Database Vault we can also protect our database against some SQL statements. These statements can include SELECT, ALTER SYSTEM, database(…)

Database Administration & Monitoring

Oracle Virtual Private Database

26.06.2018 by Oracle Team

By Mouhamadou Diaw Oracle Virtual Private Database (VPD) enables you to dynamically add a WHERE clause in any SQL statement that a user executes. The WHERE clause filters the data the user is allowed to access, based on the identity(…)

Database Administration & Monitoring

Oracle 12cR2 – ORA-44777 – Pluggable database service cannot be started

26.05.2017 by Oracle Team

By William Sescu Have you ever experienced the following error? SQL> alter pluggable database pdb2 open; alter pluggable database pdb2 open * ERROR at line 1: ORA-44304: service does not exist ORA-44777: Pluggable database service cannot be started. The error(…)

Database management

From 8.0 extended rowid to 12c pluggable db: Why Oracle Database is still a great software

24.10.2014 by Oracle Team

By Franck Pachot . Do you know why Oracle Database is a leader in the database market since 30 years? Do you know any other software that is still the leading solution after decades? I think that it is(…)

Database management

Oracle 12c: Applying PSU 12.1.0.1.1 with Multitenant DB & unplug/plug

16.01.2014 by Oracle Team

The concept of Multitenant databases, which was introduced with Oracle 12c in June 2013, allows to run several databases on a single instance. Oracle presents this feature as a good solution for Oracle patching. The reason behind it is(…)

Database management

Oracle Database 12c : démarrage automatique des Pluggable Databases

10.09.2013 by

Dans ce blog post, nous allons nous intéresser à la gestion des PDBs (Pluggable Database) dans Oracle 12c. Plus exactement, nous allons nous pencher sur l’arrêt et le démarrage automatiques des PDBs en utilisant le Server Control (srvctl) du(…)

Database management

Oracle Database 12c: PDBs not fully transportable yet

20.08.2013 by Yann Neuhaus

One of the benefits of the new Oracle multi-tenant database option is to create a kind of cloned environment through simple statements. This post will focus on the creation of pluggable database through a database link. The reason of(…)