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

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

How to extract sql statements with awk

A common problem is to extract sql statements out of a sql file e.g. produced by full metadata impdp. Often these files are too big to be edited with vi. Following statement extracts all sql statements with “CREATE MATERIALIZED(…)

PostgreSQL 12: New option –exclude-database for pg_dumpall

By Mouhamadou Diaw Up to PostgreSQL 11 pg_dump all was used to dump all PostgreSQL databases of a cluster into one script file. The script file then contains SQL commands that can be used as input to psql to restore(…)