Oracle Team

Oracle 21C Security : diagnostics_control and enable diagnostics

By Mouhamadou Diaw Some debug-events and debug-actions are not safe and should be exposed to users with caution. In previous releases, privilege control for the usage of these diagnostics was not sufficient. With Oracle 21c, regular users can be blocked(…)

Parallelize your Oracle INSERT with DBMS_PARALLEL_EXECUTE

One of the challenge of all PL/SQL developers is to simulate the Production activity in a Non Prod. environment like for example different Insert executed by several sessions. Different tools exist like Oracle RAT (Real Application Testing) but under license(…)

log4shell: Determine affection, mitigate, example: Oracle Unified Directory

This post is about two security vulnerabilities reported on log4j 2.x framework: CVE-2021-44228, with a base score 10 (of 10 max.) in CVSS version 3.1 risk, and CVE-2021-45046, base scored 9. I will list some ways to determine affection, how(…)

Dbvisit 10 on Oracle Database Appliance

By Mouhamadou Diaw Dbvisit Standby can also be installed on Oracle Database Appliance (ODA). The installation is the same that on any other Linux box. I did an install of Dbvist 10 on an ODA 19.12 for a customer and(…)

Install Enterprise Manager 13c R5: Check the db edition Failed

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

Improve Oracle Insert Performance with BULKCOLLECT and FORALL

As specified by Steven Feuerstein into the Oracle Blog Website the bulk processing features of PL/SQL are designed specifically to reduce the number of context switches required to communicate from the PL/SQL engine to the SQL engine. Using BULK(…)

DataPump and the Transform option – Not very well known, but it can be useful

I work with Oracle Databases and Datapump for more than 10 years but still I find some datapump options that I did know and in some cases can be very helpful. For a customer we did a migration of(…)

Configuring ODBC : SQLServer Access From Oracle

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

Oracle Database Appliance KVM Virtual Instance on ODA 19.12

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.

Oracle Database Appliance 19.12 Deployment

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