Oracle

ATP vs ADW – the Autonomous Database lockdown profiles

By Franck Pachot . The Oracle database has always distinguished two types of workloads: transactional (OLTP) and datawarehouse (VLDB, DWH, DSS, BI, analytics). There is the same idea in the managed Oracle Cloud with two autonomous database services.

MERGE JOIN CARTESIAN: a join method or a join type?

By Franck Pachot . I'll present about join methods at POUG and DOAG. I'll show how the different join methods work in order to better understand them. The idea is to show Nested Loops, Hash Join, Sort Merge Join, Merge(…)

New installed Fusion Middleware Reports or Forms WebLogic Servers fails to start after configuring SSL

We installed a Fusion Middleware reports and Forms 12.2.1.2.0 on a Linux Server. Those are single node Reports and Forms WebLogic Servers. After disabling the Non SSL Listen Port, we got the below error in the WebLogic Servers(…)

How much free space can be reclaimed from a segment?

By Franck Pachot . You have the feeling that your table takes more blocks than it should? Here are the queries I use to quickly check the free space. The idea is to call DBMS_SPACE.SPACE_USAGE and infer the minimum(…)

Oracle 18c preinstall RPM on RedHat RHEL

By Franck Pachot . The Linux prerequisites for Oracle Database are all documented but using the pre-install rpm makes all things easier. Before 18c, this was easy on Oracle Enterprise Linux (OEL) but not so easy on RedHat (RHEL) where(…)

Upgrade Oracle Grid Infrastructure from 12.1.0.2.0 to 12.2.0.1.0

The following blog will provide the necessary steps to upgrade the Grid Infrastructure from 12.1 to 12.2, for a Standalone Server. One of the new features of GI 12.2 is the usage of the AFD (Oracle ASMFD Filter Driver).

Patching ODA lite to 12.2.1.4.0

Here is how to apply the latest patch for your ODA. As usual the Oracle documentation is not 100% accurate. I applied this patch on 2 ODAs X7-2M previously deployed in 12.2.1.2.0, no intermediate patch was needed. 1) Download the(…)

Logical standby: No view for data guard status on session level

On logical standby you have to switch off data guard at least on session level to make modifications on objects which are maintained by data guard. This is done by command alter session disable guard; Dataguard(…)

ODA, network interface and configure-firstnet

Deploying new Bare Metal ODA X7-2S or 2M, I have been curious how configure-firstnet would interact with the fiber and copper ethernet network interfaces. Reading documentation on the web, I could not clearly understand if it is mandatory to have(…)

Release 18.0.0.0.0 Version 18.3.0.0.0 On-Premises binaries

By Franck Pachot . Good news, the latest Patchset for Oracle 12cR2 (which is not named patchset anymore, is actually called release 18c and numbered 18.0.0.0.0) is available for download on OTN. It is great(…)