Infrastructure at your Service

Tag

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

Oracle Team

OCM 12c preparation: Transportable Tablespaces

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . I use transportable tablespaces a lot since 8i, here are just a few examples. Same disclaimer here as in the first post of the series: don’t expect to get those posts close to what you will have at the exam, but they cover important points that matches the exam topics. Documentation Information about the exam says: Create a plugged-in tablespace by using the transportable tablespace feature. this is the TTS feature…

Read More
Oracle Team

OCM 12c preparation: Manage PDB

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . Let’s see the different ways to create a PDB, with different tools. Same disclaimer here as in the first post of the series: don’t expect to get those posts close to what you will have at the exam, but they cover important points that matches the exam topics. Documentation Information about the exam says: Be prepared to use the non-searchable documentation during the exam, to help you with correct syntax. Documentation…

Read More
Oracle Team

OCM 12c preparation: Create CDB in command line

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . This post starts a series about things I wrote while preparing the OCM 12c upgrade exam. Everything in those posts are written before taking the exam – so don’t expect any clue about the exam here. It’s based only on the exam topics, and only those points I wanted to brush up, so don’t expect it to be a comprehensive list of points to know for the exam. Let’s start by…

Read More
Oracle Team

OOW15 – Day 1- No fog on Golden Gate brige but Cloud everywhere at Moscone center

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . Here are the two sides of the Oracle Open World: marketing and community. Of course Oracle organizes that big event for marketing: show the future products and explain how they are better than all competitors ones. But it’s not only that. There is a community around Oracle, of users, partners, technologists, speakers, authors, etc. And Oracle Open World is also the place to meet.

Read More
Oracle Team

Multitenant vs. schema based consolidation

By | Database management, Oracle | 4 Comments

By Franck Pachot . If you want to install multiple instances of a software, for example you host the ERP for several companies or subsidiaries, you have 3 solutions: have one database and multiple schema have multiple databases have one database and multiple pluggable databases Of course, this is exactly the reason for pluggable databases: multitenant. You have good isolation but still share resources. A lot of reasons have been given why multiple schema –…

Read More
Oracle Team

12c: shutdown abort a PDB?

By | Database management, Oracle | 3 Comments

By Franck Pachot . Can we shutdown abort a PDB? Let’s try: SQL> show con_id CON_ID —————————— 3SQL> shutdown abort; Pluggable Database closed. But is it really a shutdown abort? The shutdown abort we know in non-CDB – or in a CDB from CDB$ROOT – is used when the instance cannot checkpoint before closing the file. It leaves the files fuzzy. And shutdown abort crashes the instance – loosing all changes made in buffer cache…

Read More
Oracle Team

Is CDB stable after one patchset and two PSU?

By | Database management, Oracle | 7 Comments

By Franck Pachot . There has been the announce that non-CDB is deprecated, and the reaction that CDB is not yet stable. Well. Let’s talk about the major issue I’ve encountered. Multitenant is there for consolidation. What is the major requirement of consolidation? It’s availability. If you put all your databases into one server and managed by one instance, then you don’t expect a failure. When 12c was out (and even earlier as we are…

Read More
Oracle Team

Oracle multitenant dictionary: rowcache

By | Database management, Oracle | No Comments

By Franck Pachot . I’ve not finished with my investigation on 12c multitenant dictionary. Here, I’m checking how metadata links are managed by the dictionary cache (aka rowcache). As I did previously, I’ll create a metadata link function in my lab environment (this is not for production. For the moment metadata/object links are supported only for oracle objects). SQL> connect / as sysdba Connected. SQL> create or replace function DEMO_MDL_FUNCTION sharing=metadata 2 return varchar2 as…

Read More