On windows environment the patch type to be applied on Oracle is BP (Bundle Patch)
Set your PATH setting as follows:
Ensure that Oracle database services in windows are stopped
Stop the Distributed Transaction Coordinator service:
net stop msdtc
Go to the location of your patch directory.
** Important Remark: download the latest Opatch utility from Oracle MOS and place it under your Oracle Home location.
Now apply the patch by executing the following command:
Successful patch message would look like this:
In a Multitenant environment CDB/PDB follow the following steps:
Start up the listener:
lsnrctl start LISTENER
startup all Oracle Services:
alter pluggable database all open;
******* It’s advisable to recompile all database objects after patching and ensure that all database components are “VALID”;
To check that the database patch applied successfully use the following query:
SQL> select * from dba_registry_sqlpatch ;
As shown below the patch applied 18.104.22.168.161018 (18th October 2016 Patch released for Oracle 12c)
You can perform the same query on one of the pluggable databases:
SQL> alter session set container=PDB_TEST;
SQL> select ACTION,STATUS, DESCRIPTION,LOGFILE from dba_registry_sqlpatch ;
The log file references the pluggable database name.