Cloning Oracle Grid Infrastructure Using Ansible

Sometimes your organization may decide to move to new hardware, to new data center and you, as an Oracle DBA, would need to be involved in preparation and configuration of new servers at new location. It is very often that…

Read More >

Oracle E-Business Suite and Java Web Start. Finally!

Great things always happen overnight. That’s probably the case for European Oracle Apps DBAs in the same situation, like myself. This morning I read Steven Chan’s latest blog post about Java Web Start certification with Oracle E-Business Suite and its…

Read More >

Error ORA-01033 After Doing a Switchover in a 12.1 RAC Environment

The other day I did a switchover in a RAC environment , which went pretty smooth , but after doing the switchover in the primary, I kept getting the following error: SELECT dest_name,STATUS,error FROM gv$archive_dest_status WHERE dest_id=2;   DEST_NAME ——————————————————————————–…

Read More >

Bushy Join Trees in Oracle 12.2

There are multiple optimizer features introduced in the Oracle Database 12.2 Release. Bushy Join Trees is the one that I’ll be demonstrating in this post. First, I’ll create four tables with two indexes: CREATE TABLE t1 AS SELECT rownum n1,…

Read More >

How to Patch an Exadata (Part 6) – Timing

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6     6: Timing Now that we know how to patch every component and the different options available to do…

Read More >

How to Patch an Exadata (Part 4) – The Rollback Procedure

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6     4: The Rollback Procedure You will most likely never need to rollback any patch on an Exadata but…

Read More >

How to Patch an Exadata (Part 3) – Grid and Database OH Patching

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6

Read More >

How to Patch an Exadata (Part 2) – Cells, IB and DB Servers

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6 3: The patching procedure 3.1 Patching the Cells (aka Storage Servers)     3.1.0 – Information All actions must be…

Read More >

How to Patch an Exadata (Part 1) – Introduction and Prerequisites

Once you have installed your new Exadata machine will come a time where you’ll be asked : “shouldn’t we patch the Exadata” ? And the answer is “yes, definitely“.   Indeed, Oracle releases huges (~ 10 GB) “Quarterly Full Stack” patches (aka…

Read More >

The Side Effects of Drop ‘Unused’ Index

In this blog post I’ll demonstrate a scenario where dropping a potentially ‘unused’ index can have a negative influence on the optimizer’s cardinality estimation. Having columns with logical correlation and skewed data can cause difficulties for the optimizer when calculating…

Read More >
Page 1 of 1212345...10...Last Page »