What is Apache Drill and how to setup your Proof-of-Concept

Sam Vruggink 2

Apache Drill is a schema-free SQL query engine. Drill supports a variety of NoSQL databases and file systems, including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS and local files. A single query can join data from multiple datastores. For example, you can […]

InfluxDB V2.0 – Stack Implementation Proof of Concept

Sam Vruggink 2

This blogpost will give you detailed instructions and information regarding the InfluxDB stack. Since February 2019 InfluxDB now consists not only the database itself, but also Telegraf, Chronograf and Kapacitor. Later you’ll read about what every part of the stack does. 18-2-2019: Living on the bloody edge, do not run […]

Enterprise Manager Convert to Cluster Database (RAC) fails without showing errors at Pre Configuration phase

Johan Buijser

Oracle Enterprise Manager Cloud Control 13c provides a wizard to convert a single-instance database to an Oracle RAC database. This requires the Oracle Database Lifecycle Management Pack for Enterprise Manager Cloud Control. When converting the database to a cluster database, after proving all the required details in the wizard,  a […]

Enterprise Manager DataGuard Add Standby Database fails without showing errors at Destination Preparation phase

Johan Buijser

Oracle Enterprise Manager Cloud Control 13c provides the Add Standby Database wizard to create a broker configuration that includes a primary database and one or more standby database. This requires the Oracle Database Lifecycle Management Pack for Enterprise Manager Cloud Control. When adding a Standby Database, after proving all the […]

InfluxDB for time series data

Gertjan van het Hof 2

In this small blog post I will talk about when to use a time series database and why to use InfluxDB for this. But first of all I need to explain what time series data is. Time series data is data where the time aspect is the most important characteristic. […]

ETL using Oracle DBMS_HS_PASSTHROUGH and SQL Server

Harry Dragstra

While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot be avoided. By using DBMS_HS_PASSTHROUGH for data extraction the 2 other ETL processes (transformation and load) can be configured and administered with more flexibility, providing an almost acceptable level of […]

How About Oracle Database 12c Threaded_Execution

Harry Dragstra

THREADED_EXECUTION Threaded_Execution is an Oracle Database 12c feature aiming to reduce the number of Oracle processes on LINUX. After setting parameter THREADED_EXECUTION on TRUE and a database bounce, most of the background processes are threads within just 6 Oracle processes, where more than 60 processes existed before the bounce. And […]

Oracle 12c STIG Password Generator in PL/SQL

Harry Dragstra 1

Creating or modifying an Oracle Database user password can be done by using any standard password generator you can find on the WEB. But I wanted a password to comply to “ora12c_strong_verify_function”, and this isn’t as easy to generate as you might expect. Though most generators provide options to include […]

Node.js and Oracle NoSQL Database

Maarten Smeets

Oracle NoSQL Database is an interesting option to consider when you want a schemaless, fast, scale-able database which can provide relaxed (eventual) consistency. Oracle provides a Node.js driver for this database. In this blog I’ll describe how to install Oracle NoSQL database and how to connect to it from a […]

Oracle Database 11g: Virtual columns

Views in the Oracle database have several uses. You can use them to provide a view of data in different tables as a single object to query. You can use views to achieve a virtualization layer. Also views can be used to provide a user specific view of data. Implementing […]

Oracle licenses needed while monitoring your (non-)Oracle environment with OEM

Job Oprel 3

With Oracle Enterprise Manager you are able to monitor an Oracle environment as well as a non-Oracle environment, like Microsoft’s SQL Server. You are also able to exchange notifications between Oracle Enterprise Manager and e.g. Microsoft’s SCOM, and there’s a choice how to monitor this heterogeneous environment. One of the […]

How-to set the current database schema of an application using a global context

Harry Dragstra

Question: We have customers who want to work with different database schemas and we want to determine dynamically – depending on a choice during or after login – which database schema the application in a given session should use. Is it possible to set this up in the database? Answer: […]

SQL*Plus / SQL*Net Dead Connection Detection

Patrick Roozen

Recently I came across the situation where I knew for a fact that my sessions to the database were dead because I pulled the power plug out of my application server for a failover test. But the sessions stayed visible in the database and kept their locks therefore the failover failed. Now how […]