21856522

21856522 UPGRADE OF 12.1 TO 12.2 CAUSE XOQ COMPONENT TO BE INVALID

NOTE: This patch is for the 12.1.0.2 ORACLE_HOME with the 160719 (19-Jul-2016) Bundle Patch installed.

opatch lsinventory | grep 23144544

Login as 'oracle' on the target server with the 12.1 environment set.

Check

opatch lsinventory | grep 21856522

Download from Oracle

Download p21856522_12102160719ProactiveBP_Generic.zip from My Oracle Support and stage in /u01/img/121020 on the Local Management Server.

Download from Local Management Server

NOTE: If you are not using a Local Management Server then download the patch directly from Oracle and place the zip file in /u01/img/121020 on the target server.
mkdir -p /u01/img/121020
scp -pr ${PATCH_SERVE}:/u01/img/121020/p21856522_12102160719ProactiveBP_Generic.zip /u01/img/121020
cd /u01/img/121020
rm -rf /u01/img/121020/21856522
find . -name "p21856522_12102160719ProactiveBP_Generic.zip" -exec unzip {} \;
rm *.zip

Pre-req check

cd /u01/img/121020/21856522
opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Install

sqlplus / as sysdba
shutdown immediate
exit
lsnrctl stop ${LISTENER_NAME}

cd /u01/img/121020/21856522
opatch apply -silent -ocmrf /u01/img/ocm.rsp
opatch lsinventory | grep 21856522

NOTE: Startup database and Listener if necessary before continuing (if you have more patches to apply yo may wish to skip this step).If you are patching a Physical Standby remember to use: startup mount.
sqlplus / as sysdba
startup
exit
lsnrctl start ${LISTENER_NAME}

Rollback

cd /u01/img/121020/21856522opatch rollback -id 21856522
opatch lsinventory | grep 21856522