Oracle

OCI: Automate your Oracle Cloud Database software releases deployment (db-home)

As part of a very exciting project around Oracle Exadata Cloud @ Customer (aka. ExaCC) technology, we wanted to rollout in an automated manner the database software aka. ORACLE_HOME on ExaCC database clusters (aka. VM cluster). However, we rapidly(…)

Database Check for a one-to-one Migration with OMrun

Procedure to check a one-to-one migration between different database types autogenerated and generically with OMrun.

Building a transportable Oracle Sandbox environment for an Apple Silicon Laptop (MacBook with M1- or M2-processor)

Since Apple released their Apple Silicon Laptops based on the ARM processor architecture, it became difficult for Consultants with such a device to run their Oracle Sandbox environment, because the main Oracle products are running on the Intel architecture.

ODA: Check your DB homes before applying server patch

Introduction Patching an Oracle Database Appliance is divided in 4 main steps with 4 odacli commands in this order: odacli update-dcs[admin|components|agent]: the easiest part dedicated to update the ODA tooling, including odacli itself odacli update-server: the most complex part.

Oracle Database monitoring with Zabbix

Zabbix comes with an Oracle Database monitoring template out-of-the-box, so it should not be too complicated to integrate one server. Nevertheless, I faced a few issues while trying to setup one and I will detail these steps below. Agent(…)

An overview of “Oracle Cloud Infrastructure: everything for an efficient migration” event by dbi services

Is the Oracle Cloud a hot topic for you? dbi services organized an event about the Cloud today in Lausanne: "Oracle Cloud Infrastructure: everything for an efficient migration".

APEX Connect 2023 (Day 2)

After the Keynote about “Oracle Database 23c – the developers release!” by Connor Mc Donald where he presented all the newest features of Oracle 23c Developer release, I decided to attend presentations on following topics:– APEX hidden gems –(…)

APEX Connect 2023 (Day 1)

This year again the APEX connect conference spans over two days onsite in Berlin, with mixed topics around APEX, like JavaScript, PL/SQL and much more.After the welcome speech and the Keynote about “22.2, 23.1, and beyond” by the Oracle(…)

Oracle: Is it possible to setup a system that a client (specific IP address) can only connect to a specific DB-User?

Problem description In a recent consulting assignment I got the following task: A server with a specific IP address (Application server or Oracle Client) should be able to connect to a specific DB-user only. E.g. a(…)

Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS)

To reduce load on the Primary DB in a Data Guard configuration you may decide to do your rman backups from the Standby site. A very common approach today is to use NFS as the backup location, especially when(…)