ODA/KVM DBHome patching

Moving a database from one OH 19.18 to another, for example 19.19, can be achieve, either by updatign the ORACLE_HOME, or by moving the database into an existing OH

Method 1: moving the OH

Get the ID of the dbhome to be upgraded:

odacli list-dbhomes

ID Name DB Version DB Edition Home Location Status
8c5051e-0adc-46f0-9092-30c739fac55c OraDB19000_home1 19.18.0.0.230117 EE /u01/app/oracle/product/19.0.0.0/dbhome_1 CONFIGURED

Run the patchreport for that upgrade

odacli create-prepatchreport --dbhome --dbhomeid 88c5051e-0adc-46f0-9092-30c739fac55c -v 19.19.0.0.0

If the report show no error, proceed with the upgrade

/opt/oracle/dcs/bin/odacli update-dbhome --dbhomeid 88c5051e-0adc-46f0-9092-30c739fac55c -v 19.19.0.0.0

/opt/oracle/dcs/bin/odacli update-dbhome --dbhomeid 88c5051e-0adc-46f0-9092-30c739fac55c -v 19.19.0.0.0


odacli describe-job -i 1ff4d3c0-924f-4439-9d7a-2fe764d7b799

Job details                                                      
----------------------------------------------------------------
                     ID:  1ff4d3c0-924f-4439-9d7a-2fe764d7b799
            Description:  DB Home Patching: Home Id is 88c5051e-0adc-46f0-9092-30c739fac55c
                 Status:  Success
                Created:  August 30, 2023 11:47:05 AM IST
                Message:  

Task Name                                Node Name                 Start Time                          End Time                            Status    
---------------------------------------- ------------------------- ----------------------------------- ----------------------------------- ----------
Creating wallet for DB Client            odapdbc01                 August 30, 2023 11:47:36 AM IST     August 30, 2023 11:47:37 AM IST     Success   
Patch databases by RHP - [emdev]         odapdbc01                 August 30, 2023 11:47:37 AM IST     August 30, 2023 11:56:44 AM IST     Success   
Updating database metadata               odapdbc02                 August 30, 2023 11:56:45 AM IST     August 30, 2023 11:56:45 AM IST     Success   
Set log_archive_dest for Database        odapdbc01                 August 30, 2023 11:56:45 AM IST     August 30, 2023 11:56:50 AM IST     Success   
Generating and saving BOM                odapdbc01                 August 30, 2023 11:56:50 AM IST     August 30, 2023 11:58:03 AM IST     Success   
Generating and saving BOM                odapdbc02                 August 30, 2023 11:56:50 AM IST     August 30, 2023 11:57:59 AM IST     Success   
TDE parameter update                     odapdbc02                 August 30, 2023 11:58:04 AM IST     August 30, 2023 11:58:05 AM IST     Success   
Method 2: moving the database into an existing OH

First create the new OH

odacli create-dbhome -v 19.190.0.0

Identify the dbhome id:

odacli list-dbhomes

Identify the database id

odacli list-databases

Run the analysis command for that database id and the target dbhome id:

odacli create-prepatchreport -dbid 395b0514-505c-436b-b9cb-25a4917092f0 -to b4cd427b-ce6d-4307-b646-9121ff8b2d5a -db

Leave a Reply

Your email address will not be published. Required fields are marked *