Oracle

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

Issue deleting a database on ODA?

I have recently faced an issue deleting database on an ODA. I was getting following error whatever database I wanted to delete : DCS-10001:Internal error encountered: null. Through this blog, I would like to share with you my experience on(…)

How to configure additional network card on an ODA X8 family

During a past project, we were using ODA X8-2M with one additional network card. As per my knowledge, on an appliance, additional cards are used to extend connectivity to additional network. Customer was really enforcing to have network redundancy between(…)

How to use DBMS_SCHEDULER to improve performance ?

From an application point of view, the oracle scheduler DBMS_SCHEDULER allows to reach best performance by parallelizing your process. Let’s start with the following PL/SQL code inserting in serial several rows from a metadata table to a target table. In(…)

Oracle Standard Edition on AWS ☁ socket arithmetic

By Franck Pachot . Note that I’ve written previously about Oracle Standard Edition 2 licensing before but a few rules change. This is written in May 2020. TL;DR: 4 vCPU count for 1 socket and 2 sockets count(…)