A Journey of a Thousand Miles Begins with a Single Step

Change client session language in sqlplus

If you are working with Oracle you may experience unexpected behaviors considering your Oracle’s National Language Support (NLS). Some SQL statements to setup properly for your working session.

Read more

Create a new pluggable database in Oracle DB

Create (admin) user for new pdb. Set password expiration to none.

Read more

Drop pluggable databases in Oracle DB

Why use PDBs? In a multitenant environment, each customer has their own PDB which is isolated from other customers’ PDBs. A clean (domain) separation. This post covers how to get rid of one. A quick example how to drop PDBs (pluggable databases) in the multi-database architecture of Oracle DB (since v12c).

Read more

Create user in Oracle DB 12c

A new option for Oracle Database 12c, Oracle Multitenant delivers a new architecture that allows a multitenant container database (CDB) to hold many pluggable databases (PDB). An existing database can simply be adopted with no application changes required. Sadly some old sql scripts won’t work anymore. This post describes the basic changes.

Read more

Running a Heartbeat Service in RiskShield

RiskShield is a fraud detection and prevention software, which is highly configurable on the server components. I got the desire to provide a stateless service, that any monitoring solution can poll and check if the RiskShield server is still available. Following configuration was done on Version 4.34a. The configuration options are provided by the manufacturer the Inform Software and described in their manual. It is an easy and straightforward example to demonstrate the configuration capability e.g. RiskShield Decision Server.

Read more

Filter for incorrect behavior in RiskShield Server

The RiskShield Servers provide the capability to filter log messages, since log4j is under the hood. Especially in early stages, the INFO or DEBUG messages may produce too much “noise” to see the misconfiguration or problems the RiskShield Server is telling you. To filter only the log entries with incorrect content (WARN, ERROR, FATAL) you can use the show option to limit to these messages.

Read more

Monitor Elasticsearch in Docker with Monit

Running Elasticsearch as docker container is straightforward. If you don’t have a cluster manager like Kubernetes, monit can help you to keep track of the container lifecycle.

Read more

List dependency tree in Apache Maven

Do you ever run into the situation that a open source library uses a logging framework and you don’t know which one? If you use Apache Maven as build tool, the easiest solution is just to invoke mvn dependency:tree.

Read more

Get distinct field values in Elasticsearch

The aggregations framework helps provide aggregated data based on a search query. It is based on simple building blocks called aggregations, that can be composed in order to build complex summaries of the data. There are several types of aggregations. The cardinality aggregation is the exact match for distinct field values.

Read more