Oracle Grid and Database 19.3 Patchset Update to 19.10
Patch 32226239 - GI Release Update 19.10.0.0.210119
Oracle Grid and Database 19.3 Patchset Update to 19.10
Patch 32226239 - GI Release Update 19.10.0.0.210119
## Set Patch Home - Database Home - Grid Home
PH=/oracle/patch
DH=/oracle/product/19.3/dbhome_1
GH=/oracle/grid
## You must use the OPatch utility version 12.2.0.1.23 or later
## Update Opatch versiyon for grid home and database home
mv p6880880_190000_Linux-x86-64.zip opatch.zip
$DH/OPatch/opatch version
$GH/OPatch/opatch version
unzip opatch.zip -d $DH
unzip opatch.zip -d $GH
## Validation of Oracle Inventory
$DH/OPatch/opatch lsinventory -detail -oh $DH
$GH/OPatch/opatch lsinventory -detail -oh $GH
## OPatch Conflict Check
$GH/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir $PH/32226239/32218454
$GH/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir $PH/32226239/32222571
$GH/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir $PH/32226239/32218663
$GH/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir $PH/32226239/29340594
$GH/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir $PH/32226239/32240590
$DH/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir $PH/32226239/32218454
$DH/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir $PH/32226239/32222571
## OPatch SystemSpace Check
touch /tmp/patch_list_gihome.txt
echo $PH/32226239/32218454 >> /tmp/patch_list_gihome.txt
echo $PH/32226239/32222571 >> /tmp/patch_list_gihome.txt
echo $PH/32226239/32218663 >> /tmp/patch_list_gihome.txt
echo $PH/32226239/29340594 >> /tmp/patch_list_gihome.txt
echo $PH/32226239/32240590 >> /tmp/patch_list_gihome.txt
$GH/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
touch /tmp/patch_list_dbhome.txt
echo $PH/32226239/32218454 >> /tmp/patch_list_dbhome.txt
echo $PH/32226239/32222571 >> /tmp/patch_list_dbhome.txt
$DH/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt
## One-off Patch Conflict Detection and Resolution
## How to Use the My Oracle Support Conflict Checker Tool for Patches Installed with OPatch [Video] (Doc ID 1091294.1) --> My Oracle Support Conflict Checker tool
cd $GH/cfgtoollogs/opatch/lsinv
cd $DH/cfgtoollogs/opatch/lsinv
su root
PH=/oracle/patch
DH=/oracle/product/19.3/dbhome_1
GH=/oracle/grid
export PATH=$PATH:$GH/OPatch
opatchauto apply $PH/32226239 -oh $GH
## if rollback needed # opatchauto rollback $PH/32226239 -oh $GH
## Check Patches Status
$GH/OPatch/opatch lspatches
32240590;TOMCAT RELEASE UPDATE 19.0.0.0.0 (32240590)
32222571;OCW Interim patch for 32222571
32218663;ACFS RELEASE UPDATE 19.10.0.0.0 (32218663)
32218454;Database Release Update : 19.10.0.0.210119 (32218454)
29340594;DBWLM RELEASE UPDATE 19.0.0.0.0 (29340594)
OPatch succeeded.
## Database Patch
su - oracle
lsnrctl stop
srvctl stop database -d <DBNAME>
cd $PH/32226239/32218454
$DH/OPatch/opatch apply
$DH/OPatch/opatch lspatches
32218454;Database Release Update : 19.10.0.0.210119 (32218454)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
srvctl start database -d <DBNAME>
## Recompile RMAN Packeges and Procedures at Sql Plus
sql>@$ORACLE_HOME/rdbms/admin/dbmsrman.sql
sql>@$ORACLE_HOME/rdbms/admin/prvtrmns.plb
sql>@$ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
sql>@$ORACLE_HOME/rdbms/admin/prvtbkrs.plb
Etiketler :
Oracle