High level Steps:
1.Check The Current Grid Version Across Cluster Nodes
dbaascli grid getDetails
2.List The Available Grid Software Images
dbaascli cswlib showImages --product grid
3.Create A Patched Image Copy
dbaascli grid patch --targetVersion 19.18.0.0.0 --createImage
4.Patch Grid Using image Copy
dbaascli grid patch --targetVersion 19.18.0.0.0 --imageLocation /u02/app_acfs/exapatch/custom_images/grid1918_2023-04-03_09-17-56-PM.zip
5.Verify Grid Version Across Cluster Nodes
dbaascli grid getDetails
Complete Steps with log:
1.Check the current grid version across cluster nodes
[root@ociexacsdbnode-qdhic1 ~]# dbaascli grid getDetails
DBAAS CLI version 23.1.2.0.0
Executing command grid getDetails
Job id: a620ddd4-af0a-4839-816b-41e3e13a5940
Session log: /var/opt/oracle/log/grid/getDetails/dbaastools_2023-04-03_09-10-27-PM_207269.log
{
"createTime" : 1679423425000,
"updateTime" : 1679423425000,
"scanListenerTCPPorts" : [ 1521 ],
"scanListenerTCPSPorts" : [ 2484 ],
"giNodeLevelDetails" : {
"ociexacsdbnode-qdhic4" : {
"nodeName" : "ociexacsdbnode-qdhic4",
"homePath" : "/u01/app/19.0.0.0/grid",
"version" : "19.17.0.0.0",
"status" : null
},
"ociexacsdbnode-qdhic3" : {
"nodeName" : "ociexacsdbnode-qdhic3",
"homePath" : "/u01/app/19.0.0.0/grid",
"version" : "19.17.0.0.0",
"status" : null
},
"ociexacsdbnode-qdhic2" : {
"nodeName" : "ociexacsdbnode-qdhic2",
"homePath" : "/u01/app/19.0.0.0/grid",
"version" : "19.17.0.0.0",
"status" : null
},
"ociexacsdbnode-qdhic1" : {
"nodeName" : "ociexacsdbnode-qdhic1",
"homePath" : "/u01/app/19.0.0.0/grid",
"version" : "19.17.0.0.0",
"status" : null
}
},
"messages" : [ ]
}
dbaascli execution completed
[root@ociexacsdbnode-qdhic1 ~]#
2.List the available grid software images
[root@ociexacsdbnode-qdhic1 ~]# dbaascli cswlib showImages --product grid
DBAAS CLI version 23.1.2.0.0
Executing command cswlib showImages --product grid
Job id: efc52b92-af8f-4124-8eaf-69120c4c79a4
Session log: /var/opt/oracle/log/cswLib/showImages/dbaastools_2023-04-03_09-11-02-PM_210597.log
Log file location: /var/opt/oracle/log/cswLib/showImages/dbaastools_2023-04-03_09-11-02-PM_210597.log
############ List of Available grid Artifacts #############
1.IMAGE_TAG=grid_19.18.0.0.0
VERSION=19.18.0.0.0
DESCRIPTION=19c JAN 2023 GI Image
2.IMAGE_TAG=grid_19.17.0.0.0
VERSION=19.17.0.0.0
DESCRIPTION=19c OCT 2022 GI Image
3.IMAGE_TAG=grid_19.16.0.0.0
VERSION=19.16.0.0.0
DESCRIPTION=19c JUL 2022 GI Image
4.IMAGE_TAG=grid_19.15.0.0.0
VERSION=19.15.0.0.0
DESCRIPTION=19c APR 2022 GI Image
Images can be downloaded using their image tags. For details, see help using 'dbaascli cswlib download --help'.
dbaascli execution completed
[root@ociexacsdbnode-qdhic1 ~]#
3.Create a patched image Copy
[root@ociexacsdbnode-qdhic1 ~]# dbaascli grid patch --targetVersion 19.18.0.0.0 --createImage
DBAAS CLI version 23.1.2.0.0
Executing command grid patch --targetVersion 19.18.0.0.0 --createImage
Job id: 2895b0d4-3869-4a8b-a806-342b7a2f420e
Session log: /var/opt/oracle/log/grid/patch/dbaastools_2023-04-03_09-16-14-PM_243786.log
Loading PILOT...
Session ID of the current execution is: 354
Log file location: /var/opt/oracle/log/grid/patch/pilot_2023-04-03_09-16-17-PM_244709
-----------------
Running initialization job
Completed initialization job
-----------------
Running validate_target_version job
Completed validate_target_version job
-----------------
Running validate_target_image_location job
Completed validate_target_image_location job
-----------------
Running validate_backup_locations job
Completed validate_backup_locations job
-----------------
Running validate_source job
Completed validate_source job
-----------------
Running validate_disk_space job
Completed validate_disk_space job
-----------------
Running unpackage_patches job
Completed unpackage_patches job
-----------------
Running create_temp_locations job
Completed create_temp_locations job
-----------------
Running copy_source_home job
Completed copy_source_home job
-----------------
Running unlock_temp_home job
Completed unlock_temp_home job
-----------------
Running attach_temp_home job
Completed attach_temp_home job
-----------------
Running replace_opatch job
Completed replace_opatch job
-----------------
Running check_patch_conflict job
Completed check_patch_conflict job
-----------------
Running rollback_conflicting_patches job
Completed rollback_conflicting_patches job
-----------------
Running apply_oneoffs_prepatch job
Completed apply_oneoffs_prepatch job
-----------------
Running apply_ru job
Completed apply_ru job
-----------------
Running apply_oneoffs_postpatch job
Completed apply_oneoffs_postpatch job
-----------------
Running create_gold_image job
Image location: /u02/app_acfs/exapatch/custom_images/grid1918_2023-04-03_09-17-56-PM.zip
Completed create_gold_image job
-----------------
Running cleanup job
Completed cleanup job
dbaascli execution completed
You have new mail in /var/spool/mail/root
[root@ociexacsdbnode-qdhic1 ~]#
Note:It is better to stop databases before starting patching and start them after patching is complete. This will save time during patch.
4.Patch Grid Using image Copy
[root@ociexacsdbnode-qdhic1 ~]# dbaascli grid patch --targetVersion 19.18.0.0.0 --imageLocation /u02/app_acfs/exapatch/custom_images/grid1918_2023-04-03_09-17-56-PM.zip
DBAAS CLI version 23.1.2.0.0
Executing command grid patch --targetVersion 19.18.0.0.0 --imageLocation /u02/app_acfs/exapatch/custom_images/grid1918_2023-04-03_09-17-56-PM.zip
Job id: 25979ce4-007c-48a1-a2e6-89c8b9bf2acf
Session log: /var/opt/oracle/log/grid/patch/dbaastools_2023-04-03_09-40-19-PM_24484.log
Loading PILOT...
Session ID of the current execution is: 355
Log file location: /var/opt/oracle/log/grid/patch/pilot_2023-04-03_09-40-22-PM_24962
-----------------
Running initialization job
Completed initialization job
-----------------
Running validate_nodes job
Completed validate_nodes job
-----------------
Running validate_image_location job
Completed validate_image_location job
-----------------
Running validate_target_version job
Completed validate_target_version job
-----------------
Running validate_backup_locations job
Completed validate_backup_locations job
-----------------
Running validate_source_home job
Completed validate_source_home job
-----------------
Running validate_creg_file_existence job
Completed validate_creg_file_existence job
-----------------
Running validate_crs_stack_state job
Completed validate_crs_stack_state job
-----------------
Running validate_databases job
Completed validate_databases job
-----------------
Running validate_disk_space job
Completed validate_disk_space job
-----------------
Running validate_perm_on_dir job
Completed validate_perm_on_dir job
-----------------
Running validate_users_umask job
Completed validate_users_umask job
-----------------
Running unpackage_image job
Completed unpackage_image job
-----------------
Running validate_image_product job
Completed validate_image_product job
-----------------
Running validate_image_version job
Completed validate_image_version job
-----------------
Running validate_image_patches job
Completed validate_image_patches job
-----------------
Running acquire_lock job
Completed acquire_lock job
-----------------
Running create_global_backup_loc job
Completed create_global_backup_loc job
-----------------
Running rotate_image_backup job
Completed rotate_image_backup job
-----------------
Running backup_image job
Completed backup_image job
-----------------
Running rotate_config_backup job
Completed rotate_config_backup job
-----------------
Running backup_config-ociexacsdbnode-qdhic1 job
Completed backup_config-ociexacsdbnode-qdhic1 job
-----------------
Running save_local_backup-ociexacsdbnode-qdhic1 job
Completed save_local_backup-ociexacsdbnode-qdhic1 job
-----------------
Running stop_db_instances-ociexacsdbnode-qdhic1 job
Completed stop_db_instances-ociexacsdbnode-qdhic1 job
-----------------
Running run_rootcrs_prepatch-ociexacsdbnode-qdhic1 job
Completed run_rootcrs_prepatch-ociexacsdbnode-qdhic1 job
-----------------
Running stop_tfa-ociexacsdbnode-qdhic1 job
Completed stop_tfa-ociexacsdbnode-qdhic1 job
-----------------
Running detach_source_home-ociexacsdbnode-qdhic1 job
Completed detach_source_home-ociexacsdbnode-qdhic1 job
-----------------
Running clean_source_home-ociexacsdbnode-qdhic1 job
Completed clean_source_home-ociexacsdbnode-qdhic1 job
-----------------
Running set_source_home_ownership-ociexacsdbnode-qdhic1 job
Completed set_source_home_ownership-ociexacsdbnode-qdhic1 job
-----------------
Running move_image_software_to_source_home-ociexacsdbnode-qdhic1 job
Completed move_image_software_to_source_home-ociexacsdbnode-qdhic1 job
-----------------
Running install_source_home-ociexacsdbnode-qdhic1 job
Completed install_source_home-ociexacsdbnode-qdhic1 job
-----------------
Running set_inventory_crs_flag-ociexacsdbnode-qdhic1 job
Completed set_inventory_crs_flag-ociexacsdbnode-qdhic1 job
-----------------
Running relink_with_rac_on-ociexacsdbnode-qdhic1 job
Completed relink_with_rac_on-ociexacsdbnode-qdhic1 job
-----------------
Running unpackage_config_files-ociexacsdbnode-qdhic1 job
Completed unpackage_config_files-ociexacsdbnode-qdhic1 job
-----------------
Running software_root_script-ociexacsdbnode-qdhic1 job
Completed software_root_script-ociexacsdbnode-qdhic1 job
-----------------
Running root_script_init-ociexacsdbnode-qdhic1 job
Completed root_script_init-ociexacsdbnode-qdhic1 job
-----------------
Running run_rootcrs_postpatch-ociexacsdbnode-qdhic1 job
Completed run_rootcrs_postpatch-ociexacsdbnode-qdhic1 job
-----------------
Running start_db_instances-ociexacsdbnode-qdhic1 job
Completed start_db_instances-ociexacsdbnode-qdhic1 job
-----------------
Running disable_diagsnap-ociexacsdbnode-qdhic1 job
Completed disable_diagsnap-ociexacsdbnode-qdhic1 job
-----------------
Running restore_tfa_status-ociexacsdbnode-qdhic1 job
Completed restore_tfa_status-ociexacsdbnode-qdhic1 job
-----------------
Running post_patch_updates-ociexacsdbnode-qdhic1 job
Completed post_patch_updates-ociexacsdbnode-qdhic1 job
-----------------
Running remove_local_backup-ociexacsdbnode-qdhic1 job
Completed remove_local_backup-ociexacsdbnode-qdhic1 job
-----------------
Running cleanup-ociexacsdbnode-qdhic1 job
Completed cleanup-ociexacsdbnode-qdhic1 job
-----------------
Running backup_config_on_node-ociexacsdbnode-qdhic2 job
Completed backup_config_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running save_local_backup_on_node-ociexacsdbnode-qdhic2 job
Completed save_local_backup_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running stop_db_instances_on_node-ociexacsdbnode-qdhic2 job
Completed stop_db_instances_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running run_rootcrs_prepatch_on_node-ociexacsdbnode-qdhic2 job
Completed run_rootcrs_prepatch_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running stop_tfa_on_node-ociexacsdbnode-qdhic2 job
Completed stop_tfa_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running stop_processes_on_node-ociexacsdbnode-qdhic2 job
Completed stop_processes_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running remove_home_on_node-ociexacsdbnode-qdhic2 job
Completed remove_home_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running copy_patched_home_from_local_node-ociexacsdbnode-qdhic2 job
Completed copy_patched_home_from_local_node-ociexacsdbnode-qdhic2 job
-----------------
Running unpackage_config_backup_on_node-ociexacsdbnode-qdhic2 job
Completed unpackage_config_backup_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running run_rootcrs_postpatch_on_node-ociexacsdbnode-qdhic2 job
Completed run_rootcrs_postpatch_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running start_db_instances_on_node-ociexacsdbnode-qdhic2 job
Completed start_db_instances_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running disable_diagsnap_on_node-ociexacsdbnode-qdhic2 job
Completed disable_diagsnap_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running restore_tfa_status_on_node-ociexacsdbnode-qdhic2 job
Completed restore_tfa_status_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running post_patch_updates_on_node-ociexacsdbnode-qdhic2 job
Completed post_patch_updates_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running remove_local_backup_on_node-ociexacsdbnode-qdhic2 job
Completed remove_local_backup_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running remove_local_patched_home_on_node-ociexacsdbnode-qdhic2 job
Completed remove_local_patched_home_on_node-ociexacsdbnode-qdhic2 job
-----------------
Running backup_config_on_node-ociexacsdbnode-qdhic3 job
Completed backup_config_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running save_local_backup_on_node-ociexacsdbnode-qdhic3 job
Completed save_local_backup_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running stop_db_instances_on_node-ociexacsdbnode-qdhic3 job
Completed stop_db_instances_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running run_rootcrs_prepatch_on_node-ociexacsdbnode-qdhic3 job
Completed run_rootcrs_prepatch_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running stop_tfa_on_node-ociexacsdbnode-qdhic3 job
Completed stop_tfa_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running stop_processes_on_node-ociexacsdbnode-qdhic3 job
Completed stop_processes_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running remove_home_on_node-ociexacsdbnode-qdhic3 job
Completed remove_home_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running copy_patched_home_from_local_node-ociexacsdbnode-qdhic3 job
Completed copy_patched_home_from_local_node-ociexacsdbnode-qdhic3 job
-----------------
Running unpackage_config_backup_on_node-ociexacsdbnode-qdhic3 job
Completed unpackage_config_backup_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running run_rootcrs_postpatch_on_node-ociexacsdbnode-qdhic3 job
Completed run_rootcrs_postpatch_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running start_db_instances_on_node-ociexacsdbnode-qdhic3 job
Completed start_db_instances_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running disable_diagsnap_on_node-ociexacsdbnode-qdhic3 job
Completed disable_diagsnap_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running restore_tfa_status_on_node-ociexacsdbnode-qdhic3 job
Completed restore_tfa_status_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running post_patch_updates_on_node-ociexacsdbnode-qdhic3 job
Completed post_patch_updates_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running remove_local_backup_on_node-ociexacsdbnode-qdhic3 job
Completed remove_local_backup_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running remove_local_patched_home_on_node-ociexacsdbnode-qdhic3 job
Completed remove_local_patched_home_on_node-ociexacsdbnode-qdhic3 job
-----------------
Running backup_config_on_node-ociexacsdbnode-qdhic4 job
Completed backup_config_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running save_local_backup_on_node-ociexacsdbnode-qdhic4 job
Completed save_local_backup_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running stop_db_instances_on_node-ociexacsdbnode-qdhic4 job
Completed stop_db_instances_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running run_rootcrs_prepatch_on_node-ociexacsdbnode-qdhic4 job
Completed run_rootcrs_prepatch_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running stop_tfa_on_node-ociexacsdbnode-qdhic4 job
Completed stop_tfa_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running stop_processes_on_node-ociexacsdbnode-qdhic4 job
Completed stop_processes_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running remove_home_on_node-ociexacsdbnode-qdhic4 job
Completed remove_home_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running copy_patched_home_from_local_node-ociexacsdbnode-qdhic4 job
Completed copy_patched_home_from_local_node-ociexacsdbnode-qdhic4 job
-----------------
Running unpackage_config_backup_on_node-ociexacsdbnode-qdhic4 job
Completed unpackage_config_backup_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running run_rootcrs_postpatch_on_node-ociexacsdbnode-qdhic4 job
Completed run_rootcrs_postpatch_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running start_db_instances_on_node-ociexacsdbnode-qdhic4 job
Completed start_db_instances_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running disable_diagsnap_on_node-ociexacsdbnode-qdhic4 job
Completed disable_diagsnap_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running restore_tfa_status_on_node-ociexacsdbnode-qdhic4 job
Completed restore_tfa_status_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running post_patch_updates_on_node-ociexacsdbnode-qdhic4 job
Completed post_patch_updates_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running remove_local_backup_on_node-ociexacsdbnode-qdhic4 job
Completed remove_local_backup_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running remove_local_patched_home_on_node-ociexacsdbnode-qdhic4 job
Completed remove_local_patched_home_on_node-ociexacsdbnode-qdhic4 job
-----------------
Running cleanup_patched_home_backup job
Completed cleanup_patched_home_backup job
-----------------
Running post_patch_validation job
Completed post_patch_validation job
-----------------
Running update_creg job
Completed update_creg job
-----------------
Running release_lock job
Completed release_lock job
-----------------
Running generate_system_details job
Completed generate_system_details job
dbaascli execution completed
You have new mail in /var/spool/mail/root
5.Verify Grid Version Across Cluster Nodes
[root@ociexacsdbnode-qdhic1 ~]# dbaascli grid getDetails
DBAAS CLI version 23.1.2.0.0
Executing command grid getDetails
Job id: 043f2f65-2ba9-49bb-954a-e21ae0acb78f
Session log: /var/opt/oracle/log/grid/getDetails/dbaastools_2023-04-03_10-56-47-PM_351301.log
{
"createTime" : 1680585364000,
"updateTime" : 1680585364000,
"scanListenerTCPPorts" : [ 1521 ],
"scanListenerTCPSPorts" : [ 2484 ],
"giNodeLevelDetails" : {
"ociexacsdbnode-qdhic4" : {
"nodeName" : "ociexacsdbnode-qdhic4",
"homePath" : "/u01/app/19.0.0.0/grid",
"version" : "19.18.0.0.0",
"status" : null
},
"ociexacsdbnode-qdhic3" : {
"nodeName" : "ociexacsdbnode-qdhic3",
"homePath" : "/u01/app/19.0.0.0/grid",
"version" : "19.18.0.0.0",
"status" : null
},
"ociexacsdbnode-qdhic2" : {
"nodeName" : "ociexacsdbnode-qdhic2",
"homePath" : "/u01/app/19.0.0.0/grid",
"version" : "19.18.0.0.0",
"status" : null
},
"ociexacsdbnode-qdhic1" : {
"nodeName" : "ociexacsdbnode-qdhic1",
"homePath" : "/u01/app/19.0.0.0/grid",
"version" : "19.18.0.0.0",
"status" : null
}
},
"messages" : [ ]
}
dbaascli execution completed
[root@ociexacsdbnode-qdhic1 ~]#
No comments:
Post a Comment