All articles

Wrong result with multitenant, dba_contraints and current_schema

By Franck Pachot . Multitenant architecture is not such a big change and this is why I recommend it when you start a project in 12c or if you upgrade to 12.2 - of course after thoroughly testing your application.

Documentum – RCS 7.3 – Issue with projections?

In the last two blogs I posted, I mentioned that I was working on silent installations with CS 7.3 (in HA). The “issue” (it’s more like a common mistake) I will describe in this blog is linked to the HA installation.

Documentum – RCS 7.3 – dm_server_config cannot contain dash

As mentioned in this blog, I was recently installing a new 7.3 P05 environment. Actually, this environment was in HA and it was the first silent installation of a(…)

Documentum – CS 7.3 – Issue with dmqdocbroker

Beginning of this month, I was building a new environment in 7.3 P05 (using silent installation but this isn’t relevant here) and I found a strange behaviour from the dmqdocbroker so I wanted to share that. You will see below(…)

Be careful when putting the Oracle ADR on xfs, or better 4K sector format drives

Today, after we did a fresh setup of a Grid Infrastructure cluster (12.1.0.2.170814) we faced two issues reported in the alert.log of the ASM instances (in fact you would see the same for the alert logs of any instance in(…)

SQL Saturday Toulouse 2017: SQL Server on Linux – Slide deck

#SQLSatToulouse was definitely a great event. Firstly, a big thanks to the organization team (@Guss and @Fredg_31) as well as all the sponsors and attendees (without whom this(…)

Active Data Guard services in Multitenant

By Franck Pachot . A database (or the CDB in multitenant) registers its name as the default service. When a standby database is on the same server, or same cluster, you have no problem because this database name is the(…)

12c Access Control Lists

By Franck Pachot . There is already enough information about the new simplified 12c way to define Access Control Lists, such as in oracle-base. I'm just posting my example here to show how it is easy.

Create constraints in your datawarehouse – why and how

By Franck Pachot . We still see some developers not declaring referential integrity constraints in datawarehouse databases because they think they don't need it (integrity of data has been validated by the ETL). Here is a small demo I did(…)

impdp content=metadata_only locks the stats

By Franck Pachot . With Oracle you can learn something every day. Today, preparing a migration to 12.2, I found all tables had locked statistics. I learned that it is the expected behavior since 10.2 when importing metadata_only including statistics,(…)