Oracle

DB-Upgrade hangs in SE2 waiting on Streams AQ while gathering statistics on LOGMNR-Tables

A couple of weeks ago I upgraded an Oracle Standard Edition 2 test database from 12.1.0.2 to 12.2.0.1 (with the April 2020 Patch Bundle) on Windows. Recently I upgraded the production database. Both upgrades were done with the Database Upgrade(…)

Oracle 18c – select from a flat file

By Franck Pachot . This post is the first one from a series of small examples on recent Oracle features. My goal is to present them to people outside of Oracle and relational databases usage, maybe some NoSQL players.

Functions in SQL with the Multitenant Containers Clause

By Clemens Bleile To prepare a presentation about Multitenant Tuning I wanted to see the METHOD_OPT dbms_stats global preference of all my pluggable DBs. In this specific case I had 3 PBDs called pdb1, pdb2 and pdb3 in my CDB.

Oracle 20c : Create a Far Sync Instance Is Now Easy

By Mouhamadou Diaw A far sync instance is like a standby instance as it can receive redo from the primary database and can ship that redo to other members of the Data Guard configuration. But unlike a physical standby instance,(…)

Patching Oracle Database Appliance From 18.8 to 19.6

By Mouhamadou Diaw The ODA software 19.6 is released and people are starting to patch. A direct patch to version 19.6 is possible from version 18.8. Before patching your deployment to Oracle Database Appliance release 19.6, you must(…)

Dbvisit – Switchover failing with ORA-00600 error due to Unified Auditing been enabled

I have been recently deploying dbvisit version 9.0.10 on Standard Edition SE2 18.7. Graceful switchover failed with error : ORA-00600: Interner Fehlercode, Argumente: [17090], [], [], [], [], [], [], [], [], [],[], [] (DBD ERROR: OCIStmtExecute)(…)

Applying archive log on a standby is failing with error ORA-00756: recovery detected a lost write of a data block

During one last ODA project, I was deploying dbvisit software version 9.0.10 on Oracle database SE Edition version 18.7. From time to time I was getting lost write of a data block with type KTU UNDO on the standby. Through(…)

Error getting repository data for ol6_x86_64_userspace_ksplice, repository not found

During ODA deployment I could see that starting 18.7, immediately after reimaging or patching the ODA, I was getting some regular errors in the root mail box. The error message came every hour at 13 minutes and 43 minutes.

How to add storage on ODA X8-2M

Recently I had to add some storage on an ODA X8-2M that I deployed early February. At that time the last available release was ODA 18.7. In this post I would like to share my experience and the challenge I(…)

6 things Oracle could do for a better ODA

Introduction With the latest ODA X8 range, at least 80% of the customers could find an ODA configuration that fits their needs. For the others, either they can’t afford it, either they are already in the(…)