Infrastructure at your Service

All Posts By

Marc Wagner

Marc Wagner

How to migrate High Availability databases on an ODA?

By | Oracle | No Comments

Through this blog, I would like to show, with a real customer case, how I have been migrating databases in High Availability environment on an ODA. High Availability using Data Guard for Oracle Enterprise Edition or dbvisit for Oracle Standard Edition 2. One of the advantage here would be to use the Standby Database as fallback in case there would be some application issue with new database version. Although, I would expect that for any…

Read More
Marc Wagner

How to synchronize the appliance registry metadata on an ODA?

By | Database Administration & Monitoring, Oracle | No Comments

Databases administration on a Bare Metal ODA will be done as root user by running odacli commands : odacli create-database to create a database odacli upgrade-database to upgrade a database between major releases odacli move-database to move databases from one Oracle home to another of the same database version odacli update-dbhome to update a specific RDBMS home to the latest patch bundle version etc… The odacli commands will do the needful and at the end…

Read More
Marc Wagner

POUG 2020 Workshop Day 1

By | Oracle | No Comments

I had the opportunity to participate to POUG day 1 and wanted through this blog to share some of my feedback on the interesting sessions I could follow. First of all, I would like to mention the great introduction done by the staff team and the great organization. POUG staff team could adapt to the coronavirus situation and organized excellent POUG virtual days. Well done!

Read More
Marc Wagner

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

By | Database Administration & Monitoring, Database management, Oracle | No Comments

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 this blog, I would like to share my investigation and experience on this subject.

Read More
Marc Wagner

Issue deleting a database on ODA?

By | Database Administration & Monitoring, Oracle | No Comments

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 this case hoping it will help you if you are facing same problem. On this project I was using ODA Release 18.5 and 18.8 and faced the same problem on both versions. On 18.3 and…

Read More
Marc Wagner

How to configure additional network card on an ODA X8 family

By | Database Administration & Monitoring, Hardware & Storage, Operation systems, Oracle | No Comments

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 the 2 cards. I then took opportunity for some tests. In this post, I would like to share my experience on these tests and how to properly configure network card extension on an ODA.

Read More