Oracle

Oracle docker image from docker store

By Franck Pachot . Did you notice that each time you want to download the Oracle binaries from the OTN website (for non-production usage) you have to click on the "Accept License Agreement"? This is because you have to agree(…)

DBVISIT from Oracle to Postgres

As I regularly work on Oracle and PostgreSQL, I decided to test the replication from Oracle to PostgreSQL using the Dbvisit Replicate tool. Dbivisit Replicate does not use Oracle logminer ot triggers but its own mining processes to(…)

WebLogic – SSO/Atn/Atz – How to enable debug logs

Let’s say that you have an application deployed on a WebLogic Server and that the SSO/Atn/Atz (SSO/Authentication/Authorization) isn’t working or throwing a 4xx error code like ‘401 – Unauthorized’ or ‘403 – Forbidden’. How would you be able to know(…)

firewalld rules for Veritas Infoscale 7.3 with Oracle

You might wonder, but yes, Veritas is still alive and there are customers that use it and are very happy with it. Recently we upgraded a large cluster from Veritas 5/RHEL5 to Veritas InfoScale 7.3/RHEL7 and I(…)

Unstructured vs. structured

By Franck Pachot . The title of this blog post was: "Tracing DBMS_RCVMAN for reclaimable archivelogs" until I started to write the conclusion... In a previous post I mentioned that there's a bug with archivelog deletion(…)

Quick history on database growth

By Franck Pachot . AWR collects segment statistics, and this can be used to quickly understand an abnormal database growth. Here is a script I use to get, from the AWR history, the segments that have grown by more than(…)

Database is more than persistence. It is shared. My thoughts about Microservice Database.

By Franck Pachot . The development teams often see the database as a 'persistence layer' only. And sometimes it is mentioned that the database is always the cause of the problems, especially when implementing continuous integration and trying to be(…)

Archivelog deletion policy on Data Guard configuration

By Franck Pachot . The deletion policy on a dataguard configuration should be: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; for the site where you don't backup. It can be the standby or the primary. and: CONFIGURE ARCHIVELOG(…)

VirtualBox 5.2 exports the VM to the Oracle Cloud

By Franck Pachot . The new release of Oracle VM VirtualBox (aka VirtualBox) is there with a new functionality to export a VM to the Oracle Cloud Compute (aka Oracle Cloud Infrastructure). That can be interesting(…)

Managing Oracle Big Data Cloud – CE with REST API

In this blog post, we will see how to manage Oracle Public Cloud Big Data service Compute Edition with REST API. Scheduling the start/stop/restart of a metered PaaS in the Oracle Cloud can be interesting for managing efficiently the consumption(…)