Environment

OPatch Configuration

Extracting OPatch

Unnzip the OPatch utility to the Oracle home directory location.

Verify Version

OPatch version

Patch Preparation

Extract Patch Bundle

unzip p35962832_190000_MSWIN-x86-64.zip

Pre-Installation Conflict Check

cd 35962832
opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Configure Environment Variables

set PATH=%ORACLE_HOME%\perl\bin;%PATH%
set PERL5LIB=

Stop Database Services

Shutdown the database:

sqlplus / as sysdba
shutdown immediate
exit

Stop the listener:

lsnrctl stop

Stop distributed transaction coordinator:

net stop msdtc

Applying the Patch

Run OPatch Apply

cd 35962832
opatch apply

Verify Installation

opatch lspatches

Post-Patch Procedures

Load Modified SQL Files

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

Recompile Invalid Objects

cd %ORACLE_HOME%/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql

Confirm Version

SELECT BANNER_FULL FROM v$version;

Rolling Back the Patch

Stop Oracle Services

Shutdown the database:

sqlplus / as sysdba
shutdown immediate
quit

Stop the listener:

lsnrctl stop

Execute Rollbcak

opatch rollback -id 35962832

Reload SQL Scripts

lsnrctl start
sqlplus /nolog
connect / as sysdba
startup
quit
cd %ORACLE_HOME%/OPatch
datapatch -verbose

Recompile Objects

cd %ORACLE_HOME%/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql

Verify Version

SELECT BANNER_FULL FROM v$version;