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.
I recently blog on Oracle SEHA on ODA, see my article https://www.dbi-services.com/blog/seha-on-oda/. Oracle SEHA is used for High Availability for Standard Edition. Dbvisit Standby is a Disaster Recovery well known application designed for Oracle Standard Edition. Dbvisit guarantees database continuity, and will reduce RTO and RPO. With Dbvisit we will limit business impact in case of failure like hardware, operating…
Introduction On Oracle Database, Multitenant feature will be turning 9 in July, but it’s not yet widely deployed as most of the databases are still running on non-CDB architecture. With 19c, Multitenant is now mature and free if you stick to a maximum of 3 PDBs per CDB. If the benefits of Multitenant are not obvious at first glance, it’s…
A generic utility to test JDBC connections to any RDBMS or no SQL data source whose JDBC drivers are provided. Oracle OCI, MariaDB and SQLite.
Many people in the IT industry do use VirtualBox as a Type-2 Hypervisor to test software in virtual machines. I’m using it with Vagrant on my Macbook Pro 2019 (Intel with Ventura 13.2. when writing this Blog) to setup testcases for Oracle Databases or use a Windows VM for tests of Windows programs. Since migrating to Virtualbox V7 it feels…
A generic utility to test JDBC connections to any RDBMS or no SQL data source whose JDBC drivers are provided. Listing, PostgreSQL, Oracle Thin.
Starting my first experience with Oracle Cloud Infrastructure, I played with my lab and wanted to change my VCN name. I thought it might be more than easily with the Web Console, but could realise this was not possible. I find out that the only way to do it was through the command line. So great opportunity to start learning…
SEHA means Standard Edition High Availability. SEHA is fully integrated with Oracle Grid Infrastructure starting with Oracle Grid Infrastructure 19c, and more specifically since RU 19.7. SEHA provides then cluster-based failover for single-instance Standard Edition Oracle Databases using Oracle Clustware. It is important to mention that Oracle removed Oracle RAC from SE2 Edition since 19c. Most important things to know…
By Mouhamadou Diaw Upgrading Enterprise Manger Cloud Control can be tricky. In this blog I am describing an upgrade I did for a client. The source version is OEM13c R4 And the target version will be EM13c R5 Before starting I did following tasks -Copy the key in the repository -set the parameter “_allow_insert_with_update_check” to true You can now stop…
For some internal DMK (https://www.dbi-services.com/fr/produits/dmk-management-kit/) development I had to configure a SMTP relay on my VM. Purpose of the SMTP relay is to send the email locally from DMK without any authentication. This Email will be transferred to the SMTP server created by one of my colleague on our AWS Cloud. This SMTP server is of course using authentication. To…
By Mouhamadou Diaw In this blog I am describing an ODA HA (serveroda1 and serveroda2) patch from 19.10 to 19.17. The process is the same that patching a non-HA ODA. Few tasks may need to be done on both servers, otherwise all steps are done from one node. If there are some tasks needed on both nodes, we will specify.…
