*** Upgrade GRID 12.1 to 12.2 (Standalone)
References:
Patches to apply before upgrading Oracle GI and DB to 12.2.0.1 (Doc ID 2180188.1)
http://docs.oracle.com/database/122/CWLIN/running-oui-to-upgrade-grid-infrastructure-from-an-earlier-release.htm#GUID-3BE36DF3-EB62-4CD1-B53A-850A3E2129E3
http://docs.oracle.com/database/122/CWLIN/checks-to-complete-before-upgrading-oracle-clusterware.htm#GUID-19947AC8-213B-4104-8D79-E462C7C364EC
Environment:
ORACLE_BASE: /opt/oracle
ORACLE_HOME: grid 12.1
/opt/oracle/grid_1
ORACLE_HOME: grid 12.2
/opt/oracle/grid_2
GRID Binary: linuxx64_12201_grid_home.zip
1.) Check the status for your current HAS
crsctl stat res -t
——————————————————————————–
Name Target State Server State details
——————————————————————————–
Local Resources
——————————————————————————–
ora.ons
OFFLINE OFFLINE vddl-ocm-odg-01 STABLE
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.cssd
1 OFFLINE OFFLINE STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE vddl-ocm-odg-01 STABLE
——————————————————————————–
2.) CSSD must be online, during the upgrade process there is a check
regarding this.
This will avoid issues during the rootupgrade.sh
–> Start the CSSD if it’s not started:
crsctl start res ora.cssd -init
CRS-2672: Attempting to start ‘ora.cssd’ on ‘vddl-ocm-odg-01’
CRS-2672: Attempting to start ‘ora.diskmon’ on ‘vddl-ocm-odg-01’
CRS-2676: Start of ‘ora.diskmon’ on ‘vddl-ocm-odg-01’ succeeded
CRS-2676: Start of ‘ora.cssd’ on ‘vddl-ocm-odg-01’ succeeded
3.) Change the status for the AUTO_START attribute:
With the “normal” way at this time i could not change the attribute value
[oracle@vddl-ocm-odg-01 network]$ crsctl modify resource “ora.cssd” -attr “AUTO_START=always” -f
CRS-4995: The command ‘Modify resource’ is invalid in crsctl. Use srvctl for this command.
So i had to use “-unsuported” parameter, please note that this parameter should be
always used with permission of Oracle Support:
[oracle@vddl-ocm-odg-01 network]$ crsctl modify resource “ora.cssd” -attr “AUTO_START=always” -f -unsupported
4.) A listener must exists:
srvctl add listener
srvctl start listener
[oracle@vddl-ocm-odg-01 admin]$ crsctl stat res -t
——————————————————————————–
Name Target State Server State details
——————————————————————————–
Local Resources
——————————————————————————–
ora.LISTENER.lsnr
ONLINE ONLINE vddl-ocm-odg-01 STABLE
ora.ons
OFFLINE OFFLINE vddl-ocm-odg-01 STABLE
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.cssd
1 ONLINE ONLINE vddl-ocm-odg-01 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE vddl-ocm-odg-01 STABLE
——————————————————————————–
5.) Apply Latest PSU on the grid home, be sure after the PSU that
CSSD is UP
Patch 24917825: GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.2.170117
6.) Pre tasks as GRID OWNER:
unset ORACLE_HOME
unset ORACLE_SID
unset ORACLE_BASE
unset ORA_NLS10
unset ORA_CRS_HOME
unset TNS_ADMIN
* Check to ensure that the user profile for the installation user,
for example, .profile or .cshrc,
does not set any of these environment variables.
Ensure that the $ORACLE_HOME/bin path is removed from your
PATH environment variable.
export PATH=.:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin
7.) Directories
mkdir -p /opt/oracle/grid_2
chown oracle:oinstall /opt/oracle/grid_2
cd /opt/oracle/grid_2
Please copy the binary to /opt/oracle/grid_2
unzip linuxx64_12201_grid_home.zip
8.) Upgrade process:
as Grid owner, on my case “oracle”
/opt/oracle/grid_2/gridSetup.sh
9.) During the process the Setup will ask to execute rootupgrade.sh
10.) After the upgrade you should see the info below executing the commands:
–> Change the ORATAB
[oracle@vddl-ocm-odg-01 grid_2]$ cat /etc/oratab
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.
# A colon, ‘:’, is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, ‘#’, are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third field indicates
# to the dbstart utility that the database should , “Y”, or should not,
# “N”, be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
GRID:/opt/oracle/grid_2:N
–> . oraenv
GRID
[oracle@vddl-ocm-odg-01 ~]$ crsctl query has softwareversion
Oracle High Availability Services version on the local node is [12.2.0.1.0]
[oracle@vddl-ocm-odg-01 ~]$ crsctl query has releaseversion
Oracle High Availability Services release version on the local node is
[12.2.0.1.0]
[oracle@vddl-ocm-odg-01 ~]$ crsctl query has softwarepatch
Oracle Clusterware patch level on node vddl-ocm-odg-01 is [0].
11.) Deinstall GRID 12.1
as GRID owner:
cd $HOME
export ORACLE_HOME=/opt/oracle/grid_1
/opt/oracle/grid_1/deinstall/deinstall
## [START] Oracle install clean ##
Clean install operation removing temporary directory ‘/tmp/deinstall2017-04-07_08-50-29PM’ on node ‘vddl-ocm-odg-01’
## [END] Oracle install clean ##
######################### DEINSTALL CLEAN OPERATION END #########################
####################### DEINSTALL CLEAN OPERATION SUMMARY #######################
Successfully detached Oracle home ‘/opt/oracle/grid_1’ from the central inventory on the local node.
Oracle Universal Installer cleanup was successful.
Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################
12.) Check the status
. oraenv
GRID
[oracle@vddl-ocm-odg-01 grid_1]$ crsctl stat res -t
——————————————————————————–
Name Target State Server State details
——————————————————————————–
Local Resources
——————————————————————————–
ora.LISTENER.lsnr
ONLINE ONLINE vddl-ocm-odg-01 STABLE
ora.ons
OFFLINE OFFLINE vddl-ocm-odg-01 STABLE
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.cssd
1 ONLINE ONLINE vddl-ocm-odg-01 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE vddl-ocm-odg-01 STABLE
——————————————————————————–
[oracle@vddl-ocm-odg-01 grid_1]$ which crsctl
/opt/oracle/grid_2/bin/crsctl
