Oracle Database as our consultants live it every day: installation and patching, upgrades, RMAN backup and recovery, Data Guard, RAC, performance tuning, multitenant, licensing, and engineered systems such as ODA and Exadata.
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“. After a welcome coffee to meet each other, Pascal Zanette shortly introduced the event and the agenda of the day. Our CTO Hervé Schweitzer presented then YaK, developed by dbi services.The idea…
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 – Template Directives– Authentication management over many applications– Futuristic SQL: Making the Impossible Possible– APEX-Item-Plugin Development for Forms and Interactive Grids– Deconstructing…
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: So obviously something is wrong with sshd_config. If an error happens when running a job on the ODA with odacli then I check the dcs agent logfile /opt/oracle/dcs/log/dcs-agent.log.…
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 APEX Team, I decided to attend presentations on following topics:– How should we design a database? You decide!– IoT and APEX…
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 responsible for reports should be able to only connect to a specific read-only-user in the database. Other application servers should be…
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 platforms like Exadata Cloud at Customer. I recently had a case where both the Primary and the Standby site had…
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 VM (this would simulate an on-premises database) to an ADB (Autonomous DataBase) using a backup location in OCI. I would like through this blog to…
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, no maintenance for patch, no worry to have about HA, DR or Data Protection. We can easily understand this. But…
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 an IP address will be needed on the bridge interface. I have demonstrate and explain this in one of my…
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 Cloud Providers, neither of the database servers are available in the public internet or you are using Oracle Standard Edition where…
