Oracle Team

New release model for JUL17 (or Oracle 17.3): RU and RUR

By Franck Pachot . Updated June 5th When reading about new version numbering in SQL Developer, I took the risk to change the title and guess the future version number for Oracle Database: Oracle 17.3 for(…)

Oracle 12cR2: exchange partition deferred invalidation

By Franck Pachot . In a previous post I introduced the new 12cR2 feature where some DDL operations can use the same rolling invalidation than what is done with dbms_stats. On tables, DDL deferred invalidation is(…)

Which privilege for CREATE PLUGGABLE DATABASE from DB LINK?

By Franck Pachot . When cloning a PDB from a remote CDB you need to define a database link to be used in the CREATE PLUGGABLE DATABASE … FROM …@… command. The documentation is not completely clear about the(…)

OUD – Oracle Unified Directory 11.1.2.3, How to change the Java version of OUD 11.1.2.3 with Weblogic and ODSM

By William Sescu In this blog, I would like to show how to change the Java version used by OUD and WebLogic, in case you use the ODSM. The OUD (Oracle Unified Directory) is written purely in Java, not like(…)

12cR2 needs to connect with password for Cross-PDB DML

By Franck Pachot . In a previous post, I explained that Cross-PDB DML, executing an update/delete/insert with the CONTAINERS() clause, seems to be implemented with implicit database links. Connecting through a database link requires a password(…)

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

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

PostgreSQL 10 Beta 1: Logical replication

By Mouhamadou Diaw In a previous blog we talked about partition in postgreSQL 10 Beta 1. In this article we will talk about another new feature logical replication. Yes in postgreSQL 10, logical replication is(…)

History of Upgrading 9 Tb PostgreSQL database

Mouhamadou Diaw In this blog I am going share a history of PostgreSQL migration and upgrade from 9.2 to 9.6. Let me first explain the context We have a PostgreSQL environment with following characteristics. Note that real database name,(…)

Oracle Linux 7 – How to audit changes to a trusted file such as /etc/passwd or /etc/shadow

Linux auditing is quite powerful and a lot of different use cases might be handled via the auditing framework. However, in this blog I would like to show you, how to audit changes on trusted files, like /etc/passwd or /etc/shadow.

PostgreSQL 10 Beta 1: Native Table Partitioning

By Mouhamadou Diaw The Beta 1 version PostgreSQL 10 is now released with lot of new features. One of the most popular is the native support of table partitioning. In this blog we are going to see how we(…)