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