In this quick blog I am going to discuss on how to apply the Release Update (18.8.0.0.0) to Database Home.
You should
Download the Patches First (p30112122 and Latest Opatch 6880880)
$ wget 'https://updates.oracle.com/Orion/Services/download/p30112122_180000_Linux-x86-64.zip?aru=23124066&patch_file=p30112122_180000_Linux-x86-64.zip' --http-user=<MOS Username> --http-password=<MOS_Password> --no-check-certificate --output-document=p30112122_180000_Linux-x86-64.zip
$ wget 'https://updates.oracle.com/Orion/Services/download/p6880880_180000_Linux-x86-64.zip?aru=23213107&patch_file=p6880880_180000_Linux-x86-64.zip' --http-user=<MOS Username> --http-password=<MOS_Password> --no-check-certificate --output-document=p6880880_180000_Linux-x86-64.zip
Next Unzip OPatch
$ cd $ORACLE_HOME
$ mv OPatch OPatch_29112019
$ unzip -qq /u01/Patch/p6880880_180000_Linux-x86-64.zip
Pre-req Check
$ unzip -qq p30112122_180000_Linux-x86-64.zip
$ cd 30112122
$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
You should
Download the Patches First (p30112122 and Latest Opatch 6880880)
$ wget 'https://updates.oracle.com/Orion/Services/download/p30112122_180000_Linux-x86-64.zip?aru=23124066&patch_file=p30112122_180000_Linux-x86-64.zip' --http-user=<MOS Username> --http-password=<MOS_Password> --no-check-certificate --output-document=p30112122_180000_Linux-x86-64.zip
$ wget 'https://updates.oracle.com/Orion/Services/download/p6880880_180000_Linux-x86-64.zip?aru=23213107&patch_file=p6880880_180000_Linux-x86-64.zip' --http-user=<MOS Username> --http-password=<MOS_Password> --no-check-certificate --output-document=p6880880_180000_Linux-x86-64.zip
Next Unzip OPatch
$ cd $ORACLE_HOME
$ mv OPatch OPatch_29112019
$ unzip -qq /u01/Patch/p6880880_180000_Linux-x86-64.zip
Pre-req Check
$ unzip -qq p30112122_180000_Linux-x86-64.zip
$ cd 30112122
$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Patch Apply
$ unzip -qq p30112122_180000_Linux-x86-64.zip
$ cd 30112122
$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
opatch apply
Data Patch Apply (Post Patch)
$ cd $ORACLE_HOME/OPatch
$ startup;
$ ./datapatch -verbose
$ sqlplus / as sysdba
$ @utlrp.sql
Catalog Upgrade (Post Patch)
$ rman catalog username/password@alias
$ uprade catalog;
$ upgrade catalog;
Thank you for the article
ReplyDeleteHave you tried to roll one-off patch first, and then RU?
Thank you for the article
ReplyDeleteHave you tried to roll one-off patch first, and then RU?