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 identified(…)

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. Hence(…)

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. It(…)

Installing Oracle 23c Free developer release on Proxmox

Oracle provides an OVA (Open Virtual Appliance) file to install the 23c Free Developer Release on Virtualbox. An OVA file contains metadata and file elements in the Open Virtual Format (OVF) to package and distribute one or more virtual machines.

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".

Patching ODA to 19.18.: Error in sshd_config

I recently patched an Oracle Database Appliance (ODA) from 19.16. to 19.18. Detailed steps on how to patch to 19.18. are available here. During the update-server step I got the following error: # odacli describe-job -i "859c6b58-19e5-453e-96a9-f29bcc70894a" Job details(…)

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 single application server(…)

ODA: ASR Manager RPM update stuck

When updating ODA, ASR Manager RPM update is stuck(…)

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 using(…)