Skip to content

Oracle

Oracle Database as our consultants live it every day: installation and patching, upgrades, RMAN backup and recovery, Data Guard, RAC, performance tuning, multitenant, licensing, and engineered systems such as ODA and Exadata.

Physical Online Migration to ExaCC with Oracle Zero Downtime Migration (ZDM)

A while ago I had been testing and blogging about ZDM, see my previous articles. And I finally had the chance to implement it at one of our customer to migrate on-premise databases to Exadata Cloud @Customer. After having been implementing Logical Offline migration with ZDM, see my previous article, https://www.dbi-services.com/blog/logical-offline-migration-to-exacc-with-oracle-zero-downtime-migration-zdm/, I had the opportunity to implement a Physical Online… 

Logical Offline Migration to ExaCC with Oracle Zero Downtime Migration (ZDM)

A while ago I had been testing and blogging about ZDM, see my previous articles. And I finally had the chance to implement it at one of our customer to migrate on-premises database to Exadata Cloud @Customer. In this article I would like to share with you my experience migrating an on-premises database to ExaCC using ZDM Logical Offline Migration… 

Oracle ZDM Migration – java.security.InvalidKeyException: invalid key format

ZDM tool migration requires SSH Passwordless Login without passphrase between ZDM Host, the source and the target. Configuring appropriate keys might still result in a java security exception on this one. In this blog I will tell you how to deal with such a problem. I faced this problem implementing ZDM to migrate On-Premise Database to new ExaCC at one… 

How to patch your ODA to 19.21?

Introduction Patch 19.21 is now available for Oracle Database Appliance series. Let’s find out what’s new and how to apply this patch. What’s new? The most important new component is Linux 8. X10 series were already running on Linux 8 with a dedicated patch (19.20.0.1), but older ODAs were stuck with Linux 7 since years. This version also brings latest… 

What is the fastest method to connect to an Oracle database?

There are still applications around, which do connect to the database, do some stuff and then disconnect again. I.e. for each and every operation a logon to the database is necessary. This produces unnecessary overhead and is expressed in a high percentage of DB time taken by “connection management call elapsed time” in the Oracle time model. In case the… 

dbvisit StandbyMP with OracleSE2 – dbvnet port problem

I’m currently working on a customer project, where we have 2 old Lenovo Servers, one ODA X7-2M and another ODA X8-2M. In the new project, we are replacing the 2 old Lenovo Servers by 2 new ODA X9-2L. The production database, let’s call it DB01, is a Standard Edition database with dbvisit Standby as Disaster Recovery solution. During each project,… 

dbvisit StandbyMP with Oracle SE2 – switchover error with ORA-27125

After having recently deployed a new customer system running Oracle SE2 databases in Disaster Recovery environment using dbvisit StandbyMP v11.4.1 on Oracle Linux 8.8, I did some final test running a switchover. The switchover failed with following error: Problem description Running switchover command was failing: oracle@srv01:~/ [MYDB] /u01/app/dbvisit/standbymp/oracle/dbvctl -d MYDB -o switchover ============================================================= Dbvisit Standby Database Technology (11.4.1) (pid 9997)… 

dbvisit StandbyMP with Oracle SE2 – ERROR_CODE:808 Database in unknown mode (94). Setup cannot proceed.

I recently deployed a new installation at one customer with 2 linux servers and 2 Oracle SE2 databases with dbvisit StandbyMP v11 disaster recovery solution. I prepared the standby database using RMAN duplication method, and then just wanted to create the dbvisit DDC configuration using CLI command. I had to troubleshoot one error, and wanted to share quickly the solution… 

ODA hybrid patching: 19.20/19.19

Introduction Patching your Oracle Database Appliance (ODA) is highly recommended: once a year being the minimum you could do. It prevents security risks, fixes some bugs and eventually provides new features. And it also keeps your appliance supported: according to MOS note 2757884.1, your ODA should be running version 19.16 for X7-2 series, X8-2 series and X9-2 series, and version…