Oracle Team

What Benefit You Get From The Cloud For Your Business?

Microsoft, Amazon, Google and Oracle offer infrastructure services whose names change, but the concepts remain the same. It may be that you are interested in the cloud too, but it's still not clear because you find(…)

Oracle 19C : Exporting and Importing Broker Configuration

By Mouhamadou Diaw Up to Oracle 19c, there was no automatic way to backup the configuration of the broker. One solution was to manually copy all executed instructions in a file. With Oracle 19c, there is now the possibility(…)

Oracle 19C : Dynamic Change of Fast-Start Failover Target

By Mouhamadou Diaw Oracle 19C is now available on premise. There are lot of new features. One for the Data Guard Broker is that now we can dynamically change the fast-start failover target to a specified member in the list(…)

Unable to add physical standby database

Recently I tried to setup some new physical standby databases and got the following strange message: DGMGRL> ADD DATABASE "XXXX" as connect identifier is "XXXX" maintained as physical; Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be(…)

Oracle 18c Grid Infrastructure on Windows Server

By Mouhamadou Diaw Oracle Grid Infrastucture can be installed on Windows platform. The steps are the same that on other platforms. In this blog we are going to install Oracle GI 18c on Windows 2016.I have two disks on my(…)

How to stop Documentum processes in a docker container, and more (part I)

Ideally, but not mandatorily, the management of Documentum processes is performed at the service level, e.g. by systemd. In my blog here, I showed how to configure init files for Documentum under(…)

How to stop Documentum processes in a docker container, and more (part II)

ok, Ok, OK, and the docker part ? In a minute. In part I of this 2-part article, we showed how traps(…)

Cause for looping sssd

In RedHat Enterprise Linux 7, the sssd daemons can connect to active directory servers. Default behaviour is to update DNS entries dynamically. If a statical DNS entry already exists this can lead to a CPU consuming sssd_nss daemon.

When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified

Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show(…)

SQL Tuning – Mix NULL / NOT NULL Values

One of the difficulty when writing a SQL query (static SQL) is to have in the same Where Clause different conditions handling Null Values and Not Null Values for a predica. Let’s me explain you by an example : Users(…)