This PL/SQL script can be used to remove all objects of one ore more schemas. This might be used in preparation of an DataPump import. 0

Foglight is a tool to monitor and optimize servers and databases. In this post we are going to install a Foglight server on Windows 10. 0

PostgreSQL continues to be one of the most popular open-source database platforms for enterprise workloads, and the release of PostgreSQL 18 brings further improvements in performance, scalability and reliability. When deploying PostgreSQL in production environments, high availability and data protection are key considerations, making streaming replication one of the most important technologies to implement. In […]

This post shows how to setup a PXE server on Linux. In such a config clients can boot their OS over the network from the PXE server. 0

In this post we will install Oracle Data Integrator (ODI) 14.1.2 in a Linux VM. The steps can be used to quickly setup an environment. 0

This post shows how to install Oracle 23ai on a RedHat Enterprise 8.10 virtual machine. Grid Infrastructure and Database will be installed. 0

The following steps describe an unattended installation of Oracle Linux 8.10 with the minimal package selection on Virtualbox. 0

In this post we will upgrade the Oracle database from version 12.1 to 19c and apply the latest database Patch Set Update (PSU). 0

In this post we will show how to perform the base setup of a new ODI Integration Project. We will create sample data and replicate it. 0

In this post we are going to install Oracle E-Business Suite 12.2 on a RHEL 8 system. We will use Oracle Database 12.1 as the database. 0

This SQL Server Cheat Sheet provides a compact overview of commonly used SQL statements, functions and administration commands for developers and DBAs. Whether for quick lookup, troubleshooting or learning purposes, this reference guide is designed to make working with SQL Server faster and more efficient. 0

The following steps describe an unattended installation of Oracle Linux 9.5 on Virtualbox. The host system in my case is Windows 10. 0

This post describes the unattended installation of a Windows Server 2022 Virtual Machine in Oracle VirtualBox. 0

The following steps describe an unattended installation of RedHat Enterprise Linux 9.7 on VirtualBox. The host system in my case is Windows 10. 0

In this post we are going to install IBM Db2 11 on a Oracle Linux 9 server. Some basic administration commands are covered as well. 0

This post describes the mostly unattended installation of a 2 node Oracle Real Application Cluster 19c on Oracle Linux 9.5. 1

In this post I will demonstrate the use of multilingual semantic search in Oracle AI Database 26ai. 0

Installing a modern Oracle application stack has become significantly more interesting with the introduction of the new Oracle Database AI Database 26ai release and the latest generation of Oracle development tools. Combining Oracle APEX 26.1, ORDS 26.1, GraalVM 21, GraalJS and Apache Tomcat 9 on Oracle Linux 9.7 provides a powerful and flexible platform for […]

In this post we use the AutoREST driver from ODI to load data from the Wikipedia REST API into a Oracle Database table 1

The following steps describe an unattended installation of RedHat Enterprise Linux 10.1 on VirtualBox. The host system in my case is Windows 10. 0

These steps describe a unattended installation of a RHEL 8.10 VM. The host system in my case is Windows 10. 0

In this post we are going to perform a basic installation of Microsoft SQL Server 2022 Developer including additional Management Tools. 0

The following steps show how to install a test system of SAP NetWeaver 7.52 SP04 on RedHat Enterprise Linux 8 (running as a VirtualBox guest). SAP Sybase ASE 16.0.2 is used as the database. SAP GUI will be installed on a client machine running Windows 10 and will be used to access the SAP NetWeaver […]

This describes how to install Zabbix on RedHat Enterprise Linux 8.10. Zabbix is used to monitor servers and notify in case of failures. 0

This post shows how to install the current version (2.6) of the RedHat Ansible Automation Platform (AAP) on Linux. 0

The following steps can be used to install the latest Database and Grid Infrastructure Release Update (RU) patches to a running RAC Cluster. We will use the Out of Place method which means we create a new Oracle Home, apply the patches to it and switch to this new Oracle Home. 0

This blog post contains some useful commands and tasks for the lifecycle of Oracle Data Integrator. They don’t fit in any other post so I collect them here. 0

This PL/SQL script can be used to find issues with Oracle Views. For example it shows data type conversions being done that could result in an sub optimal plan. 0

This post describes the mostly unattended installation of a 2 node Oracle Real Application Cluster 19c on Oracle Linux 9.5. 1

The following steps describe an unattended installation of Oracle Linux 9.5 on Virtualbox. The host system in my case is Windows 10. 0

This blog post shows how to install Oracle GoldenGate Veridata 23c on two Virtual Maschines running Oracle Database 19c on RedHat Enterprise Linux 8.10. On the first VM we install the Veridata 23c server and deploy an Veridata Agent. After that we install the Agent only software on the second VM and deploy the Veridata […]

This blog post describes the steps to install PostgreSQL and pgAdmin. We will install PostgreSQL version 17 running on a RedHat Enterprise Linux 8.10 VM and pgAdmin version 4 running on Windows 10 and on RHEL 8. The installation is very simple and straightforward. 0

In this post we use the AutoREST driver from ODI to load data from the Wikipedia REST API into a Oracle Database table 1

In this post we will upgrade the Oracle database from version 12.1 to 19c and apply the latest database Patch Set Update (PSU). 0

This blog post contains some random Oracle commands or SQL statements to have them at hand when using Oracle and AI. 0

The following steps describe an unattended installation of RedHat Enterprise Linux 10.1 on VirtualBox. The host system in my case is Windows 10. 0

This post summarizes the most useful SQLcl Liquibase commands and how they can be used. The output of the commands are shown as well. 0

It is considered good practice to delete unneeded patches from an ORACLE_HOME in order to save space and reduce the time to install new patches. I made some tests to see the effects of that. More information about the removal of inactive patches can be found in Oracle Doc ID 2942102.1 . 0

The following steps can be used to install the latest Database and Grid Infrastructure Release Update (RU) patches to a running RAC Cluster. We will use the Out of Place method which means we create a new Oracle Home, apply the patches to it and switch to this new Oracle Home. 0

This post shows how to install Oracle 23ai on a RedHat Enterprise 8.10 virtual machine. Grid Infrastructure and Database will be installed. 0

In this post we will upgrade the Oracle database from version 12.1 to 19c and apply the latest database Patch Set Update (PSU). 0

In this post we will install IBM Informix 12.10 FC16 (Developer Edition) on Linux. This is a full featured free of charge Developer version. 0

This post describes how to setup Oracle Grid Infrastructure 19c (Oracle ASM and Oracle Restart) and Oracle Database 19c including a Database orcl on RHEL 8 running as a Oracle VirtualBox guest on Windows. 0

This PL/SQL script can be used to remove all objects of one ore more schemas. This might be used in preparation of an DataPump import. 0

In this blog we will perform all steps needed to install SAP HANA 2.0, express edition and Applications on a RedHat Enterprise Linux 8.10 VM. We do everything from downloading the software until we are able to login to the system and use it. 0

This post shows a way to view web pages that contain shockwave flash content. Use with caution since flash content is considered unsafe. 0

This PL/SQL script can be used to find issues with Oracle Views. For example it shows data type conversions being done that could result in an sub optimal plan. 0

This post describes how to setup Oracle Grid Infrastructure 19c (Oracle ASM and Oracle Restart) and Oracle Database 19c including a Database orcl on RHEL 8 running as a Oracle VirtualBox guest on Windows. 0

In this post we are going to install Oracle E-Business Suite 12.2 on a RHEL 8 system. We will use Oracle Database 12.1 as the database. 0

PostgreSQL High Availability setup covers the installation and basic administration of PostgreSQL 17.2 in a pacemaker cluster on two VirtualBox VMs. 0