Patch

To find the latest patch update:

Master Note for Database Proactive Patch Program (Doc ID 756671.1)

Important post steps on database side (better follow readme):

11g

1. Run catbundle
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
@catbundle.sql psu apply
quit

2. Compile objects:

$ORACLE_HOME/rdbms/admin/utlrp.sql

3. OJVM components:
cd $ORACLE_HOME/sqlpatch/<PATCHID>
sqlplus /nolog
CONNECT / AS SYSDBA
STARTUP
alter system set cluster_database=false scope=spfile;
SHUTDOWN
STARTUP UPGRADE
@postinstall.sql
alter system set cluster_database=true scope=spfile;
SHUTDOWN IMMEDIATE

srvctl start database -d DBNAME

- DBNAME refer to db_unique_name
4. Verify patch:
dba_registry_history

12c:


1. Instead of catbundle use

./datapatch -verbose


2. Verify patch:

select BUNDLE_SERIES,PATCH_UID,PATCH_ID,
VERSION,ACTION,STATUS,ACTION_TIME ,DESCRIPTION
from dba_registry_sqlpatch;