Oracle Team

random “ORA-01017: invalid username/password” in 12cR2

By Franck Pachot . Since 12cR2 is out, we give our 12c new feature workshop with hands-on exercises on 12.1 and 12.2 releases. When I gave it last month, I had a small problem when doing(…)

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,(…)

Upgrade to Oracle 12.2 with dbupgrade utility

By Mouhamadou Diaw Oracle 12.2 is released and we will have to upgrade. And in this blog we are going to talk about upgrading to oracle 12.2 using the dbupgrade utility. Of course the dbua tool is still available and(…)

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(…)

What is in a transportable tablespace dumpfile?

By Franck Pachot . On 31st of May in Düsseldorf, at DOAG Datenbank, I'll talk about transportable tablespaces and pluggable databases. Both methods are transporting data physically, the difference is in the transport of the metadata,(…)

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(…)

Migrating from oracle to postgresql with ora2pg

By Mouhamadou Diaw PostgreSQL is one of the most used Rdbms. In this blog we are going to talk about migrating from oracle to postgresql using ora2pg. A previous blog about this topic can be found(…)

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(…)