Advertisement

Friday, November 29, 2019

Oracle Database 18c: Installing Latest RU (18.8.0.0.0)

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 ./

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;

2 comments:
Write comments
  1. Thank you for the article
    Have you tried to roll one-off patch first, and then RU?

    ReplyDelete
  2. Thank you for the article
    Have you tried to roll one-off patch first, and then RU?

    ReplyDelete