Tuesday 4 April 2023

OCI Grid Upgrade/Patch using Image Copy

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