[FATAL] [INS-10111] Installer encountered errors while copying to nodes

Those days, I tried to deploy a new Oracle Database 19c (19.15) in an Oracle Linux 7.9. This was a Real Application Clusters (RAC) Database Home, the GI was on version 19.14, and the problem was weird: [oracle@au1 dbhome_2]$ ./runInstaller -applyRU /u01/app/oracle/product/19/33515361 -responseFile /tmp/db_2022-04-28_07-28-17PM.rsp -silent -ignorePrereqFailure Preparing the home to patch... Applying the patch /u01/app/oracle/product/19/33515361... …

Continue reading

How to convert non-RAC Oracle Home to RAC Oracle Home

Multiple times in the past, I've been in a situation where for some reason, I had to convert an Oracle Database Home to be compatible with RAC. A recent one was after the installer encountered errors while copying db home to nodes. So I end up installing manually, node by node, and later converting. As …

Continue reading

Using REST API with Oracle AutoUpgrade utility

Oracle AutoUpgrade utility, since version 22, is compatible with RESTful API. This brings all the advantages of using that interface that I won't mention here, but the most important is that is no longer needed to SSH or create a shellscript to perform a database upgrade. Now all can be done simply by reaching the …

Continue reading

How to upgrade and downgrade Oracle Database 12.2 non-CDB to 19c CDB

Today my experiment will be upgrading 12.2 (Oct 2021 RU & OJVM), running in the non-CDB mode, to the latest 19c version (currently it is 19.13) in multitenant architecture. The idea of this scenario is to validate and test not only the upgrade process but especially the downgrade strategy. I will keep the COMPATIBLE parameter …

Continue reading

Active Data Guard DML Redirection: cool feature, but may bring some security opportunities

Today is October 11th, #JoelKallmanDay, a day where the Oracle community appreciates all Joel Kallman's work and effort to improve the huge Oracle community we have. I share a lot the thoughts and feelings of what Daniel has written (https://dohdatabase.com/2021/10/11/i-never-meet-joel-but-i-have-met-his-spirit-joelkallmanday/). Unfortunately, I didn't have the chance to know him in person, even though I can …

Continue reading