Oracle 12c

12cR2 Cross-container DML – insert into container()

By Franck Pachot . Multitenant has been introduced in 12.1.0.1 with the goal to share resources but isolate data. However, having all PDBs in the same root may be convenient to manipulate data in multiple PDBs. In the first patchset,(…)

Grid Infrastructure Installation on SLES 12 SP1

This week I needed to install Oracle Grid Infrastructure 12c release 1 in a SLES 12 SP1 environment. Everything worked fine until I ran the root.sh at the end of the installation. Here’s a quick description of the problem and(…)

Can you open PDB$SEED read write?

By Franck Pachot . If you are in multitenant, you probably already felt the desire to open the PDB$SEED in READ WRITE mode. Can you open PDB$SEED read write yourseld? Yes and No. Should you open PDB$SEED read write yourself?(…)

12c nologging and Data Guard

By Franck Pachot . The title sounds weird because Data Guard synchronisation is based on the redo stream, so it makes no sense to do nologging operations on the primary. And this is the reason why we set FORCE LOGGING(…)

12cR2 partial PDB backup

By Franck Pachot . I had a recent question about the following mention from the 12cR2 Multitenant book, about Partial PDB backups: . Here is an example in 12.2 with local undo to illustrate the(…)

Oracle 12.2 tables, indexes new features

The Oracle 12.2.0.1 version has some interesting new features  concerning tables or indexes. The first new feature is about the online table move. In 12.2 version Oracle offers now the possibility to move non-partitioned tables without blocking any DML operations. To(…)

12cR2 RMAN> REPAIR

By Franck Pachot . Do you know the RMAN Recovery advisor? It detects the problems, and then you: RMAN> list failure; RMAN> advise failure; RMAN> repair failure; You need to have a failure detected. You can run Health Check if(…)

Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c

By Franck Pachot . Data Pump is a powerful way to save data or metadata, move it, migrate, etc. Here is an example showing few new features in 12cR1 and 12cR2.

Service “696c6f76656d756c746974656e616e74” has 1 instance(s).

By Franck Pachot . Weird title, isn't it? That was my reaction when I did my first 'lsnrctl status' in 12.2: weird service name... If you have installed 12.2 multitenant, then you have probably seen this strange service name registered(…)

12cR2 DML monitoring and Statistics Advisor

By Franck Pachot . Monitoring DML to get an idea of the activity on our tables is not new. The number of insert/delete/update/truncate since last stats gathering is tracked automatically. The statistics gathering job use it to list and prioritize(…)