Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Grégory Steulet

Oracle Open World 2018 D1: Larry Ellison keynote Cloud Gen2

By | Database Administration & Monitoring | No Comments

Today (23.10.2018) it was the first time I attended to a Keynote from Larry Ellison and I haven’t been disappointed. Not because of technical information or about true facts and figures but simply because of his charism and Oracle capability to transform a keynote in a real show. Whatever he is speaking about and whatever if it’s true or not, I’ve to admit that it was really distracting and funny. As expected during this keynote,…

Read More
Mouhamadou Diaw

Oracle OpenWorld 2018: Day 0

By | Database Administration & Monitoring | No Comments

Today was the day 0 for the oracle Openworld 2018. The event is officially not started but there were many nice entertainments to discover and enjoy San Francisco. The one Gregory Steulet (CFO of dbi services) and myself participated was the bike ride organized by Bryn Llewellyn who is the PL/SQL Product Manager. There were also Mike Dietrich (Master Product Manager) ,Franck Pachot (Oracle Master 12c and ACE Director) and many other people After renting…

Read More
Grégory Steulet

Oracle Open World 2018 D-1

By | Database Administration & Monitoring | No Comments

I woke up this morning (20.10.2018) knowing that this day will be a very long day. Indeed today my Colleague Mouhamadou and me traveled to San Francisco in order to attend to the Oracle Open World (OOW). I travelled from Delémont to Zurich, meaning about 1h30 and then I caught my flight from Zurich at 13:10 (GMT+2) to land in San Francisco about 12 hours laters at 16h10 (GMT-7). Of course when you arrive on…

Read More
Pierre Sicot

Schema only account with Oracle 18.3

By | Database Administration & Monitoring | No Comments

With Oracle 18.3, we have the possibility to create schemas without a password. Effectively in a perfect world, we should not be able to connect to application schemas. For security reasons it is a good thing that nobody can connect directly to the application schema. A good way is to use proxy connections, in fact connect as app_user but using the psi_user password for example: Let’s create a user named app_user: SQL> connect sys@pdb as…

Read More
Daniel Westermann

Inheriting super user privileges over a role automatically in PostgreSQL

By | Database Administration & Monitoring | No Comments

In a recent project at a customer where we synchronize the users and group out of Active Directory we hit a little issue I was not aware of before. Suppose you have created a role in PostgreSQL, you made that role a superuser and then granted that role to another role. What happens when you login using the other role? Will you have the super user privileges by default? Sounds confusing, I know, so lets…

Read More
Lazhar Felahi

Where come from Oracle CMP$ tables and how to delete them ?

By | Database Administration & Monitoring | No Comments

Regarding the following “MOS Note Is Table SCHEMA.CMP4$222224 Or Similar Related To Compression Advisor? (Doc ID 1606356.1)”, we know that since Oracle 11.2.0.4 BP1 or Higher, due to the failure of Compression Advisor some tables with names that include “CMP”, created “temporary – the time the process is running” by Compression Advisor process (ie CMP4$23590) are not removed from the database as that should be the case. How theses tables are created ? How to…

Read More
Daniel Westermann

Getting started with Red Hat Satellite – Initial configuration

By | Database Administration & Monitoring | No Comments

In the last post it was all about the Installation of Red Hat Satellite and the components that are used under the hood. In this post it is about doing the initial configuration so that packages can be synchronized from the Red Hat content network and subscriptions are available to be consumed by clients. This requires some initial tasks to be done in the Satellite itself but also in the Red Hat portal where you…

Read More
Daniel Westermann

Getting started with Red Hat Satellite – Installation

By | Database Administration & Monitoring | No Comments

This is the start of a series of posts I wanted to write for a long time: Getting started with Red Hat Satellite. Just in case you don’t know what it is, this statement from the official Red Hat website summarizes it quite well: “As your Red Hat® environment continues to grow, so does the need to manage it to a high standard of quality. Red Hat Satellite is an infrastructure management product specifically designed…

Read More
Petre Radut

How to migrate Grid Infrastructure from release 12c to release 18c

By | Application integration & Middleware, Database Administration & Monitoring, Database management, Oracle | No Comments

Oracle Clusterware 18c builds on this innovative technology by further enhancing support for larger multi-cluster environments and improving the overall ease of use. Oracle Clusterware is leveraged in the cloud in order to provide enterprise-class resiliency where required and dynamic as well as online allocation of compute resources where needed, when needed. Oracle Grid Infrastructure provides the necessary components to manage high availability (HA) for any business critical application. HA in consolidated environments is no…

Read More
Joël Cattin

From Oracle to Postgres with the EDB Postgres Migration Portal

By | Database Administration & Monitoring, Database management, Postgres | No Comments

EnterpriseDB is a valuable actor in PostgreSQL’s world. In addition to provide support, they also deliver very useful tools to manage easily your Postgres environments. Among these we can mention EDB Enterprise Manager, EDB Backup & Recovery Tool, EDB Failover Manager, aso… With this post I will present one of the last in the family, EDB Postgres Migration Portal, a helpful tool to migrate from Oracle to Postgres. To acces to the Portal, use your…

Read More