LLI Wiki — My Digital Knowledge Base

Oracle: updating OPatch and applying a PSU/OJVM patch on Linux

Steps to back up and update OPatch, apply a PSU and an OJVM patch, then run datapatch.

Typical procedure to update OPatch and apply a patch (PSU and OJVM) on an Oracle database running on Linux, with the checks to run before and after.

Preparation

Stop the database:

. oraenv
sqlplus / as sysdba
shutdown immediate
exit

On a Red Hat server, check the subscriptions and update the OS if needed:

sudo subscription-manager list --consumed
sudo subscription-manager list
yum update

Check the JRE

cd $ORACLE_HOME/jdk/bin
java -version
select comp_name, version, status from dba_registry;

select owner, status, count(*) from all_objects
 where object_type like '%JAVA%' group by owner, status;

select role from dba_roles where role like '%JAVA%';

To force a specific JRE with OPatch:

./opatch lsinventory -jre $ORACLE_HOME/jdk/jre/

Update OPatch

Back up the current OPatch directory:

DATE=$(date '+%Y%m%d%H%M%S')
cd $ORACLE_HOME
tar -zcvf OPatch-$DATE.tgz $ORACLE_HOME/OPatch
mv *.tgz <backup_folder>/
tar -tvf <backup_folder>/OPatch-$DATE.tgz

Install the new version (patch 6880880 downloaded from My Oracle Support; adapt the file name to the database version):

cp ~/p6880880_<version>_Linux-x86-64.zip $ORACLE_HOME
cd $ORACLE_HOME
rm -rf OPatch/
unzip p6880880_<version>_Linux-x86-64.zip
cd OPatch
./opatch lsinventory
export PATH=$PATH:$ORACLE_HOME/OPatch

Check object status before patching

SELECT COUNT(*) invalid_object
  FROM dba_objects dos
 WHERE dos.status = 'INVALID';

SELECT OBJECT_NAME
  FROM dba_objects dos
 WHERE dos.status = 'INVALID';

Note the existing invalid objects so you can compare after patching.

Apply the PSU

With the database stopped (shutdown immediate), from the unzipped patch directory:

export PATH=$PATH:/usr/ccs/bin
cd <PATCH_TOP_DIR>/<patch_number>
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
opatch apply

If needed, specify the JRE: opatch prereq CheckConflictAgainstOHWithDetail -ph ./ -jre $ORACLE_HOME/jdk/.

Restart the database, then apply the SQL part of the patch:

sqlplus /nolog
connect / as sysdba
startup
quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose

Apply the OJVM patch

Same approach, but the database must be started in upgrade mode for datapatch:

opatch lsinventory
cd <PATCH_TOP_DIR>/<ojvm_patch_number>
# database stopped
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
opatch apply
connect / as sysdba
startup upgrade
quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose
connect / as sysdba
shutdown
startup

Post-patch checks

$ORACLE_HOME/OPatch/opatch lsinventory

Count invalid objects again and recompile them if needed:

SELECT COUNT(*) invalid_object
  FROM dba_objects dos
 WHERE dos.status = 'INVALID';

Notes

Mastodon LLIMastodon SocialFosstodon