All articles

Oracle 12cR2 – How to Setup DataGuard observer with Oracle Wallets

By William Sescu I am not a big fan of having passwords in clear text laying around. This applies not only to application servers, but also for my Data Guard observer. I do have a script for starting the observer(…)

MS Cloud Summit Paris 2017

Une nouvelle année commence et 2017 devrait être un bon cru dans le domaine de la base donnée notamment en prédiction des effets d’annonces faites par Microsoft cette fin d’année 2016. En effet, il a été notamment été question de la prochaine(…)

IT-Tage 2016 Informatik aktuell: feedback

Today, to finish the year, I post a brief personal impression of the IT-Tage 2016 in Frankfurt at the Hotel Maritim, where I was also be a speaker. I presented 2 sessions on SQL Server: “SQL Server Errorlog(…)

Migrating your existing availability group infrastructure to 2016

Have you already a plan to migrate your old SQL Server 2012 availability group infrastructure to windows 2016 and SQL Server 2016? In a previous post, I talked about distributed availability groups and cross-cluster migration scenarios(…)

Can I do it with PostgreSQL? – 8 – Transportable tablespaces

My colleague Franck posted a comment to one of my last "Can I do it with PostgreSQL" blog posts. The comment he posted is: "Here is an idea for a future “Can I do(…)

SQL Plan Directives in 12cR2. Behavior is different than in 12cR1.

During the Frankfurter IT Tage I provided a presentation about SQL Plan Directives and how to reproduce a testcase in a test environment for a plan with used SQL Plan Directives (SPD). In that context I did a couple of(…)

Documentum story – Add the Java urandom inside the wlst.sh script to improve the performance of all WLST sessions

WebLogicServer takes a long time (e.g. over 15 minutes) to startup. Can the performance be improved? Using /dev/urandom option in the Weblogic Java Virtual Machine parameters from startup script, can be the solution. In fact, /dev/random is a(…)

Oracle 12cR2 – DataGuard and TCP.VALID_NODE_CHECKING

By William Sescu Security is a quite important topic, especially when running Oracle in the cloud. To make your DataGuard a little bit more secure, you can enable the TCP.VALIDNODE_CHECKING feature. I call it SQL*Net Firewall. Enabling the SQL*Net Firewall(…)

Documentum story – How to avoid “DFC_FILE_LOCK_ACQUIRE_WARN” messages in Java Method Server (jms) LOG

After upgrading from 6.7.x to 7.2, the following warning message is logged in JMS log files: com.documentum.fc.common.DfNewInterprocessLockImpl – [DFC_FILE_LOCK_ACQUIRE_WARN] Failed to acquire lock proceeding ahead with no lock java.nio.channels.OverlappingFileLockException at sun.nio.ch.SharedFileLockTable.checkList FileLockTable.java:255) By default ACS and ServerApp dfc.properties are pointing(…)

Oracle 12cR2: AWR views in multitenant

By Franck Pachot . In a previous post I explained how the AWR views have changed between 12.1.0.1 and 12.1.0.2 and now in 12.2.0.1 they have changed again. This is a good illustration of multitenant object(…)