Database Administration & Monitoring

Configure the Resource Manager with SQL Developer

By Franck Pachot . Yes, the topics for the OCM 12c upgrade are online and I'm already looking at the topics. I'm talking about the 'Configure the Resource Manager' one here. Configuring Resource Manager in commandline(…)

DataGuard broker properties – Part II: log shipping parameters

By Franck Pachot . In the part I we have seen the properties that are imported when you add a database to the configuration, and which are then managed by the(…)

DataGuard broker properties – Part I: imported parameters

By Franck Pachot . When you are using the DataGuard Broker, you should always use the broker (with DGMGRL or OEM) to change the parameters that are managed, rather than changing them with ALTER SYSTEM. But do you know which(…)

Connecting your PostgreSQL instance to an Oracle database – The PostgreSQL 9.5 way

As you might know PostgreSQL 9.5 is currently in alpha 2. One of the new features will be the possibility to import foreign schemas. Having this it is no longer required to create all the foreign(…)

MySQL FATAL: error 1040: Too many connections & 1135 Can’t create a new thread

Hi folks, Some of you probably already got error 1040 by playing with sysbench for instance and multiplying the number of MySQL threads. Documentation and blogs usually simply state that you have to increase the number of max_connections and the(…)

Connecting your PostgreSQL instance to an Oracle database

For integrating data from other systems PostgreSQL has the concept of foreign data wrappers. Many of these exist for different types of systems. In this post I’ll look into how you may connect PostgreSQL to Oracle. The(…)

ACFS 12.1.0.2 on Oracle Linux 7.1

Recently we wanted to create an ACFS filesystem on a brand new 12.1.0.2 GI installation on Oracle Linux 7.1. According to the documentation this should not be an issue as “Oracle Linux 7 with the Unbreakable Enterprise kernel:(…)

Testing the just released PostgreSQL 9.5 Alpha in a docker container

On the 2cnd of July the PostgreSQL Global Development Group released an alpha version of the upcoming PostgreSQL 9.5. The same day, Josh Berkus, another of those PostgreSQL core team members released a docker image for(…)

Indexing for like/similarity operations

Indexing queries for like/similarity conditions is not that easy with the usual index types. The only option you have with btree indexes (especially if the wild-card is at the beginning of the filter) is to create a partial(…)

Quickly create a hundred databases and users

Do you need a hundred databases and users for training etc. in PostgreSQL? Just a few lines of code: [postgres8@oel7 data]$ cat create_databases.sh #!/bin/bash NUMOFDBS=100 for i in `seq ${NUMOFDBS}`; do psql -q -c "create user u${i}(…)