Infrastructure at your Service

Pluggable Database Archives - Blog dbi services

William Sescu

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

By | Database Administration & Monitoring | No Comments

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 says, that Oracle is not able to open the pluggable database because a service is missing. At least the default service, which is the name of the pluggable database itself should be there. But in my case, it…

 
Read More
Franck Pachot

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

By | Database management, Oracle | 4 Comments

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 because Oracle has been a good software from the get-go. Many early decisions in the software architecture have revealed themselves later to be the right decision. Several decisions, such as the C language that made it portable to all platforms…

 
Read More
Michael Schwalm

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

By | Database management | No Comments

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 that it is now possible to unplug a container database (called PDB) from its original container (called CDB), in order to plug it into a new local or remote Container with a higher level of PSU….

 
Read More
Olivier Toussaint

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

By | Database management | No Comments

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 Grid Infrastructure de la 12c. Le contexte Au préalable, il faut avoir installé Grid Infrastructure et créé une CDB (Container Database) avec une PDB. Nous allons utiliser le processus d’Oracle Restart pour gérer l’arrêt et le…

 
Read More
Yann Neuhaus

Oracle Database 12c: PDBs not fully transportable yet

By | Database management | No Comments

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 this topic is that I am currently developing an advanced RMAN cloning procedure for 11g and this new 12c feature might make our life much easier in the future release. The second reason of choosing this…

 
Read More
Jérôme Witt

Data Pump in Oracle Database 12c: die wichtigsten Neuigkeiten

By | Database management | No Comments

Letztes Jahr hat Oracle CEO Larry Ellison während der Oracle OpenWorld in San Francisco ein neues Datenbank Release angekündigt, das nun endlich zur Verfügung steht. In diesem Blogbeitrag möchte ich einige der wichtigsten Data Pump-Neuigkeiten vorstellen. Eine komplette Übersicht der Features finden Sie in Oracles Dokument „Oracle Database Utilities“. Fangen wir an mit dem riesen Hype von Oracle 12c! Oracle 12c Pluggable Databases (PDB): wie soll ich mit diesem Feature umgehen? In Oracle Database 12c…

 
Read More
David Hueber

Oracle 12c Backup & Recovery: What’s new?

By | Database management | One Comment

After months of waiting, Oracle Database 12c is finally available. In this posting, I am going to provide a summary of the new features of Oracle 12c in terms Backup and Recovery. Pluggable, what else? For sure, the most remarkable change in this brand new version is the Pluggable Database or so called Multitenant Database concept, which is a huge change in the whole RDBMS architecture. So what does it offers in terms of Backup…

 
Read More
Pierre Sicot

Discovering Oracle database 12c targets (CDB, PDB) in Cloud Control 12c

By | Technology Survey | No Comments

In my consultant’s activity at dbi services, I had the opportunity to test the new databasion version Oracle 12c. As an Enterprise Manager Cloud Control 12c fan, when the 12.1.0.3.0 Oracle database plugin was made available, I decided to test the Cloud 12c behavior with the Oracle 12c database and also CDB and PDB (Container Database and Pluggable Database). Before installing the Oracle Database Plugin 12.1.0.3, the 12c databases are seen up but when we…

 
Read More
Yann Neuhaus

DOAG Konferenz 2012 – mein Fazit: wärmstens zu empfehlen!

By | Technology Survey | No Comments

Die DOAG Konferenz 2012 ist vorbei. Wie immer war sie sehr bereichernd! Wir von dbi services hatten dieses Jahr über drei Präsentationen die Gelegenheit, unser Wissen in den Bereichen Cloud Control 12c – Thema: Datenbank-Backup und Handling des Java-Diagnostic-Tools JVMD (Gérard Wisson) – sowie Linux Container (David Hueber) an die Teilnehmer weiterzureichen. dbi services hat ebenfalls seinen Beitrag zum Treffen der Schweizer Oracle User Group (SOUG) geleistet, einem unter anderem durch das Engagement unseres Partners…

 
Read More