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.
By Mouhamadou Diaw A few days ago, I was setting an Enterprise Manager 13c R5 for a client. The configuration used is the following -The EM binaries are installed in a separate server than the database -The database of the repository is an Oracle pluggable database 19.12 The server for the EM binaries has following OS 1 2 3 4…
Introduction Cloud often raises in the top 3 solutions when thinking about Oracle infrastructure renewal. For obvious reasons: you do not need to buy any server, platform is already available, you pay as a subscription, you drastically reduce time to go to production and you can scale up and down. Oracle Cloud Infrastructure, or OCI, is a Cloud provider you…
Sometimes giving a workshop is a good opportunities to test new things…this what happened to me today… 🙂 While giving an ODA workshop, I thought it was a good opportunity to test patching to the new 19.12 release. However during the update-server process we got a failure on the our ODA update to 19.12 failing on GI patch using RHP.…
By Mouhamadou Diaw Sometimes you need to access to your SQLServer from your Oracle database. There is many ways and tools to do this. In this blog I am describing how to perform this task using ODBC. The configuration is below -Oracle Linux server : serverora 192.168.56.41 with Oracle 19 database orcl -Windows server : winrac1 192.168.56.100 with SQLServer Express…
By Mouhamadou Diaw KVM virtualization uses a kernel-based virtual machine (KVM) to create a virtualized environment for your Linux applications.In this blog I want to share some tasks I did at a client. The client is using ODA 19.12. The databases are created on the bare metal and for the applications, we decide to create virtual machines. What do I…
By Mouhamadou Diaw In this blog I am describing the deployment of an ODA with the version 19.12 Following patches will be needed -Patch 30403643: Oracle Database Appliance ISO Image -Patch 30403673: Oracle Database Appliance Grid Infrastructure Clone for ODACLI/DCS stack -Patch 33152232: Oracle Database Appliance Server Patch for ODACLI/DCS Stack -Patch 30403662: Oracle Database Appliance Database Clone 19.12.0.0.210720 for…
Introduction Benefits of going into the Oracle Cloud (OCI) are clear for most of us: no more datacenter and hardware to manage. But what else? On OCI, you can also decide to get rid of part of the DBA tasks (the less interesting ones, for sure). To create your Oracle database environment, you need to choose among these 3 solutions…
The DUAL table is automatically created by Oracle and contains one column (DUMMY) and one row (x value). This table is often used by SQL developer in PL/SQL code (Package, Functions, Trigger) to initialize variables storing technical information such as for example SYSDATE, USER or HOSTNAME. Querying DUAL table is generally faster as we can see below: SQL> select sysdate…
In this post, I will not show you all advantages related to Oracle Unified Auditing. For that, read the oracle documentation. You can also read the blogs written by my colleagues : Oracle 12c Unified Auditing Feature in a multitenant environment Oracle 12c – RMAN and Unified Auditing – Does it really work ? Purging Unified Audit Trail in 12cR2…
Now that we have cloned our ORATEST source database into a clone database named ORATCL1 (see Nutanix Era Blog part 5), we will see how we can refresh it and see the impacts on the oracle database itself. For more information on Nutanix products, I would encourage you to visit Nutanix website. Create a test table on the ORATEST source…
I would like to share some personal thoughts. September 28th 2021, Oracle released the eleventh Exadata data machine called “X9M-2” (2 CPU sockets), X9M-8 (8 sockets) and ZDLRA X9M. Exadata is a computing platform to run Oracle RDBMS, zero data loss recovery appliance (ZDLRA) is a platform to backup Oracle RDBMS and based on Exadata hardware. Combining hard- and software…
Now that we have our ORATEST database provisioned (see Nutanix Era blog part 3), that we could run snapshot and take Log Catch Up (see Nutanix Era Blog part 4), we will now see how we can clone an oracle database. For more information on Nutanix products, I would encourage you to visit Nutanix website. Database Menu Source database and…
