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
- If
datapatch -verbosefails withError at line 0: Could not open logfile..., temporarily setNLS_LANGto an American value, for example:export NLS_LANG=AMERICAN_AMERICA.<charset>. - Always read the patch README: the exact steps depend on the Oracle version and the patch type.