OCI-c DBcs: prereq check and patching

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

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s