Oracle

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

Oracle Zero Downtime Migration : Offline logical database migration from on-premises to Autonomous DB 

I have recently written a blog introducing the Oracle ZDM (Zero Downtime Migration) tool : https://www.dbi-services.com/blog/zero-downtime-migration-zdm-to-oracle-cloud-infrastructure-oci/ I have also done some tests performing an offline logical database migration from a database running on an OCI(…)

ODA version 19.18 is available: how to patch?

Applying 19.18 patch on your Oracle Database Appliance(…)

Zero Downtime Migration (ZDM) to Oracle Cloud Infrastructure (OCI)

The question to migrate or not to the Cloud comes more and more often now. There are some added values to go to the Cloud as analytics capabilities, scalability and flexibility, cost saving, no dedicated hardware and its related maintenance,(…)

ODA vnetwork bridge with no IP address

It is not mandatory to setup an IP address on a bridge interface. A bridge forwards packets at MAC layer. But of course, if I would like to reach the DB System or the Compute Instance from the ODA, then(…)

Oracle Database Backup Cloud Service

In a previous blog I demonstrated how to migrate an Oracle database from AWS to Oracle OCI using Data Guard. But what if you want to migrate to the Oracle Cloud, but don’t have a direct connection between the(…)