1Z0-1085-20: Oracle Cloud Infrastructure Foundations 2020 Associate

Hello Folks,
I'm glad to share my recent achievement with Oracle cloud. I have taken Oracle examination 1Z0-1085-20: Oracle Cloud Infrastructure Foundations 2020 Associate.

If your also looking for same examination. Oracle is offering multiple free training's and certifications until May 15,2020.
you may refer to below link for reference.
https://www.oracle.com/corporate/blog/free-certifications-oracle-oci-autonomous-033020.html

To achieve this certification below are given general details.

Your can refer to below screens to review the exam topics.

You can review Oracle documentation to get into details of these topics.

https://docs.cloud.oracle.com/en-us/iaas/Content/home.htm

Happy Learning !!!

Guide to register to Oracle Cloud Infrastructure and Autonomous Database free certification program

This document will guide how to register to Oracle Cloud Infrastructure and Autonomous Database free certification on pearsonvue.com.which is available until May 15 2020.

1. Access Oracle blog to get list of Oracle online training.
https://www.oracle.com/corporate/blog/free-certifications-oracle-oci-autonomous-033020.html

2. Click on appropriate training which you want to take training and want to go for certification.

3. It will redirect to online training and at the end you will see certification link. Click on certification.

4. It will redirect to pearsonvue.com/oracle. Login to your account.

5. Choose the option where you want to take examination. If at Home or Office click on Run prechecks. 

6. It will perform check for Microphone, Internet speed and Webcam.

7. Agree to examination policies.

8. Review exam and system details.

9. Confirm exam details and you have an option to add another exam on same date.

10. Appointment calendar will display with available dates and times. Choose your preferred date and time. 

11. Review detail and click on proceed to checkout.

12. Accept agreement. 

13. Discount will be applied automatically. 

14. Review final details and submit the order.

15. Your exam booking has done, you will receive an email from pearsonvue with details.

16. On exam day, If you choose to take exam at home. Please refer to below link and download required software and run the software.

http://www.pearsonvue.com/oracle/op/

17. Once you run the software, below screen will display.Test the system first.

18. On the next screen you will see access code.copy it.

19. Next window will prompt to enter the access code and your mobile number.

20. On next window, choose an appropriate option as per your age.

21. It will perform system test, which checks Microphone, Internet speed and Webcam.

22. Choose an option how you want to proceed next. you can enter your mobile number and choose to get text with link to perform further tasks.Which will includes to click your photo, click photo of your Identity proof (for example passport) front and back, then click photos of your workstation place. Thereafter, completing all the formalities, you will be prompted to kick start your exam. 

Best of Luck and Happy Learning !!!

Source:- Oracle.com

Apply system patch on Oracle Enterprise Manager

Patch 21144218: MERGE REQUEST ON TOP OF EMBP PSU 12.1.0.3.3 FOR BUGS 19709131 20349358

 1. Prerequisites

Oracle WebLogic Administration server is up and running.
Oracle Database Management Repository and its listener are up and running.
latest version of OPatch 11.1.
set the ORACLE_HOME and PATH environment variable to OMS core home

export ORACLE_HOME=/u01/app/oracle/product/middleware/oms/bin:$ORACLE_HOME:
export PATH=/home/oracle/empatches/21144218/:$HOME/.local/bin:/usr/bin:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH:


1.1 verify Oracle Home inventory.

opatchauto lspatches

2. Install the patch
2.1 shut down the OMS
emctl stop oms

2.2 Install the patch. it will prompt for Weblogic server URL,username and password. Alternatively you can crate property file and give path of the property file.

opatchauto apply –analyze 
opatchauto apply

2.3 Start all the OMS.
emctl start oms

3. Rollback.
3.1 shut down the OMS
emctl stop oms

3.2 Deinstall the patch
opatchauto rollback -id 21144218

3.3 Start the OMS.
emctl start oms

Reference:- Please refer to README file attached with patch for list of known issues and detailed instructions. 

java.lang.OutOfMemoryError: Java heap space

During Oracle WebLogic Server Patching, we had encountered below error. java.lang.OutOfMemoryError: Java heap space

1. Review downloaded patches. Execution of this command thrown error.

./bsu.sh -view -status=downloaded -prod_dir=/u01/app/oracle/product/middleware/wlserver_10.3 -patch_download_dir=/u01/app/oracle/product/middleware/utils/bsu/cache_dir


Error:-


Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
        at com.bea.plateng.common.util.io.XorInputStream.read(XorInputStream.java:38)
 Exception in thread "Thread-0" Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class com.bea.plateng.patch.PatchSystem
        at com.bea.plateng.patch.PatchClientHelper.getAllPatchDetails(PatchClientHelper.java:74)
        at com.bea.plateng.patch.PatchInstallationHelper.cleanupPatchSets(PatchInstallationHelper.java:130)
        at com.bea.plateng.patch.PatchTarget.<init>(PatchTarget.java:272)
        at com.bea.plateng.patch.PatchTargetFactory.create(PatchTargetFactory.java:30)
        at com.bea.plateng.patch.PatchTargetHelper.getPatchTargets(PatchTargetHelper.java:204)
        at com.bea.plateng.patch.PatchTargetHelper.updatePatchTargets(PatchTargetHelper.java:119)
        at com.bea.plateng.patch.PatchTargetHelper.getAllPatchTargets(PatchTargetHelper.java:74)
        at com.bea.plateng.patch.PatchTargetHelper.getPatchTarget(PatchTargetHelper.java:247)
        at com.bea.plateng.patch.Patch.getPatchTarget(Patch.java:432)
        at com.bea.plateng.patch.Patch.getPatchTarget(Patch.java:416)
        at com.bea.plateng.patch.Patch.main(Patch.java:251)
java.lang.OutOfMemoryError: Java heap space
        at java.util.LinkedHashMap.newValueIterator(LinkedHashMap.java:397)
        at java.util.HashMap$Values.iterator(HashMap.java:910)
        at java.util.AbstractCollection.toArray(AbstractCollection.java:120)
        at java.util.ArrayList.addAll(ArrayList.java:472)
        at org.apache.xmlbeans.impl.schema.SchemaTypeImpl.getProperties(SchemaTypeImpl.java:705)
        at com.bea.cie.common.dao.xbean.XBeanDataHandler.loadPropertyMap(XBeanDataHandler.java:775)
        at com.bea.cie.common.dao.xbean.XBeanDataHandler.<init>(XBeanDataHandler.java:99)
        at com.bea.cie.common.dao.xbean.XBeanDataHandler.createDataHandler(XBeanDataHandler.java:559)
        at com.bea.cie.common.dao.xbean.XBeanDataHandler.getComplexValue(XBeanDataHandler.java:455)
        at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:442)
        at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:464)
        at com.bea.plateng.patch.dao.cat.PatchCatalog.getPatchDependencies(PatchCatalog.java:56)

        at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getInvalidatedPatchMap(PatchCatalogHelper.java:1621)
        at com.bea.plateng.patch.PatchSystem.updatePatchCatalog(PatchSystem.java:436)
        at com.bea.plateng.patch.PatchSystem.refresh(PatchSystem.java:130)
        at com.bea.plateng.patch.PatchSystem.<init>(PatchSystem.java:114)
        at com.bea.plateng.patch.PatchSystem.<clinit>(PatchSystem.java:41)
        at com.bea.plateng.patch.PatchClientHelper.getAllPatchDetails(PatchClientHelper.java:74)
        at com.bea.plateng.patch.PatchInstallationHelper.cleanupPatchSets(PatchInstallationHelper.java:130)
        at com.bea.plateng.patch.PatchTarget.<init>(PatchTarget.java:272)
        at com.bea.plateng.patch.PatchTargetFactory.create(PatchTargetFactory.java:30)
        at com.bea.plateng.patch.ProductAliasTarget.constructPatchTargetList(ProductAliasTarget.java:88)
        at com.bea.plateng.patch.ProductAliasTarget.<init>(ProductAliasTarget.java:46)
        at com.bea.plateng.patch.ProductAliasTargetHelper.getProdAliasTargetList(ProductAliasTargetHelper.java:55)
        at com.bea.plateng.patch.ProductAliasTargetHelper.getAllHomeToProdAliasesTargetMap(ProductAliasTargetHelper.java:32)

        at com.bea.plateng.patch.ProductAliasTargetHelper.checkProfilesInProductAliases(ProductAliasTargetHelper.java:133)
        at com.bea.plateng.patch.Patch$1.run(Patch.java:376)
        at java.lang.Thread.run(Thread.java:662)


2. Check the bsu.sh file to examine the java memory size.

more bsu.sh
#!/bin/sh
 JAVA_HOME="/u01/app/oracle/product/middleware/jdk16/jdk"
MEM_ARGS="-Xms256m -Xmx512m"
"$JAVA_HOME/bin/java" ${MEM_ARGS} -jar patch-client.jar $*



3. Solution.
Increase memory in bsu.sh
MEM_ARGS="-Xms2048m -Xmx2048m"


4. Before update.

cat bsu.sh
#!/bin/sh
JAVA_HOME="/u01/app/oracle/product/middleware/jdk16/jdk"
MEM_ARGS="-Xms1024m -Xmx1024m"
"$JAVA_HOME/bin/java" ${MEM_ARGS} -jar patch-client.jar $*

5. After updating bsu.sh 


cat bsu.sh
#!/bin/sh
JAVA_HOME="/u01/app/oracle/product/middleware/jdk16/jdk"
MEM_ARGS="-Xms2048m -Xmx2048m"
"$JAVA_HOME/bin/java" ${MEM_ARGS} -jar patch-client.jar $*

 6. Now execute the script again. it must run without error.

./bsu.sh -view -status=applied -prod_dir=/u01/app/oracle/product/middleware/wlserver_10.3


ProductName:       WebLogic Server
ProductVersion:    10.3 MP6
Components:        WebLogic Server/Core Application Server,WebLogic Server/Admi
                  nistration Console,WebLogic Server/Configuration Wizard and
                   Upgrade Framework,WebLogic Server/Web 2.0 HTTP Pub-Sub Serve
                   r,WebLogic Server/WebLogic SCA,WebLogic Server/WebLogic JDBC
                    Drivers,WebLogic Server/Third Party JDBC Drivers,WebLogic S
                   erver/WebLogic Server Clients,WebLogic Server/WebLogic Web S
                   erver Plugins,WebLogic Server/UDDI and Xquery Support,WebLog
                   ic Server/Server Examples,WebLogic Server/Evaluation Databas
                   e,WebLogic Server/Workshop Code Completion Support
BEAHome:           /u01/app/oracle/product/middleware
ProductHome:       /u01/app/oracle/product/middleware/wlserver_10.3
PatchSystemDir:    /u01/app/oracle/product/middleware/utils/bsu
PatchDir:          /u01/app/oracle/product/middleware/patch_wls1036
Profile:           Default
DownloadDir:       /u01/app/oracle/product/middleware/utils/bsu/cache_dir
JavaVersion:       1.6.0_29
JavaVendor:        Sun
Patch ID:          SRUM (14482558)
Patch ID:          6D9T
Patch ID:          NIP1 (16743810,16743790,16888501)
Patch ID:          WE1X (16080294)

How to apply Patch Set Update on Oracle WebLogic Server

Oracle WebLogic Server Patch Set Update 10.3.6.0.190416
Oracle WebLogic Server Patch Set Update 10.3.6.0.190716

Patch 29204678: SU Patch U5I2:WLS PATCH SET UPDATE 10.3.6.0.190416
Patch 29633432: SU Patch MXLE:WLS PATCH SET UPDATE 10.3.6.0.190716

Patch Number:  29204678 Patch ID -U5I2
Patch Number:  29633432 Patch ID - MXLE



1. Set environment variables.


export WLS_HOME=/u01/app/oracle/product/middleware/wlserver_10.3:$WLS_HOME:
export PATH=$HOME/.local/bin:/usr/bin:$HOME/bin:$WLS_HOME/bin:$OMS_HOME/OPatch:$PATH:


2. List the patches.

 ./bsu.sh -view -status=downloaded -prod_dir=/u01/app/oracle/product/middleware/wlserver_10.3 -verbose

 ./bsu.sh -view -status=applied -prod_dir=/u01/app/oracle/product/middleware/wlserver_10.3 -patch_download_dir=/u01/app/oracle/product/middleware/utils/bsu/cache_dir


3. Stop all WebLogic servers

emctl extended oms jvmd stop -all

4. Remove any previously applied WebLogic Server Patch Set Update and associated overlay patches

./bsu.sh -remove -patchlist=SRUM,6D9T,WE1X -prod_dir=prod_dir=/u01/app/oracle/product/middleware/wlserver_10.3



5. Installing Oracle WebLogic Server Patch Set Update 10.3.6.0.190716.
unzip p29633432_1036_Generic.zip
Navigate to the {MW_HOME}/utils/bsu

./bsu.sh -install -patch_download_dir=/u01/app/oracle/product/middleware/utils/bsu/cache_dir -patchlist=U5I2 -prod_dir=/u01/app/oracle/product/middleware/wlserver_10.3

./bsu.sh -install -patch_download_dir=/u01/app/oracle/product/middleware/utils/bsu/cache_dir -patchlist=MXLE -prod_dir=/u01/app/oracle/product/middleware/wlserver_10.3



6. Start WebLogic servers
emctl extended oms jvmd start -all


7. Check the Status.

./bsu.sh -view -status=applied -prod_dir=/u01/app/oracle/product/middleware/wlserver_10.3 -patch_download_dir=/u01/app/oracle/product/middleware/utils/bsu/cache_dir



8.The following command is a simple way to determine the application of WebLogic Server PSU.

  $ $WL_HOME/server/bin/setWLSEnv.sh
  $ java weblogic.version


Reference:- For detailed instructions and known issues, Please refer to README file attached with patch. 

Recompile Invalid Objects in Oracle Database

We usually experience Invalid objects in oracle database after importing database or schema using Datapump Export/Import or after database upgrade.


Execute utlrp.sql to recompile invalid objects in database.

SQL> @?/rdbms/admin/utlrp.sql


1.Check the number of invalid objects remaining. This number should decrease with time.

SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);


2.Check number of objects compiled so far. This number should increase with time.

SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;


3. Verify status of invalid objects.There should be no invalid objects.

select owner, object_name, object_type from dba_invalid_objects order by owner, object_type;

Apply July 2019 Release Update Patch on Oracle database 12c Release 2.

Please refer to README file attached to patch for details instructions, known issues and workarounds.


1. Set environment variables to Oracle Home.

export ORACLE_HOME=/u01/app/oracle/product/database/12.2.0/dbhome_1
export PATH=$HOME/.local/bin:/usr/bin:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH:



1.1. Update OPatch utility version 12.2.0.1.17 


2. After unzip, Goto into patch directory and check the conflicts with existing patches.

opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /u01/app/oracle/product/database/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/database/12.2.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/database/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-10.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.


 3. If not conflicts found in pre-requisites, Apply patch using opatch utility.


opatch apply

Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/database/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/database/12.2.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/database/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-10.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/database/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/database/12.2.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/database/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-10.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   29757449
Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/database/12.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying interim patch '29757449' to OH '/u01/app/oracle/product/database/12.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.2.0.1.0 ] , [ oracle.ons.daemon, 12.2.0.1.0 ] , [ oracle.oid.client, 12.2.0.1.0 ] , [ oracle.network.cman,

12.2.0.1.0 ] , [ oracle.jdk, 1.8.0.211.12 ]  not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 12.2.0.1.0...
Patching component oracle.rdbms, 12.2.0.1.0...
Patching component oracle.network.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.util, 12.2.0.1.0...
Patching component oracle.ctx, 12.2.0.1.0...
Patching component oracle.ctx.rsf, 12.2.0.1.0...
Patching component oracle.ldap.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...
Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0...
Patching component oracle.sdo, 12.2.0.1.0...
Patching component oracle.sdo.locator, 12.2.0.1.0...
Patching component oracle.tfa, 12.2.0.1.0...
Patching component oracle.xdk.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.rman, 12.2.0.1.0...
Patching component oracle.assistants.deconfig, 12.2.0.1.0...
Patching component oracle.xdk, 12.2.0.1.0...
Patching component oracle.precomp.rsf, 12.2.0.1.0...
Patching component oracle.sqlplus, 12.2.0.1.0...
Patching component oracle.assistants.acf, 12.2.0.1.0...
Patching component oracle.ldap.rsf.ic, 12.2.0.1.0...
Patching component oracle.rdbms.oci, 12.2.0.1.0...
Patching component oracle.rdbms.dv, 12.2.0.1.0...
Patching component oracle.rdbms.crs, 12.2.0.1.0...
Patching component oracle.rdbms.install.plugins, 12.2.0.1.0...
Patching component oracle.oraolap, 12.2.0.1.0...
Patching component oracle.install.deinstalltool, 12.2.0.1.0...
Patching component oracle.oracore.rsf, 12.2.0.1.0...
Patching component oracle.xdk.parser.java, 12.2.0.1.0...
Patching component oracle.sqlplus.ic, 12.2.0.1.0...
Patching component oracle.ldap.client, 12.2.0.1.0...
Patching component oracle.nlsrtl.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.lbac, 12.2.0.1.0...
Patching component oracle.assistants.server, 12.2.0.1.0...
Patching component oracle.ons, 12.2.0.1.0...
Patching component oracle.rdbms.deconfig, 12.2.0.1.0...
Patching component oracle.precomp.common, 12.2.0.1.0...
Patching component oracle.precomp.lang, 12.2.0.1.0...
Patching component oracle.ctx.atg, 12.2.0.1.0...
OPatch found the word "error" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
chmod: changing permissions of `/u01/app/oracle/product/database/12.2.0/dbhome_1/bin/extjobO': Operation not permitted
make: [iextjob] Error 1 (ignored)
Patch 29757449 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/database/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-10.log
OPatch completed with warnings.


4. Verify newly applied patch on Inventory. 

opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.
 Oracle Home       : /u01/app/oracle/product/database/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/database/12.2.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/database/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-10-04.log
Lsinventory Output file location : /u01/app/oracle/product/database/12.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-10-04.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: host01.domain.local
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c                                                  12.2.0.1.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch  29757449     : applied on Fri Oct 04 11:57:39 CEST 2019
Unique Patch ID:  23009673
Patch description:  "Database Jul 2019 Release Update : 12.2.0.1.190716 (29757449)"
   Created on 9 Jul 2019, 21:38:38 hrs PST8PDT
   Bugs fixed:

     8480838, 8932139, 12763598, 13554903, 14221306, 14690846, 15931756

     16002385, 16438495, 16727454, 16942578, 17027695, 17533661, 17947871

     18308268, 18521691, 18594510, 18774543, 18878420, 19072655, 19211433

     19285025, 19327292, 19526548, 19614243, 19647894, 19649997, 19702201

     19721304, 20003668, 20087519, 20118035, 20120236, 20324049, 20436508

     20532077, 20588486, 20591151, 20617383, 20620169, 20736227, 20756305

     20866970, 20976443, 21089435, 21095391, 21143725, 21147908, 21159907

     21178363, 21186167, 21197098, 21216226, 21320338, 21433452, 21479706

     21517767, 21520266, 21547051, 21638600, 21744603, 21882528, 21981529

     21985256, 22007324, 22070473, 22070853, 22072543, 22087683, 22104866

     22179537, 22310426, 22347493, 22364044, 22367053, 22379010, 22446455

     22495673, 22503283, 22503297, 22504793, 22522515, 22530986, 22564336

     22568728, 22581771, 22594071, 22599050, 22628825, 22645009, 22654475

     22700845, 22726044, 22729345, 22826067, 22843979, 22845846, 22864303

     22898198, 22950945, 22970869, 22981722, 23019710, 23026585, 23035249

     23055900, 23061453, 23065002, 23066146, 23080557, 23104033, 23105538

     23110523, 23125560, 23126545, 23127945, 23151677, 23169712, 23177923

     23179662, 23184263, 23197730, 23234232, 23237091, 23249829, 23271203

     23278750, 23300142, 23306590, 23310101, 23312077, 23328639, 23336559

     23481673, 23491861, 23499004, 23499160, 23521523, 23527363, 23533647

     23548817, 23567857, 23572982, 23581777, 23588722, 23599216, 23600861

     23602213, 23645516, 23665623, 23709062, 23715460, 23715518, 23730961

     23733981, 23735292, 23741944, 23746128, 23749454, 23761724, 24010030

     24289874, 24294174, 24303148, 24307571, 24308349, 24326444, 24326846

     24328857, 24332831, 24334708, 24336249, 24337882, 24341675, 24343905

     24345420, 24346821, 24348685, 24350620, 24352981, 24355111, 24357348

     24368004, 24371491, 24373528, 24373756, 24374976, 24376875, 24376878

     24385983, 24401351, 24403922, 24409977, 24415926, 24416451, 24421668

     24423416, 24425056, 24425998, 24435982, 24437162, 24443539, 24457597

     24460392, 24461826, 24467122, 24468470, 24470606, 24471079, 24471473

     24473736, 24485034, 24485161, 24485174, 24486059, 24486237, 24509056

     24534401, 24554533, 24555417, 24556967, 24560906, 24563422, 24570214

     24570598, 24573817, 24578718, 24578797, 24589081, 24589590, 24591506

     24593740, 24595699, 24600330, 24609592, 24609996, 24611527, 24616637

     24617969, 24623975, 24624166, 24642495, 24654629, 24655717, 24664211

     24668398, 24669189, 24674197, 24674955, 24676172, 24677696, 24680959

     24689376, 24692973, 24693290, 24697323, 24699619, 24710696, 24713381

     24714096, 24717183, 24717859, 24718260, 24719799, 24735430, 24737064

     24737403, 24737581, 24744383, 24744686, 24757934, 24759556, 24760407

     24764085, 24766309, 24786669, 24792678, 24793511, 24796092, 24797119

     24800423, 24801152, 24802934, 24811725, 24812047, 24827228, 24827654

     24831514, 24835919, 24841671, 24843188, 24844549, 24844841, 24845157

     24848746, 24848923, 24850622, 24907917, 24908321, 24911709, 24912588

     24922704, 24923080, 24923215, 24923338, 24923790, 24924667, 24926999

     24929210, 24938784, 24940060, 24942749, 24953434, 24957555, 24960044

     24965426, 24966594, 24966788, 24967993, 24968162, 24976007, 24978100

     25022574, 25027852, 25028996, 25029022, 25029423, 25032818, 25034396

     25036474, 25042823, 25044977, 25045228, 25050160, 25051465, 25051628

     25057811, 25058080, 25062592, 25063971, 25065563, 25072986, 25078611

     25086233, 25087436, 25092777, 25093872, 25098160, 25099339, 25099497

     25099758, 25100063, 25100579, 25103996, 25107662, 25110233, 25114561

     25120284, 25120668, 25120742, 25121089, 25123585, 25124363, 25129925

     25140197, 25145163, 25145215, 25150925, 25159176, 25162645, 25164293

     25166187, 25171041, 25171084, 25175723, 25176408, 25178032, 25178101

     25178179, 25179774, 25182817, 25184555, 25186079, 25191872, 25192044

     25192528, 25192729, 25199585, 25201454, 25202355, 25203656, 25206864

     25207410, 25209912, 25210268, 25210499, 25211628, 25223839, 25224242

     25225795, 25226665, 25227381, 25230870, 25230945, 25237577, 25240188

     25240590, 25241448, 25241625, 25244807, 25248384, 25251648, 25257085

     25259611, 25262869, 25263960, 25265499, 25283790, 25287072, 25293659

     25296876, 25299227, 25299807, 25300427, 25303756, 25305405, 25307368

     25309116, 25313154, 25313411, 25316758, 25317989, 25320555, 25323525

     25328518, 25329664, 25335249, 25335360, 25335790, 25337332, 25337640

     25348956, 25353983, 25356118, 25357142, 25360661, 25362958, 25367588

     25367721, 25382812, 25383204, 25384462, 25386748, 25388896, 25392535

     25395696, 25397936, 25398306, 25404202, 25405100, 25405687, 25405813

     25410017, 25410180, 25410802, 25410877, 25411036, 25415713, 25417050

     25417056, 25417958, 25425451, 25425760, 25427662, 25429959, 25430120

     25433696, 25435038, 25437699, 25440818, 25442559, 25444961, 25445168

     25451531, 25455795, 25457409, 25459958, 25462714, 25463844, 25472112

     25476149, 25477657, 25478885, 25479164, 25482971, 25489342, 25489367

     25489607, 25492379, 25498930, 25498994, 25516250, 25524955, 25528838

     25530080, 25530814, 25535668, 25536819, 25537470, 25539063, 25540738

     25546580, 25546608, 25547901, 25551676, 25553616, 25554787, 25555252

     25557886, 25558986, 25560487, 25561296, 25569149, 25570929, 25575348

     25575369, 25575628, 25579458, 25579761, 25594901, 25597525, 25598473

     25599425, 25600342, 25600421, 25602488, 25603923, 25606091, 25607726

     25612095, 25614866, 25616268, 25616359, 25616417, 25616645, 25631933

     25633101, 25634317, 25634348, 25635149, 25638456, 25639019, 25643818

     25643889, 25643931, 25646373, 25647325, 25648731, 25653109, 25654459

     25654936, 25655390, 25655966, 25659655, 25660847, 25661819, 25662088

     25662101, 25662524, 25663488, 25669791, 25670786, 25671354, 25672640

     25674386, 25680221, 25685152, 25686739, 25687460, 25691904, 25694206

     25695903, 25699321, 25700654, 25709368, 25710420, 25715167, 25717371

     25722055, 25722608, 25722720, 25723158, 25728085, 25729507, 25734963

     25736747, 25739065, 25741955, 25743479, 25747569, 25749273, 25752755

     25754606, 25757748, 25760195, 25762221, 25764020, 25766822, 25768681

     25772669, 25774077, 25775213, 25780343, 25783447, 25784002, 25785331

     25785441, 25788879, 25789041, 25789277, 25789579, 25790353, 25792911

     25795865, 25797092, 25797124, 25797305, 25800464, 25802510, 25803545

     25807997, 25810263, 25810704, 25811650, 25813931, 25818707, 25822410

     25823754, 25825910, 25826740, 25830492, 25832935, 25834581, 25835365

     25838361, 25838755, 25852885, 25856821, 25858672, 25861398, 25865785

     25870579, 25871177, 25871639, 25871753, 25872127, 25872389, 25873336

     25874050, 25874678, 25882264, 25883438, 25885148, 25888073, 25888984

     25890056, 25890673, 25894239, 25895224, 25897615, 25904273, 25904490

     25906117, 25906886, 25908728, 25911724, 25914276, 25919622, 25932524

     25932728, 25933494, 25941836, 25943271, 25945130, 25947799, 25951571

     25953857, 25954022, 25954054, 25957038, 25963024, 25964954, 25967544

     25967985, 25970731, 25971286, 25973152, 25975723, 25977302, 25980605

     25980770, 25981498, 25982666, 25986062, 25990907, 25995938, 25997810

     26006257, 26007010, 26019148, 26024732, 26024784, 26025681, 26029075

     26029777, 26029780, 26032573, 26034119, 26036748, 26037215, 26038086

     26039623, 26040483, 26045732, 26051656, 26078437, 26078493, 26080410

     26083298, 26088426, 26088836, 26090767, 26091640, 26091786, 26095327

     26095405, 26096382, 26108080, 26108337, 26110259, 26110632, 26111842

     26112621, 26115103, 26121990, 26124078, 26137367, 26138085, 26149904

     26153977, 26168933, 26169341, 26169345, 26170659, 26170715, 26176002

     26187943, 26189861, 26198757, 26198926, 26201113, 26203182, 26223039

     26237338, 26237431, 26237773, 26238195, 26242031, 26243698, 26244115

     26245237, 26248143, 26249718, 26256131, 26257953, 26259265, 26261327

     26263328, 26263721, 26268756, 26269790, 26271001, 26275023, 26275415

     26277439, 26281476, 26285062, 26285933, 26308650, 26309047, 26317991

     26318627, 26323308, 26324206, 26324769, 26327624, 26330994, 26331743

     26333141, 26336977, 26338953, 26351334, 26353617, 26358670, 26359091

     26362155, 26362821, 26366517, 26367012, 26367460, 26371725, 26374791

     26375052, 26375250, 26380097, 26385189, 26388538, 26396790, 26399626

     26399691, 26406387, 26407408, 26412540, 26418088, 26420561, 26421667

     26422277, 26423085, 26426526, 26426967, 26430323, 26430737, 26434436

     26434999, 26435073, 26436168, 26438612, 26439748, 26440169, 26440749

     26442308, 26444601, 26444887, 26446098, 26452606, 26474662, 26474703

     26475419, 26476244, 26478970, 26479173, 26482376, 26486365, 26492866

     26493289, 26498354, 26513067, 26513709, 26521043, 26522439, 26523432

     26526726, 26526799, 26536320, 26537307, 26542135, 26542236, 26544823

     26545688, 26546070, 26546664, 26546754, 26548363, 26556014, 26569225

     26575788, 26580633, 26582460, 26584641, 26597140, 26599395, 26608137

     26608238, 26609942, 26615291, 26615690, 26617804, 26623652, 26626879

     26629381, 26633355, 26633558, 26635897, 26637273, 26637824, 26639167

     26641610, 26650226, 26654363, 26658759, 26659182, 26680105, 26712331

     26714486, 26714910, 26717528, 26725687, 26727397, 26729494, 26729611

     26740700, 26744595, 26745002, 26751106, 26751171, 26755171, 26758193

     26764561, 26765212, 26775602, 26784509, 26794786, 26797591, 26798516

     26802503, 26816582, 26820076, 26822620, 26828994, 26829845, 26833932

     26837702, 26840654, 26844406, 26844870, 26849779, 26875822, 26883456

     26895149, 26896659, 26898563, 26907327, 26908788, 26909100, 26909504

     26911000, 26939314, 26943004, 26944190, 26958896, 26963310, 26966616

     26966916, 26967713, 26969321, 26970175, 26970717, 26981902, 26983259

     26985002, 26986173, 26992964, 27006120, 27006664, 27009164, 27013146

     27028251, 27032785, 27034890, 27037839, 27038986, 27039712, 27044297

     27052607, 27058530, 27060167, 27060859, 27061736, 27073314, 27079140

     27087426, 27090765, 27092508, 27093423, 27097854, 27101105, 27105900

     27106179, 27110878, 27115422, 27117822, 27119621, 27122162, 27124624

     27125872, 27133662, 27134734, 27135647, 27135993, 27138325, 27142373

     27142529, 27151826, 27153641, 27161071, 27162390, 27162405, 27163928

     27165231, 27169796, 27170305, 27181537, 27181897, 27199245, 27200959

     27207110, 27208795, 27213224, 27216046, 27223075, 27229389, 27231051

     27236722, 27242226, 27244337, 27248917, 27249531, 27250547, 27251690

     27255377, 27256000, 27258578, 27259307, 27262945, 27266245, 27274456

     27274536, 27275533, 27276231, 27283960, 27284499, 27285244, 27288638

     27292213, 27293599, 27302711, 27302730, 27303287, 27304410, 27305039

     27308088, 27314206, 27314390, 27320576, 27321179, 27329612, 27333106

     27334316, 27338912, 27338946, 27339115, 27345231, 27346709, 27348081

     27349393, 27350267, 27351628, 27359178, 27364854, 27367194, 27370965

     27375542, 27381498, 27386467, 27394703, 27395416, 27396624, 27396672

     27396813, 27397048, 27400416, 27400598, 27404668, 27405645, 27416997

     27423251, 27424405, 27426363, 27432062, 27433870, 27434193, 27439835

     27441326, 27442041, 27445727, 27457891, 27466597, 27468303, 27493674

     27501373, 27501413, 27502420, 27504770, 27505229, 27508985, 27510959

     27525909, 27533819, 27534509, 27540613, 27544973, 27548131, 27554074

     27555481, 27558861, 27560602, 27562488, 27565906, 27567477, 27576342

     27593501, 27595973, 27607563, 27611612, 27613080, 27613530, 27617978

     27620808, 27629756, 27634676, 27634991, 27658186, 27666312, 27671633

     27680669, 27686599, 27687880, 27688036, 27688099, 27688692, 27691920

     27691939, 27693416, 27693713, 27695063, 27698953, 27700466, 27704237

     27709046, 27710072, 27726780, 27740424, 27748954, 27751755, 27757567

     27757888, 27758972, 27759077, 27793533, 27799032, 27801337, 27824540

     27824543, 27825241, 27829295, 27833672, 27834551, 27835925, 27846298

     27846499, 27847259, 27855490, 27861226, 27882176, 27898015, 27931299

     27940876, 27945870, 27951817, 27959048, 27959594, 27966472, 27986817

     27994325, 27995215, 27995248, 27997875, 27998003, 27999073, 27999638

     28000269, 28022101, 28023081, 28023399, 28023482, 28026866, 28033429

     28040776, 28045903, 28067846, 28072567, 28074713, 28090453, 28099662

     28108003, 28111583, 28120036, 28120951, 28124631, 28129791, 28140658

     28165439, 28171079, 28174827, 28180464, 28181021, 28184554, 28188330

     28194173, 28199085, 28201419, 28218832, 28220398, 28223871, 28226179

     28229360, 28236305, 28271119, 28279837, 28282606, 28290434, 28302049

     28305001, 28305362, 28320399, 28354603, 28357401, 28361221, 28365111

     28378446, 28390273, 28396445, 28420042, 28420457, 28423598, 28432129

     28434028, 28437315, 28454242, 28468312, 28483184, 28489150, 28501075

     28502343, 28507324, 28508053, 28508557, 28522441, 28528349, 28535272

     28545134, 28547068, 28571483, 28572834, 28578164, 28587723, 28600233

     28612674, 28617631, 28617959, 28621470, 28627255, 28636676, 28691965

     28692275, 28708023, 28728272, 28742555, 28749289, 28758722, 28774416

     28803345, 28819640, 28849751, 28852691, 28856060, 28891984, 28951382

     28956908, 28960211, 28965787, 28986231, 28987439, 28991884, 28993590

     29006527, 29024054, 29027694, 29032276, 29125374, 29158680, 29189889

     29200700, 29224605, 29250230, 29301463, 29339155, 29347943, 29376346

     29378913, 29379978, 29388020, 29405462, 29436454, 29437712, 29511611

     29542449, 29676089, 29690625, 29813494, 29836659
--------------------------------------------------------------------------------
OPatch succeeded.



 5. Check conflicts for OJVM patch.

[oracle@29774415]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.
 PREREQ session
Oracle Home       : /u01/app/oracle/product/database/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/database/12.2.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/database/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-10-04.log
 Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
 OPatch succeeded.

  6. Apply OJVM patch.

[oracle@29774415]$ opatch apply

Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/database/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/database/12.2.0/dbhome_1/oraInst.loc
OPatch version    : 12.2.0.1.17
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/database/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-10-04.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   29774415
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/database/12.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '29774415' to OH '/u01/app/oracle/product/database/12.2.0/dbhome_1'
Patching component oracle.javavm.server, 12.2.0.1.0...
Patching component oracle.javavm.server.core, 12.2.0.1.0...
Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...
Patching component oracle.javavm.client, 12.2.0.1.0...
Patching component oracle.rdbms, 12.2.0.1.0...
Patch 29774415 successfully applied.
Log file location: /u01/app/oracle/product/database/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-10-04.log
OPatch succeeded.


7. Verify patches.

 [oracle@29774415]$ opatch lspatches

29774415;OJVM RELEASE UPDATE: 12.2.0.1.190716 (29774415)
29757449;Database Jul 2019 Release Update : 12.2.0.1.190716 (29757449)

 SQL> select PATCH_ID,VERSION,STATUS from dba_registry_sqlpatch;

  PATCH_ID VERSION                        STATUS
---------- ------------------------------ --------
  29774415 12.2.0.1                       SUCCESS
  29757449 12.2.0.1                       SUCCESS


Reference:-  MOS doc to check latest patches for Oracle database 12.2.0.1 Doc ID 2285557.1