GI upgrade 12.2 to 19 (SIHA) with response file - denis-kol4ev/OraDBA GitHub Wiki

How to Install / Upgrade/ Clone 12.2 Grid Infrastructure in Silent Mode Using gridSetup.sh (Doc ID 2327772.1)

1. Check GI software version

crsctl query has softwareversion

2. Unzip Grid 19 software distributive or gold image

mkdir /opt/oracle/grid19.3
unzip /opt/oracle/distr/19.3/LINUX.X64_1910000_grid_home.zip -d /opt/oracle/grid19.3

3. Install additional packages

# yum install oracle-database-preinstall-19c
# cd /opt/oracle/grid19.3/cv/rpm
# rpm -ivh cvuqdisk-1.0.10-1.rpm

4. Get right privileges

For automatic root script execution we need root user password or sudo privilege for oracle (grid installation owner) user. Otherwise upgrade will not be fully automated. Grant sudo without password for oracle user example:

# echo -e "oracle\tALL=(ALL)\tNOPASSWD: ALL" > /etc/sudoers.d/020_sudo_for_oracle

5. Response file preparation

For generating of response file:

a. run gridSetup.sh in GUI mode

b. select "Upgrade Oracle Grid Infrastructure"

c. answer on all master questions

d. on Summary item select "Save Response File"

e. interrupt installation by press Cancel button

In that response file example, for clarity, only variables with values are saved, variables without values were deleted.
Location of default template for response file $ORACLE_HOME/install/response/gridsetup.rsp

vi grid19_upg.rsp

grid19_upg.rsp

###############################################################################
## Instructions to fill this response file                                   ##
## To upgrade clusterware and/or Automatic storage management of earlier     ##
## releases                                                                  ##
##  - Fill out sections A,B,C,D and H                                        ##
###############################################################################

#------------------------------------------------------------------------------
# Do not change the following system generated value. 
#------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0

###############################################################################
#                                                                             #
#                          SECTION A - BASIC                                  #
#                                                                             #
###############################################################################


#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
# This is an optional parameter if installing on  
# Windows based Operating System.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/opt/oracle/oraInventory

#-------------------------------------------------------------------------------
# Specify the installation option.
# Allowed values: CRS_CONFIG or HA_CONFIG or UPGRADE or CRS_SWONLY or HA_SWONLY
#   - CRS_CONFIG  : To register home and configure Grid Infrastructure for cluster
#   - HA_CONFIG   : To register home and configure Grid Infrastructure for stand alone server
#   - UPGRADE     : To register home and upgrade clusterware software of earlier release
#   - CRS_SWONLY  : To register Grid Infrastructure Software home (can be configured for cluster 
#                   or stand alone server later)
#   - HA_SWONLY   : To register Grid Infrastructure Software home (can be configured for stand 
#                   alone server later. This is only supported on Windows.)
#   - CRS_ADDNODE : To add more nodes to the cluster
#   - CRS_DELETE_NODE : To delete nodes to the cluster
#-------------------------------------------------------------------------------
oracle.install.option=UPGRADE

#-------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#-------------------------------------------------------------------------------
ORACLE_BASE=/opt/oracle

################################################################################
#                                                                              #
#                           SECTION C - SCAN                                   #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------
# Specify the type of SCAN configuration for the cluster
# Allowed values : LOCAL_SCAN and SHARED_SCAN
#-------------------------------------------------------------------------------
oracle.install.crs.config.scanType=LOCAL_SCAN
  

################################################################################
#                                                                              #
#                           SECTION D - CLUSTER & GNS                         #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------
# Specify the required cluster configuration
# Allowed values: STANDALONE, DOMAIN, MEMBERDB, MEMBERAPP
#-------------------------------------------------------------------------------
oracle.install.crs.config.ClusterConfiguration=STANDALONE

#-------------------------------------------------------------------------------
# Specify 'true' if you would like to configure the cluster as Extended, else
# specify 'false'
#
# Applicable only for STANDALONE and DOMAIN cluster configuration
#-------------------------------------------------------------------------------
oracle.install.crs.config.configureAsExtendedCluster=false

#-------------------------------------------------------------------------------
# Applicable only for STANDALONE, DOMAIN, MEMBERDB cluster configuration.
# Specify 'true' if you would like to configure Grid Naming Service(GNS), else
# specify 'false'
#-------------------------------------------------------------------------------
oracle.install.crs.config.gpnp.configureGNS=false


################################################################################
#                                                                              #
#                             SECTION H - UPGRADE                              #
#                                                                              #
################################################################################
#-------------------------------------------------------------------------------
# Specify whether to ignore down nodes during upgrade operation.
# Value should be 'true' to ignore down nodes otherwise specify 'false'
#-------------------------------------------------------------------------------
oracle.install.crs.config.ignoreDownNodes=false               	
################################################################################
#                                                                              #
#                               MANAGEMENT OPTIONS                             #
#                                                                              #
################################################################################

#-------------------------------------------------------------------------------
# Specify the management option to use for managing Oracle Grid Infrastructure
# Options are:
# 1. CLOUD_CONTROL - If you want to manage your Oracle Grid Infrastructure with Enterprise Manager Cloud Control.
# 2. NONE   -If you do not want to manage your Oracle Grid Infrastructure with Enterprise Manager Cloud Control.
#-------------------------------------------------------------------------------
oracle.install.config.managementOption=NONE

################################################################################
#                                                                              #
#                      Root script execution configuration                     #
#                                                                              #
################################################################################

#-------------------------------------------------------------------------------------------------------
# Specify the root script execution mode.
#
#   - true  : To execute the root script automatically by using the appropriate configuration methods.
#   - false : To execute the root script manually.
#
# If this option is selected, password should be specified on the console.
#-------------------------------------------------------------------------------------------------------
oracle.install.crs.rootconfig.executeRootScript=true

#--------------------------------------------------------------------------------------
# Specify the configuration method to be used for automatic root script execution.
#
# Following are the possible choices:
#   - ROOT
#   - SUDO
#--------------------------------------------------------------------------------------
oracle.install.crs.rootconfig.configMethod=SUDO
#--------------------------------------------------------------------------------------
# Specify the absolute path of the sudo program.
#
# Applicable only when SUDO configuration method was chosen.
#--------------------------------------------------------------------------------------
oracle.install.crs.rootconfig.sudoPath=/usr/bin/sudo

#--------------------------------------------------------------------------------------
# Specify the name of the user who is in the sudoers list. 
# Applicable only when SUDO configuration method was chosen.
# Note:For Grid Infrastructure for Standalone server installations,the sudo user name must be the username of the user performing the installation.
#--------------------------------------------------------------------------------------
oracle.install.crs.rootconfig.sudoUserName=oracle
#--------------------------------------------------------------------------------------

6. Shutdown all running databases

crsctl stat res -t
srvctl stop database -d angel_orcl

7. Upgrade Grid using response file

export ORACLE_HOME=/opt/oracle/grid19.3 && cd $ORACLE_HOME
./gridSetup.sh -silent -responseFile /home/oracle/grid19_upg.rsp

8. Check GI software version

crsctl query has softwareversion

9. Startup stopped databases

crsctl stat res -t
srvctl start database -d angel_orcl
crsctl stat res -t

10. Deinstall the previous release Oracle Grid Infrastructure

# chmod -R 755 /opt/oracle/grid12.2 && chown -R oracle /opt/oracle/grid12.2
# su - oracle
$ export ORACLE_HOME=/opt/oracle/grid12.2 && cd $ORACLE_HOME/deinstall
$ ./deinstall

11. Reboot host to make sure that all resources will start automatically

# reboot 
$ crsctl stat res -t