download latest opatch from oracle support. backup database full and or create guaranteed restore point stop database and listener. cd $ORACLE_HOME mv OPatch OPatch_old unzip -o /opatchid -d $ORACLE_HOME cd OPatch ./opatch version # should be latest version stop database and listener cd /patch_dir/patchid export ORACLE_HOME=/u02/app/oracle/product/19c export ORACLE_SID=pune export PATH=$ORACLE_HOME/bin:$PATH echo $ORACLE_HOME # verify environment variables correctly exported ./opatch prereq CheckConflictAgainstOHWithDetail -ph /patch_dir/patchid # check conflict ./opatch apply -oh $ORACLE_HOME # if everything feels good then fine otherwise rollback the patch ./opatch rollback -id
Thanks for the video. But how to install it on windows?
as per my experience it's not having good performance on windows so better to use vmware/virtualbox and build vm to run oracle database.
@@kayyum698 do you have any video step to apply patch on oracle 21c?
the steps are same irrespective of any version.
@@nishitkawane it's not possible to do patching if you don't have oracle support license
download latest opatch from oracle support.
backup database full and or create guaranteed restore point
stop database and listener.
cd $ORACLE_HOME
mv OPatch OPatch_old
unzip -o /opatchid -d $ORACLE_HOME
cd OPatch
./opatch version # should be latest version
stop database and listener
cd /patch_dir/patchid
export ORACLE_HOME=/u02/app/oracle/product/19c
export ORACLE_SID=pune
export PATH=$ORACLE_HOME/bin:$PATH
echo $ORACLE_HOME # verify environment variables correctly exported
./opatch prereq CheckConflictAgainstOHWithDetail -ph /patch_dir/patchid # check conflict
./opatch apply -oh $ORACLE_HOME
# if everything feels good then fine otherwise rollback the patch
./opatch rollback -id