Database management

Copy big dumpfiles between firewall zones

If you have to transfer a big Oracle DataPump export (dumpfiles) from one firewall zone to another, it is often not possible to transfer it directly from the source- to the destination-host. Instead, you have to transfer it to(…)

Name resolution of Oracle

This blog post is a follow-up of TNS_ADMIN – which *.ora files Oracle will use. There, the main focus was to find out if a running database instance will use a TNS_ADMIN environment or the binary(…)

tnsping with Oracle instant-client?

The instant client For an application server that connects to Oracle, you probably would not like to install gigabytes of a full Oracle client software? For that, Oracle offers the so-called “Instant Client” you can download for free at(…)

Oracle and btrfs snapshots

In my last blog post Snapshots with VirtualBox and btrfs we have seen some possibilities of btrfs snapshots. In this blog post we will see how we can use btrfs snapshots in combination with an(…)

OCI-managed MCP Server: Troubleshooting ORA-12170 errors with Private Endpoint connectivity

We recently worked on a customer proof of concept (PoC) involving Oracle databases hosted in Oracle Cloud Infrastructure (OCI) within private VCN subnets. The goal was to evaluate OCI-managed MCP servers and determine whether extending their available toolsets(…)

SQL Server: Disabling FileTable/FileStream on an AlwaysOn high-availability instance

Contexte A customer recently asked me to disable FileTable/FileStream on their instance because the databases no longer use it, and to ensure that this is indeed the case.The aim is to migrate to a new architecture without FileTable/FileStream in(…)

Archiving 5 TB from Oracle into SQL Server: views, indexes and compression (part 2)

Translating 4,000 Oracle views, rebuilding indexes offline on Standard Edition, and compressing clustered index to save 1T.

Archiving 5 TB from Oracle into SQL Server: a migration logbook (part 1)

Loading 5 TB from Oracle into SQL Server with SSMA: type overflows, heaps, and the settings that took 788 rows/s to 42,170.

Oracle LDAP Timeouts

Introduction, Setup You are using 2 or more LDAP servers for Oracle name resolution to be highly available? Do you kown what happens if an ldap server is down or not reachable? You probably expect that it tries the(…)

Setup an LDAP server for Oracle naming on Enterprise Linux 9

Introduction To centralise Oracle naming resolution, you can use an LDAP server. You can use the commercial products from Oracle like Oracle Internet Directory (OID) or Oracle Universal Directory (OUD). Alternatively, you can also use OpenLDAP from your Linux(…)