Hi, in this we learn how to upgrade 19c Non-RAC/Standalone Grid infrastructure (single node) from 19.8 to 19.13 Release Update:
================================================================================================================
MOS DOC for Refrence:
Database Patches Required by Oracle E-Business Suite on Oracle
Engineered Systems: Exadata Database Machines and SuperClusters (Doc ID1392527.1)
Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c (Doc ID 2552181.1)
OS
Check before Prepare:
root@ebsprodapp3:~# cat
/etc/release
Oracle Solaris 11.4 SPARC
Copyright (c) 1983, 2020, Oracle and/or its affiliates. All rights reserved.
Assembled 26 March 2020
root@ebsprodapp3:~#
root@ebsprodapp3:~# uname
-a
SunOS ebsprodapp3 5.11 11.4.20.4.0 sun4v sparc sun4v
root@ebsprodapp3:~#
root@ebsprodapp3:~# prtconf
System Configuration: Oracle Corporation sun4v
Memory size: 391680 Megabytes
System Peripherals (Software Nodes):
prtconf: devinfo facility not available
root@ebsprodapp3:~#
root@ebsprodapp3:~# pkg
info entire
Name: entire
Summary: entire incorporation including Support Repository Update
(Oracle Solaris 11.4.20.4.0).
Description: This package constrains system package versions to the same
build. WARNING: Proper system update and correct package
selection depend on the presence of this incorporation.
Removing this package will result in an unsupported system.
For more information see:
https://support.oracle.com/rs?type=doc&id=2433412.1
Category: Meta Packages/Incorporations
State: Installed
Publisher: solaris
Version: 11.4 (Oracle Solaris 11.4.20.4.0)
Branch: 11.4.20.0.1.4.0
Packaging Date: Thu Mar 26 17:29:32 2020
Last Install Time: Wed Oct 14 20:51:30 2020
Size: 2.52 kB
FMRI: pkg://solaris/entire@11.4-11.4.20.0.1.4.0:20200326T172932Z
root@ebsprodapp3:~#
################################################################################################################
################################################################################################################
Actual 19c RU-13 upgrade steps Start Here:
p33182768_190000_SOLARIS64.zip
Current
Configuration and Checks:
grid@ebsproddb1:~$ crsctl
query has releasepatch
Oracle Clusterware release patch level is [3487688990] and the complete list of patches [31281355 31304218 31305087 31335188 ] have been applied on the local node. The release patch string is [19.8.0.0.0].
grid@ebsproddb1:~$ sqlplus
/ as sysasm
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
SQL>
grid@ebsproddb1:~$ asmcmd
-V
asmcmd version 19.8.0.0.0
grid@ebsproddb1:~$
GRID Infrastructure Vesion Check:
ASMCMD [+] > showversion --releasepatch
ASM version : 19.8.0.0.0
ASMCMD [+] >
ASMCMD [+] > showversion
--releasepatch
ASM version : 19.8.0.0.0
Software patchlevel : 3487688990
ASMCMD [+] >
oraoci@ebsproddb1:~$ sqlplus
/ as sysdba
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SQL>
Upgrade
GRID_HOME OPatch make sure you have take backup of GRID_HOME before:
grid@ebsproddb1:~$ crsctl stop has
root@ebsproddb1:/u01/app/grid/product# tar -cvzf 19.3.0.0_bkp_09122021.tar.gz 19.3.0.0/
grid@ebsproddb1:~$ $ORACLE_HOME/OPatch/opatch
version
OPatch Version: 12.2.0.1.21
OPatch succeeded.
grid@ebsproddb1:~$ mv $ORACLE_HOME/OPatch
$ORACLE_HOME/OPatch_bkp_21
root@ebsproddb1:/u02/19c_patches# unzip
p6880880_122010_SOLARIS64.zip -d /u01/app/grid/product/19.3.0.0
root@ebsproddb1:/u02/19c_patches# cd /u01/app/grid/product/19.3.0.0
root@ebsproddb1:/u01/app/grid/product/19.3.0.0# chown
-R grid:oinstall /u01/app/grid/product/19.3.0.0/OPatch
root@ebsproddb1:/u01/app/grid/product/19.3.0.0#
grid@ebsproddb1:~$ $ORACLE_HOME/OPatch/opatch
version
OPatch Version: 12.2.0.1.28
OPatch succeeded.
grid@ebsproddb1:~$
grid@ebsproddb1:~$ $ORACLE_HOME/OPatch/opatch
lsinventory -detail > OPatch_output.txt
grid@ebsproddb1:/u02/19c_patches$ unzip
p33182768_190000_SOLARIS64.zip
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail
-phBaseDir /u02/19c_patches/33182768/33192793
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail
-phBaseDir /u02/19c_patches/33182768/33208123
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail
-phBaseDir /u02/19c_patches/33182768/33208107
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail
-phBaseDir /u02/19c_patches/33182768/33239955
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail
-phBaseDir /u02/19c_patches/33182768/32585572
grid@ebsproddb1:/u02/19c_patches$ $ORACLE_HOME/OPatch/opatch
prereq CheckConflictAgainstOHWithDetail -phBaseDir
/u02/19c_patches/33182768/33192793
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2021, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/grid/product/19.3.0.0
Central Inventory : /u01/app/oraInventory
from : /u01/app/grid/product/19.3.0.0/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatch/opatch2021-12-09_20-40-11PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
grid@ebsproddb1:/u02/19c_patches$ $ORACLE_HOME/OPatch/opatch
prereq CheckConflictAgainstOHWithDetail -phBaseDir
/u02/19c_patches/33182768/33208123
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2021, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/grid/product/19.3.0.0
Central Inventory : /u01/app/oraInventory
from : /u01/app/grid/product/19.3.0.0/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatch/opatch2021-12-09_20-40-52PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
grid@ebsproddb1:/u02/19c_patches$ $ORACLE_HOME/OPatch/opatch
prereq CheckConflictAgainstOHWithDetail -phBaseDir
/u02/19c_patches/33182768/33208107
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2021, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/grid/product/19.3.0.0
Central Inventory : /u01/app/oraInventory
from : /u01/app/grid/product/19.3.0.0/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatch/opatch2021-12-09_20-41-31PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
grid@ebsproddb1:/u02/19c_patches$ $ORACLE_HOME/OPatch/opatch
prereq CheckConflictAgainstOHWithDetail -phBaseDir
/u02/19c_patches/33182768/33239955
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2021, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/grid/product/19.3.0.0
Central Inventory : /u01/app/oraInventory
from : /u01/app/grid/product/19.3.0.0/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatch/opatch2021-12-09_20-42-00PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
grid@ebsproddb1:/u02/19c_patches$ $ORACLE_HOME/OPatch/opatch
prereq CheckConflictAgainstOHWithDetail -phBaseDir
/u02/19c_patches/33182768/32585572
Oracle Interim Patch Installer version 12.2.0.1.28
Copyright (c) 2021, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/grid/product/19.3.0.0
Central Inventory : /u01/app/oraInventory
from : /u01/app/grid/product/19.3.0.0/oraInst.loc
OPatch version : 12.2.0.1.28
OUI version : 12.2.0.7.0
Log file location : /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatch/opatch2021-12-09_20-42-12PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
grid@ebsproddb1:/u02/19c_patches$
root@ebsproddb1:~# cat
AHCOCI.env
#export ORACLE_HOME=/u01/app/grid_home
export ORACLE_HOME=/u01/app/grid/product/19.3.0.0
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_SID=+ASM
root@ebsproddb1:~#
Run
analyze to check any conflicts in GRID HOME:
grid@ebsproddb1:~$ crsctl check has
CRS-4638: Oracle High Availability Services is online
grid@ebsproddb1:~$
root@ebsproddb1:~# . AHCOCI.env
root@ebsproddb1:~# opatchauto
apply /u02/19c_patches/33182768 -analyze -oh /u01/app/grid/product/19.3.0.0
which: no sudo in (/bin:/usr/bin:/usr/local/bin:/u01/app/grid/product/19.3.0.0/bin:/u01/app/grid/product/19.3.0.0/OPatch::/usr/bin:/usr/sbin)
OPatchauto session is initiated at Thu Dec 9 21:14:59 2021
System initialization log file is /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchautodb/systemconfig2021-12-09_09-15-10PM.log.
Session log file is /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchauto/opatchauto2021-12-09_09-15-20PM.log
The id for this session is T7GX
Executing OPatch prereq operations to verify patch applicability on home /u01/app/grid/product/19.3.0.0
Patch applicability verified successfully on home /u01/app/grid/product/19.3.0.0
Executing patch validation checks on home /u01/app/grid/product/19.3.0.0
Patch validation checks successfully completed on home /u01/app/grid/product/19.3.0.0
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:ebsproddb1
SIHA Home:/u01/app/grid/product/19.3.0.0
Version:19.0.0.0.0
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /u02/19c_patches/33182768/33208123
Log: /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchauto/core/opatch/opatch2021-12-09_21-15-46PM_1.log
Patch: /u02/19c_patches/33182768/33208107
Log: /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchauto/core/opatch/opatch2021-12-09_21-15-46PM_1.log
Patch: /u02/19c_patches/33182768/32585572
Log: /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchauto/core/opatch/opatch2021-12-09_21-15-46PM_1.log
Patch: /u02/19c_patches/33182768/33239955
Log: /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchauto/core/opatch/opatch2021-12-09_21-15-46PM_1.log
Patch: /u02/19c_patches/33182768/33192793
Log: /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchauto/core/opatch/opatch2021-12-09_21-15-46PM_1.log
OPatchauto session completed at Thu Dec 9 21:16:52 2021
Time taken to complete the session 1 minute, 53 seconds
root@ebsproddb1:~#
grid@ebsproddb1:~$ cluvfy
-version
Version 19.0.0.0.0 Build 070320solaris64
Full version 19.8.0.0.0
grid@ebsproddb1:~$
root@ebsproddb1:~# .
AHCOCI.env
root@ebsproddb1:~#
grid@ebsproddb1:~$ crsctl
check has
CRS-4638: Oracle High Availability Services is online
grid@ebsproddb1:~$
For
Standalone Grid Server issue with -oh GRID_HOME:
root@ebsproddb1:~# opatchauto
apply /u02/19c_patches/33182768 -oh /u01/app/grid/product/19.3.0.0 ( approx. 30 Mins on TetM7)
which: no sudo in (/bin:/usr/bin:/usr/local/bin:/u01/app/grid/product/19.3.0.0/bin:/u01/app/grid/product/19.3.0.0/OPatch::/u01/app/grid/product/19.3.0.0/bin:/u01/app/grid/product/19.3.0.0/OPatch::/usr/bin:/usr/sbin)
OPatchauto session is initiated at Thu Dec 9 21:38:48 2021
System initialization log file is /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchautodb/systemconfig2021-12-09_09-38-59PM.log.
Session log file is /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchauto/opatchauto2021-12-09_09-39-09PM.log
The id for this session is 32TJ
Executing OPatch prereq operations to verify patch applicability on home /u01/app/grid/product/19.3.0.0
Patch applicability verified successfully on home /u01/app/grid/product/19.3.0.0
Executing patch validation checks on home /u01/app/grid/product/19.3.0.0
Patch validation checks successfully completed on home /u01/app/grid/product/19.3.0.0
Performing prepatch operations on CRS - bringing down CRS service on home /u01/app/grid/product/19.3.0.0
Prepatch operation log file location: /u01/app/grid/crsdata/ebsproddb1/crsconfig/hapatch_2021-12-09_09-40-41PM.log
CRS service brought down successfully on home /u01/app/grid/product/19.3.0.0
Start applying binary patch on home /u01/app/grid/product/19.3.0.0
Binary patch applied successfully on home /u01/app/grid/product/19.3.0.0
Performing postpatch operations on CRS - starting CRS service on home /u01/app/grid/product/19.3.0.0
Postpatch operation log file location: /u01/app/grid/crsdata/ebsproddb1/crsconfig/hapatch_2021-12-09_10-08-00PM.log
CRS service started successfully on home /u01/app/grid/product/19.3.0.0
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:ebsproddb1
SIHA Home:/u01/app/grid/product/19.3.0.0
Version:19.0.0.0.0
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /u02/19c_patches/33182768/32585572
Log: /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchauto/core/opatch/opatch2021-12-09_21-51-05PM_1.log
Patch: /u02/19c_patches/33182768/33192793
Log: /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchauto/core/opatch/opatch2021-12-09_21-51-05PM_1.log
Patch: /u02/19c_patches/33182768/33208107
Log: /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchauto/core/opatch/opatch2021-12-09_21-51-05PM_1.log
Patch: /u02/19c_patches/33182768/33208123
Log: /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchauto/core/opatch/opatch2021-12-09_21-51-05PM_1.log
Patch: /u02/19c_patches/33182768/33239955
Log: /u01/app/grid/product/19.3.0.0/cfgtoollogs/opatchauto/core/opatch/opatch2021-12-09_21-51-05PM_1.log
OPatchauto session completed at Thu Dec 9 22:08:58 2021
Time taken to complete the session 30 minutes, 11 seconds
root@ebsproddb1:~#
root@ebsproddb1:~# crsctl
query has releasepatch
Oracle Clusterware release patch level is [733960997] and the complete list of patches [32585572 33192793 33208107 33208123 33239955 ] have been applied on the local node. The release patch string is [19.13.0.0.0].
root@ebsproddb1:~#
root@ebsproddb1:~# asmcmd
-V
asmcmd version 19.13.0.0.0
root@ebsproddb1:~#
grid@ebsproddb1:~$ . oraenv
ORACLE_SID = [grid] ? +ASM
The Oracle base remains unchanged with value /u01/app/grid
grid@ebsproddb1:~$ asmcmd -p
ASMCMD [+] > showversion --releasepatch
ASM version : 19.13.0.0.0
ASMCMD [+] >
all
the patches listed in patch folder of GRID-19.13 (33182768) are applied to GRID
HOME can be checked with grid user:
$ORACLE_HOME/OPatch/opatch lspatches
$ORACLE_HOME/OPatch/opatch lsinventory | grep description
$ORACLE_HOME/OPatch/opatch lsinventory | grep applied
pwd
$ORACLE_HOME/OPatch/opatch lsinventory | grep 33239955
$ORACLE_HOME/OPatch/opatch lsinventory | grep 33208123
$ORACLE_HOME/OPatch/opatch lsinventory | grep 33192793
$ORACLE_HOME/OPatch/opatch lsinventory | grep 32585572
$ORACLE_HOME/OPatch/opatch lsinventory | grep 33208107
grid@ebsproddb1:~$ $ORACLE_HOME/OPatch/opatch lsinventory | grep 33239955
Patch 33239955 : applied on Thu Dec 09 22:07:46 AST 2021
Patch description: "TOMCAT RELEASE UPDATE 19.0.0.0.0 (33239955)"
grid@ebsproddb1:~$
grid@ebsproddb1:~$
grid@ebsproddb1:~$ $ORACLE_HOME/OPatch/opatch lsinventory | grep 33208123
Patch 33208123 : applied on Thu Dec 09 22:05:55 AST 2021
Patch description: "OCW RELEASE UPDATE 19.13.0.0.0 (33208123)"
grid@ebsproddb1:~$
grid@ebsproddb1:~$ $ORACLE_HOME/OPatch/opatch lsinventory | grep 33192793
Patch 33192793 : applied on Thu Dec 09 21:55:57 AST 2021
Patch description: "Database Release Update : 19.13.0.0.211019 (33192793)"
grid@ebsproddb1:~$
grid@ebsproddb1:~$ $ORACLE_HOME/OPatch/opatch lsinventory | grep 32585572
Patch 32585572 : applied on Thu Dec 09 21:51:46 AST 2021
Patch description: "DBWLM RELEASE UPDATE 19.0.0.0.0 (32585572)"
grid@ebsproddb1:~$
grid@ebsproddb1:~$ $ORACLE_HOME/OPatch/opatch lsinventory | grep 33208107
Patch 33208107 : applied on Thu Dec 09 22:04:01 AST 2021
Patch description: "ACFS RELEASE UPDATE 19.13.0.0.0 (33208107)"
grid@ebsproddb1:~$
grid@ebsproddb1:~$
grid@ebsproddb1:~$ crsctl
check has
CRS-4638: Oracle High Availability Services is online
grid@ebsproddb1:~$
root@ahcsc1zdbclient010102:~# crsctl query has releasepatch
Oracle Clusterware release patch level is [733960997] and the complete list of patches [32585572 33192793 33208107 33208123 33239955 ] have been applied on the local node. The release patch string is [19.13.0.0.0].
root@ahcsc1zdbclient010102:~#
grid@ebsproddb1:~$
grid@ebsproddb1:~$ .
oraenv
ORACLE_SID = [grid] ? +ASM
The Oracle base remains unchanged with value /u01/app/grid
grid@ebsproddb1:~$ sqlplus
/ as sysasm
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 9 22:29:51 2021
Version 19.13.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.13.0.0.0
SQL>
Finally Stop and start GRID and Database with upgraded version you should not get any permission issue:
grid@ebsproddb1:~$ crsctl stop has
grid@ebsproddb1:~$ crsctl start has
grid@ebsproddb1:~$ crsctl check has
grid@ebsproddb1:~$
grid@ebsproddb1:~$ srvctl status database -d DELL
Best practice: Keep the backup of old binaries till one month.
################################################################################################################
################################################################################################################
Known Issues:
grid@ebsproddb1:~$ asmcmd -p
Can't locate strict.pm: /u01/app/grid/product/19.3.0.0/perl/lib/5.28.1/strict.pm: Permission denied at /u01/app/grid/product/19.3.0.0/bin/asmcmdcore line 208.
BEGIN failed--compilation aborted at /u01/app/grid/product/19.3.0.0/bin/asmcmdcore line 208.
grid@ebsproddb1:~$
Thanks for Reading
Regards,
Mohammed Areefuddin.
Suggested Topics :
Linux | DATABASE | RMAN | RAC | EBS |
| R1229 M7 Clone | ||||
| RAC DataGuard | Pluggable DB Clone | |||
| appsutil for DB | ||||
| JDK JRE upgrade | ||||
| Add EBS Node | ||||
No comments:
Post a Comment