DBcs: prereq check and patching on oci-c


If a PSU patch prereq fails on Database Cloud Services, indicating that the dbaastools needs to be updated, do not download and install the rpm manually as being asked in the below error message:

Precheck failed for patch [26925311-EE]. Error [please upgrade to recommended dbaastools version from
https://storage.us2.oraclecloud.com/v1/dbcsswlibpusoracle29538/dbaas_patch/dbaastools.rpm

Instead, check the latest available patch

Example for 12.2

/var/opt/oracle/patch/dbpatchm -list_tools -cli

INFO: cdb is set to : yes 
INFO: dbversion detected : 12201 
INFO: patching type : psu
Patchid : 17.4.3.1.0_171129.0000
Patchid : 17.4.3.1.0_171213.0000
Patchid : 17.4.5.0.0_171120.1542
Patchid : 18.1.1.0.0_171130.0801
Patchid : 18.1.1.1.0_180122.0952
Patchid : 18.1.2.1.0_180215.0915
Patchid : 18.1.2.1.0_180228.1052
Patchid : 18.1.2.1.0_180301.0107
Patchid : 18.1.2.1.0_180309.0517
Patchid : 18.1.4.1.0_180309.0546
Patchid : 18.1.4.1.0_180312.1800

Example for 18c

Starting DBPATCHM

INFO: cdb is set to : yes 
INFO: dbversion detected : 18000 
INFO: patching type : psu
Patchid : 18.1.4.1.0_180309.0546
Patchid : 18.1.4.1.0_180312.1800
Patchid : 18.1.4.1.0_180406.2023
Patchid : 18.1.4.1.0DBCS_180412.0105
Patchid : 18.1.4.1.0DBCS_180418.0614
Patchid : 18.1.4.1.0_180420.0000
Patchid : 18.1.4.1.0_180425.0000

Then install the latest and relevant available package as follow

/var/opt/oracle/patch/dbpatchm -toolsinst -rpmversion=18.1.4.1.0DBCS_180418.0614

Starting DBPATCHM
Logfile is ...
WARN : Parameter toolsinst passed via cmdline is not a valid parameter. Please check the usage.
Config file is /var/opt/oracle/patch/dbpatchm.cfg
INFO: cdb is set to : yes 
INFO: dbversion detected : 18000 
INFO: patching type : psu
INFO: oss_container_url is not given, using the default
INFO: existing dbaastools version - dbaastools-1.0-1+18.1.4.0.0_180123.1336.x86_64
 Use of uninitialized value in concatenation (.) or string at /var/opt/oracle/patch/dbpatchm line 4737.
INFO: updated dbaastools rpm to - dbaastools-1.0-1+18.1.4.1.0DBCS_180418.0614.x86_64

Ignore possible warnings, related to unidentified variables.

Once completed, check again that no new rpms is now available. For example, the should return no applicable rpms:

/var/opt/oracle/patch/dbpatchm -list_tools -cli