Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Franck Pachot

Introduction to databases for {Power.Coders} with MySQL

By | Database Administration & Monitoring, Oracle | No Comments

This week I took some days off to do something related to my job but a bit different. I’ve given a course on Databases and SQL. But not for my usual customers. And not with the database I know the best. So, it is still in a domain that I know, but out of my comfort zone. And this is something that we should do more often because it gives a little apprehension and a…

 
Read More
Elisa Usai

MySQL 8.0 – Roles are finally there

By | Database Administration & Monitoring | No Comments

Roles have been existing on many RDBMS for a long time by now. Starting from version 8.0, this functionality is finally there for MySQL. The most important advantage is to define only once a role that includes a “set of permissions”, then assign it to each user, avoiding wasting time declaring them individually. In MySQL, a role can be created like a user, but without the “identified by” clause and without login: mysqld2-(root@localhost) [(none)]> CREATE…

 
Read More
Michael Hein

utl_dbws causes ORA-29532 and bad_record_mac

By | Database Administration & Monitoring | No Comments

After installing OJVM patch set update APR-2017 on a 11.2.0.4 database with PSU APR-2017 installed, first call of utl_dbws package was successful, but after a while utl_dbws calls failed always with ORA-29532 and bad_record_mac. All Java objects remained valid. Also after trying procedures described in MOS document 2314363.1 utl_dbws worked first time, after that it always failed. We could observe that after a while after restarting database m000 process ran and tried to recompile Java…

 
Read More
David Barbarin

Dealing with automatic restart and SQL Docker containers

By | Database Administration & Monitoring | No Comments

A couple of weeks ago, a customer asked me how to restart containers automatically after a reboot of the underlying host. In his context, it was not an insignificant question because some containers are concerned by SQL Server databases and he wanted to stay relaxed as long as possible even after a maintenance of the Linux host by sysadmins. The concerned (DEV) environment doesn’t include container orchestration like Swarm or Kubernetes. The interesting point is…

 
Read More
Mouhamadou Diaw

Migrating from ASMLIB to ASMFD

By | Database Administration & Monitoring | No Comments

Before Oracle 12.1 the methods used to configure ASM were • udev • asmlib Oracle 12.1 comes with a new method called Oracle ASM Filter Driver (Oracle ASMFD). In Oracle documentation we can find following: Oracle ASM Filter Driver (Oracle ASMFD) is a kernel module that resides in the I/O path of the Oracle ASM disks. Oracle ASM uses the filter driver to validate write I/O requests to Oracle ASM disks. The Oracle ASMFD simplifies…

 
Read More
Nicolas Penot

How to fix your own SQL plan in Oracle ?

By | Database Administration & Monitoring, Database management, Development & Performance | No Comments

There is time when you have build an SQL plan and then you want to fix it for all next executions of the query by your application. In this post I show how fix a plan you have created by yourself. First we need to identified the query SQL> select /* INDEX_ACCESS */ line_item_id, product_id, unit_price, quantity from ORDER_ITEMS where order_id = 234098 ; LINE_ITEM_ID PRODUCT_ID UNIT_PRICE QUANTITY ———— ———- ———- ———- 1 414 851…

 
Read More
David Barbarin

Introducing SQL managed instances on Azure

By | Database Administration & Monitoring | No Comments

I never wrote about data platform solutions on Azure so far. The fact is in Switzerland we’re definitely late about the Cloud adoption and Azure data platform solutions. There are different reasons that are more or less valid but I don’t want to contribute to any debate here. In any case the last announcements in this field with Azure data centers in Switzerland could encourage customers to reconsider this topic in the near future. Don’t…

 
Read More
Franck Pachot

Change Data Capture from Oracle with StreamSets Data Collector

By | Business Intelligence, Database Administration & Monitoring, Oracle | No Comments

With this trend of CQRS architectures where the transactions are streamed to a bunch of heterogenous eventually consistent polyglot-persistence microservices, logical replication and Change Data Capture becomes an important component, already at the architecture design phase. This is good for existing products vendors such as Oracle GoldenGate (which must be licensed even to use only the CDC part in the Oracle Database as Streams is going to be desupported) or Dbvisit replicate to Kafka. But…

 
Read More