{"id":1641,"date":"2015-12-01T20:52:43","date_gmt":"2015-12-02T02:52:43","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1641"},"modified":"2026-02-07T15:34:42","modified_gmt":"2026-02-07T21:34:42","slug":"apply-db-ovjm-psu-queryable-patch-inventory-demo","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2015\/1641\/","title":{"rendered":"Apply DB OVJM PSU + Queryable Patch Inventory Demo"},"content":{"rendered":"

Oracle started releasing OVJM component of \u00a0DB PSU in October 2014, and recommend applying OVJM PSU along with (or after) DB PSU. I will demo applying DB PSU, and OVJM PSU on 12.1.0.2 database. Use this opportunity to introduce you to Queryable Patch Inventory (DBMS_QOPATCH<\/a>), where you can query OPatch information directly from the database.<\/p>\n

Download the combo patch from MOS.<\/p>\n

Patch 21520444:COMBO OF OJVM COMPONENT 12.1.0.2.5 DB PSU + DB PSU 12.1.0.2.5 (OCT2015)<\/em><\/p>\n

The 21520444 patch in fact contains two patches:\u00a021359755 (DB PSU) and\u00a021555660 (OVJM PSU).<\/p>\n

Download and unzip the patch combo.<\/p>\n

[oracle@localhost 21520444]$ pwd\n\/shared\/oraclesw\/21520444\n[oracle@localhost 21520444]$ ls -l\ntotal 24\ndrwxrwx---. 1 root vboxsf   272 Oct 26 10:38 21359755\ndrwxrwx---. 1 root vboxsf   238 Oct 26 10:38 21555660\n-rwxrwx---. 1 root vboxsf 18312 Oct 26 10:41 README.html\n-rwxrwx---. 1 root vboxsf    25 Oct 26 10:38 README.txt\n[oracle@localhost 21520444]$<\/pre>\n
Download the latest OPatch, and copy to Oracle Home.<\/p>\n
-- Current version of OPatch\n$ $ORACLE_HOME\/OPatch\/opatch version\nOPatch Version: 12.1.0.1.3\nOPatch succeeded.\n-- Unzip OPatch zip file to Oracle Home\n$ cd $ORACLE_HOME\n[oracle@localhost 12.1.0.2]$ mv OPatch OPatch.old\n[oracle@localhost 12.1.0.2]$ unzip \/media\/sf_Shared\/oraclesw\/p6880880_121010_LINUX.zip\n\n-- New version\n$ .\/OPatch\/opatch version\nOPatch Version: 12.1.0.1.10\nOPatch succeeded.\n<\/pre>\n
Use DBMS_QOPATCH to check which patches are installed. First let’s find the Oracle Home location and the inventory location.<\/p>\n
SQL> select xmltransform(dbms_qopatch.get_opatch_install_info, dbms_qopatch.get_opatch_xslt) x from dual;\n\nX\n----------------------------------------------------------------\nOracle Home\t  : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\nInventory\t  : \/home\/oracle\/app\/oraInventory\n\nSQL><\/pre>\n
dbms_qopatch.get_opatch_xslt is the style sheet. The documentation says “This function returns the style-sheet for the opatch XML inventory presentation. You can use the return type of this subprogram to perform XMLTRANSFORM and the transformed result has the same appearance as opatch text output.”<\/p>\n
Example below shows all the products and patches installed in the database.<\/p>\n
SQL> select xmltransform(dbms_qopatch.get_opatch_lsinventory, dbms_qopatch.get_opatch_xslt) X from dual;\n\nX\n--------------------------------------------------------------------------------\nOracle Querayable Patch Interface 1.0\n--------------------------------------------------------------------------------\nOracle Home\t  : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\nInventory\t  : \/home\/oracle\/app\/oraInventory\n--------------------------------------------------------------------------------\nInstalled Top-level Products (1):\nOracle Database 12c\t\t\t\t       12.1.0.2.0\nInstalled Products ( 135)\n\nOracle Database 12c\t\t\t\t\t    12.1.0.2.0\nJava Development Kit\t\t\t\t\t    1.6.0.75.0\noracle.swd.oui.core.min \t\t\t\t    12.1.0.2.0\nInstaller SDK Component \t\t\t\t    12.1.0.2.0\nOracle One-Off Patch Installer\t\t\t\t    12.1.0.1.2\nOracle Universal Installer\t\t\t\t    12.1.0.2.0\nOracle USM Deconfiguration\t\t\t\t    12.1.0.2.0\nOracle Configuration Manager Deconfiguration\t\t    10.3.1.0.0\nOracle RAC Deconfiguration\t\t\t\t    12.1.0.2.0\nOracle DBCA Deconfiguration\t\t\t\t    12.1.0.2.0\nOracle Database Plugin for Oracle Virtual Assembly Builder  12.1.0.2.0\nOracle Configuration Manager Client\t\t\t    10.3.2.1.0\nOracle Configuration Manager\t\t\t\t    10.3.8.1.1\nOracle ODBC Driverfor Instant Client\t\t\t    12.1.0.2.0\nLDAP Required Support Files\t\t\t\t    12.1.0.2.0\nExpat libraries \t\t\t\t\t    2.0.1.0.2\nOracle Bali Share\t\t\t\t\t    11.1.1.6.0\nSSL Required Support Files for InstantClient\t\t    12.1.0.2.0\nOracle Net Required Support Files\t\t\t    12.1.0.2.0\nOracle R Enterprise Server Files\t\t\t    12.1.0.2.0\nOracle Real Application Testing \t\t\t    12.1.0.2.0\nOracle Label Security\t\t\t\t\t    12.1.0.2.0\nOracle Data Mining RDBMS Files\t\t\t\t    12.1.0.2.0\nOracle OLAP RDBMS Files \t\t\t\t    12.1.0.2.0\nOracle OLAP API \t\t\t\t\t    12.1.0.2.0\nSQL*Plus Required Support Files \t\t\t    12.1.0.2.0\nOracle Database Vault option\t\t\t\t    12.1.0.2.0\nXDK Required Support Files\t\t\t\t    12.1.0.2.0\nOracle Notification Service for Instant Client\t\t    12.1.0.2.0\nPlatform Required Support Files \t\t\t    12.1.0.2.0\nOracle RAC Required Support Files-HAS\t\t\t    12.1.0.2.0\nOracle JDBC Server Support Package\t\t\t    12.1.0.2.0\nOracle SQL Developer\t\t\t\t\t    12.1.0.2.0\nOracle Application Express\t\t\t\t    12.1.0.2.0\nRDBMS Required Support Files Runtime\t\t\t    12.1.0.2.0\nRDBMS Required Support Files for Instant Client \t    12.1.0.2.0\nSQLJ Runtime\t\t\t\t\t\t    12.1.0.2.0\nDatabase Workspace Manager\t\t\t\t    12.1.0.2.0\nPrecompiler Common Files for Core\t\t\t    12.1.0.2.0\nParser Generator Required Support Files \t\t    12.1.0.2.0\nOracle Globalization Support\t\t\t\t    12.1.0.2.0\nOracle Notification Service (eONS)\t\t\t    12.1.0.2.0\nOracle Context Companion\t\t\t\t    12.1.0.2.0\nOracle Text ATG Language Support Files\t\t\t    12.1.0.2.0\nOracle Text for Core\t\t\t\t\t    12.1.0.2.0\nOracle Text Required Support Files\t\t\t    12.1.0.2.0\nPrecompiler Required Support Files\t\t\t    12.1.0.2.0\nHadoopcore Component\t\t\t\t\t    12.1.0.2.0\nOracle Database 12c Multimedia Files\t\t\t    12.1.0.2.0\nOracle Multimedia Java Advanced Imaging \t\t    12.1.0.2.0\nOracle JDBC\/OCI Instant Client\t\t\t\t    12.1.0.2.0\nOracle Multimedia Locator Java Required Support Files\t    12.1.0.2.0\nOracle Multimedia Locator RDBMS Files\t\t\t    12.1.0.2.0\nOracle Core Required Support Files for Core DB\t\t    12.1.0.2.0\nOracle Core Required Support Files\t\t\t    12.1.0.2.0\nSample Schema Data\t\t\t\t\t    12.1.0.2.0\nOracle Starter Database \t\t\t\t    12.1.0.2.0\nOracle Message Gateway Common Files\t\t\t    12.1.0.2.0\nOracle XML Query\t\t\t\t\t    12.1.0.2.0\nOracle Core XML Development Kit \t\t\t    12.1.0.2.0\nXML Parser for Oracle JVM\t\t\t\t    12.1.0.2.0\nOracle JFC Extended Windowing Toolkit\t\t\t    11.1.1.6.0\nOracle Globalization Support For Core\t\t\t    12.1.0.2.0\nDB TOOLS Listener\t\t\t\t\t    12.1.0.2.0\nTracle File Analyzer\t\t\t\t\t    12.1.0.2.0\nOracle Database Deconfiguration \t\t\t    12.1.0.2.0\nOracle Quality of Service Management (Client)\t\t    12.1.0.2.0\nOracle Locale Builder\t\t\t\t\t    12.1.0.2.0\nJAccelerator (COMPANION)\t\t\t\t    12.1.0.2.0\nOracle Containers for Java\t\t\t\t    12.1.0.2.0\nOracle JVM For Core\t\t\t\t\t    12.1.0.2.0\nPerl Modules\t\t\t\t\t\t    5.14.1.0.0\nRDBMS Required Support Files\t\t\t\t    12.1.0.2.0\nSecure Socket Layer\t\t\t\t\t    12.1.0.2.0\nOracle Universal Connection Pool\t\t\t    12.1.0.2.0\nOracle JDBC\/THIN Interfaces\t\t\t\t    12.1.0.2.0\nOracle Multimedia Client Option \t\t\t    12.1.0.2.0\nOracle Java Client\t\t\t\t\t    12.1.0.2.0\nDatabase Migration Assistant for Unicode\t\t    12.1.0.2.0\nPerl Interpreter\t\t\t\t\t    5.14.1.0.0\nPL\/SQL Embedded Gateway \t\t\t\t    12.1.0.2.0\nOLAP SQL Scripts\t\t\t\t\t    12.1.0.2.0\nDatabase SQL Scripts\t\t\t\t\t    12.1.0.2.0\nOracle Globalization Support\t\t\t\t    12.1.0.2.0\nOracle Extended Windowing Toolkit\t\t\t    11.1.1.6.0\nSQL*Plus Files for Instant Client\t\t\t    12.1.0.2.0\nRequired Support Files\t\t\t\t\t    12.1.0.2.0\nOracle ODBC Driver\t\t\t\t\t    12.1.0.2.0\nPrecompilers\t\t\t\t\t\t    12.1.0.2.0\nPrecompiler Common Files\t\t\t\t    12.1.0.2.0\nDeinstallation Tool\t\t\t\t\t    12.1.0.2.0\nOracle Recovery Manager \t\t\t\t    12.1.0.2.0\nOracle Net Java Required Support Files\t\t\t    12.1.0.2.0\nXML Parser for Java\t\t\t\t\t    12.1.0.2.0\nOracle Security Developer Tools \t\t\t    12.1.0.2.0\nOracle Wallet Manager\t\t\t\t\t    12.1.0.2.0\nCluster Verification Utility Common Files\t\t    12.1.0.2.0\nOracle Clusterware RDBMS Files\t\t\t\t    12.1.0.2.0\nOracle Ice Browser\t\t\t\t\t    11.1.1.7.0\nInstallation Plugin Files\t\t\t\t    12.1.0.2.0\nInstallation Common Files\t\t\t\t    12.1.0.2.0\nOracle LDAP administration\t\t\t\t    12.1.0.2.0\nBuildtools Common Files \t\t\t\t    12.1.0.2.0\nOracle Java Layout Engine\t\t\t\t    11.0.0.0.0\nOracle Database User Interface\t\t\t\t    11.0.0.0.0\nOracle Help Share Library\t\t\t\t    11.1.1.7.0\nOracle Help for Java\t\t\t\t\t    11.1.1.7.0\nHAS Common Files\t\t\t\t\t    12.1.0.2.0\nPL\/SQL\t\t\t\t\t\t\t    12.1.0.2.0\nAssistant Common Files\t\t\t\t\t    12.1.0.2.0\nOracle Notification Service\t\t\t\t    12.1.0.2.0\nOracle Net\t\t\t\t\t\t    12.1.0.2.0\nOracle Database Utilities\t\t\t\t    12.1.0.2.0\nGeneric Connectivity Common Files\t\t\t    12.1.0.2.0\nOracle Database Gateway for ODBC\t\t\t    12.1.0.2.0\nOracle Programmer\t\t\t\t\t    12.1.0.2.0\nOracle Netca Client\t\t\t\t\t    12.1.0.2.0\nSQL*Plus\t\t\t\t\t\t    12.1.0.2.0\nOracle Multimedia Locator\t\t\t\t    12.1.0.2.0\nOracle Multimedia\t\t\t\t\t    12.1.0.2.0\nOracle Call Interface (OCI)\t\t\t\t    12.1.0.2.0\nOracle XML Development Kit\t\t\t\t    12.1.0.2.0\nDatabase Configuration and Upgrade Assistants\t\t    12.1.0.2.0\nOracle JVM\t\t\t\t\t\t    12.1.0.2.0\nOracle Advanced Security\t\t\t\t    12.1.0.2.0\nOracle Internet Directory Client\t\t\t    12.1.0.2.0\nOracle Net Listener\t\t\t\t\t    12.1.0.2.0\nHAS Files for DB\t\t\t\t\t    12.1.0.2.0\nOracle Text\t\t\t\t\t\t    12.1.0.2.0\nOracle Net Services\t\t\t\t\t    12.1.0.2.0\nOracle Database 12c\t\t\t\t\t    12.1.0.2.0\nOracle OLAP\t\t\t\t\t\t    12.1.0.2.0\nOracle Spatial and Graph\t\t\t\t    12.1.0.2.0\nOracle Partitioning\t\t\t\t\t    12.1.0.2.0\nEnterprise Edition Options\t\t\t\t    12.1.0.2.0\n\nInterim patches:\n\nSQL> \n<\/pre>\n
Nothing under “Interim Patches”, so nothing installed. Now, apply PSU.<\/p>\n
Shutdown database and listener before applying DB PSU (21359755).<\/p>\n
Go to the patch download directory, and apply PSU using opatch.<\/p>\n
[oracle@localhost 21359755]$ $ORACLE_HOME\/OPatch\/opatch apply\nOracle Interim Patch Installer version 12.1.0.1.10\nCopyright (c) 2015, Oracle Corporation.  All rights reserved.\n\nOracle Home       : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\nCentral Inventory : \/home\/oracle\/app\/oraInventory\n   from           : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\/oraInst.loc\nOPatch version    : 12.1.0.1.10\nOUI version       : 12.1.0.2.0\nLog file location : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\/cfgtoollogs\/opatch\/opatch2015-11-29_19-45-39PM_1.log\n\nVerifying environment and performing prerequisite checks...\nOPatch continues with these patches:   19769480  20299023  20831110  21359755  \n\nDo you want to proceed? [y|n]\ny\nUser Responded with: Y\nAll checks passed.\nProvide your email address to be informed of security issues, install and\ninitiate Oracle Configuration Manager. Easier for you if you use your My\nOracle Support Email address\/User Name.\nVisit http:\/\/www.oracle.com\/support\/policies.html for details.\nEmail address\/User Name: \n\nYou have not provided an email address for notification of security issues.\nDo you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y\n\nPlease shutdown Oracle instances running out of this ORACLE_HOME on the local system.\n(Oracle Home = '\/home\/oracle\/app\/oracle\/db\/12.1.0.2')\n\nIs the local system ready for patching? [y|n]\ny\nUser Responded with: Y\nBacking up files...\nApplying sub-patch '19769480' to OH '\/home\/oracle\/app\/oracle\/db\/12.1.0.2'\n\nPatching component oracle.rdbms.deconfig, 12.1.0.2.0...\nPatching component oracle.xdk, 12.1.0.2.0...\nPatching component oracle.tfa, 12.1.0.2.0...\nPatching component oracle.rdbms.util, 12.1.0.2.0...\nPatching component oracle.rdbms, 12.1.0.2.0...\nPatching component oracle.rdbms.dbscripts, 12.1.0.2.0...\nPatching component oracle.xdk.parser.java, 12.1.0.2.0...\nPatching component oracle.oraolap, 12.1.0.2.0...\nPatching component oracle.xdk.rsf, 12.1.0.2.0...\nPatching component oracle.rdbms.rsf, 12.1.0.2.0...\nPatching component oracle.rdbms.rman, 12.1.0.2.0...\nPatching component oracle.ldap.rsf, 12.1.0.2.0...\nPatching component oracle.ldap.rsf.ic, 12.1.0.2.0...\nApplying sub-patch '20299023' to OH '\/home\/oracle\/app\/oracle\/db\/12.1.0.2'\nApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.\n\nPatching component oracle.tfa, 12.1.0.2.0...\nPatching component oracle.rdbms.deconfig, 12.1.0.2.0...\nPatching component oracle.rdbms.rsf, 12.1.0.2.0...\nPatching component oracle.rdbms, 12.1.0.2.0...\nPatching component oracle.rdbms.dbscripts, 12.1.0.2.0...\nPatching component oracle.rdbms.rsf.ic, 12.1.0.2.0...\nPatching component oracle.ldap.rsf, 12.1.0.2.0...\nPatching component oracle.ldap.rsf.ic, 12.1.0.2.0...\nApplying sub-patch '20831110' to OH '\/home\/oracle\/app\/oracle\/db\/12.1.0.2'\n\nPatching component oracle.rdbms, 12.1.0.2.0...\nPatching component oracle.oraolap.dbscripts, 12.1.0.2.0...\nPatching component oracle.ldap.rsf, 12.1.0.2.0...\nPatching component oracle.tfa, 12.1.0.2.0...\nPatching component oracle.rdbms.dbscripts, 12.1.0.2.0...\nPatching component oracle.rdbms.rsf, 12.1.0.2.0...\nApplying sub-patch '21359755' to OH '\/home\/oracle\/app\/oracle\/db\/12.1.0.2'\n\nPatching component oracle.assistants.server, 12.1.0.2.0...\nPatching component oracle.rdbms.rsf, 12.1.0.2.0...\nPatching component oracle.rdbms, 12.1.0.2.0...\nPatching component oracle.rdbms.dbscripts, 12.1.0.2.0...\nPatching component oracle.tfa, 12.1.0.2.0...\nComposite patch 21359755 successfully applied.\nLog file location: \/home\/oracle\/app\/oracle\/db\/12.1.0.2\/cfgtoollogs\/opatch\/opatch2015-11-29_19-45-39PM_1.log\n\nOPatch succeeded.\n[oracle@localhost 21359755]$ \n<\/pre>\n
If you had any other patches applied before the PSU, you would need to check for conflicts. Let’s check if OVJM PSU (21555660) has any conflict. Change working directory to OVJM patch directory.<\/p>\n
[oracle@localhost 21555660]$ pwd\n\/shared\/oraclesw\/21520444\/21555660\n[oracle@localhost 21555660]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgain-stOHWithDetail -ph .\/\nOracle Interim Patch Installer version 12.1.0.1.10\nCopyright (c) 2015, Oracle Corporation.  All rights reserved.\n\nPREREQ session\n\nOracle Home       : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\nCentral Inventory : \/home\/oracle\/app\/oraInventory\n   from           : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\/oraInst.loc\nOPatch version    : 12.1.0.1.10\nOUI version       : 12.1.0.2.0\nLog file location : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\/cfgtoollogs\/opatch\/opatch2015-11-29_21-24-57PM_1.log\n\nInvoking prereq \"checkconflictagainstohwithdetail\"\nPrereq \"checkConflictAgainstOHWithDetail\" passed.\n\nOPatch succeeded.\n[oracle@localhost 21555660]$ \n<\/pre>\n
Now, apply the OVJM PSU.<\/p>\n
[oracle@localhost 21555660]$ $ORACLE_HOME\/OPatch\/opatch apply\nOracle Interim Patch Installer version 12.1.0.1.10\nCopyright (c) 2015, Oracle Corporation.  All rights reserved.\n\nOracle Home       : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\nCentral Inventory : \/home\/oracle\/app\/oraInventory\n   from           : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\/oraInst.loc\nOPatch version    : 12.1.0.1.10\nOUI version       : 12.1.0.2.0\nLog file location : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\/cfgtoollogs\/opatch\/21555660_Nov_29_2015_21_26_03\/apply2015-11-29_21-26-03PM_1.log\n\nVerifying environment and performing prerequisite checks...\nOPatch continues with these patches:   21555660  \n\nDo you want to proceed? [y|n]\ny\nUser Responded with: Y\nAll checks passed.\nProvide your email address to be informed of security issues, install and\ninitiate Oracle Configuration Manager. Easier for you if you use your My\nOracle Support Email address\/User Name.\nVisit http:\/\/www.oracle.com\/support\/policies.html for details.\nEmail address\/User Name: \n\nYou have not provided an email address for notification of security issues.\nDo you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y\n\nPlease shutdown Oracle instances running out of this ORACLE_HOME on the local system.\n(Oracle Home = '\/home\/oracle\/app\/oracle\/db\/12.1.0.2')\n\nIs the local system ready for patching? [y|n]\ny\nUser Responded with: Y\nBacking up files...\nApplying interim patch '21555660' to OH '\/home\/oracle\/app\/oracle\/db\/12.1.0.2'\nApplySession: Optional component(s) [ oracle.sqlj, 12.1.0.2.0 ]  not present in the Oracle Home or a higher version is found.\nPatching component oracle.rdbms.dbscripts, 12.1.0.2.0...\nPatching component oracle.javavm.client, 12.1.0.2.0...\nPatching component oracle.rdbms, 12.1.0.2.0...\nPatching component oracle.javavm.server.core, 12.1.0.2.0...\nPatching component oracle.javavm.server, 12.1.0.2.0...\n--------------------------------------------------------------------------------\n***************************************************************************************************\n***************************************************************************************************\n**                                ATTENTION                                                      **\n**                                                                                               **\n** It is critical and essential to complete the post installation (if you applying the patch) or **\n** post deinstallation (if you are doing rollback of the patch) as per Readme to have a working  **\n** and functional Oracle JavaVM Component.                                                       **\n** Failure to follow the instructions could lead to inconsistencies in the database.             **\n**                                                                                               **\n***************************************************************************************************\n***************************************************************************************************\n\n--------------------------------------------------------------------------------\n\nPatch 21555660 successfully applied.\nLog file location: \/home\/oracle\/app\/oracle\/db\/12.1.0.2\/cfgtoollogs\/opatch\/21555660_Nov_29_2015_21_26_03\/apply2015-11-29_21-26-03PM_1.log\n\nOPatch succeeded.\n[oracle@localhost 21555660]$ \n<\/pre>\n
If the OVJM patch is not applied, you can do normal STARTUP. For OVJM, need to start the database with STARTUP UPGRADE.<\/p>\n
SQL> startup upgrade;\nORACLE instance started.\n\nTotal System Global Area  838860800 bytes\nFixed Size\t\t    2929936 bytes\nVariable Size\t\t  570428144 bytes\nDatabase Buffers\t  260046848 bytes\nRedo Buffers\t\t    5455872 bytes\nDatabase mounted.\nDatabase opened.\nSQL> \nSQL> alter pluggable database all open upgrade;\n\nPluggable database altered.\n\nSQL> \n<\/pre>\n
Then run the datapatch script. It will automatically run the post patch SQL scripts for both patches, and take care of all OPEN pluggable databases.<\/p>\n
[oracle@localhost OPatch]$ .\/datapatch -verbose\nSQL Patching tool version 12.1.0.2.0 on Sun Nov 29 21:59:47 2015\nCopyright (c) 2015, Oracle.  All rights reserved.\n\nLog file for this invocation: \/home\/oracle\/app\/oracle\/cfgtoollogs\/sqlpatch\/sqlpatch_26796_2015_11_29_21_59_47\/sqlpatch_invocation.log\n\nConnecting to database...OK\nNote:  Datapatch will only apply or rollback SQL fixes for PDBs\n       that are in an open state, no patches will be applied to closed PDBs.\n       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation\n       (Doc ID 1585822.1)\nBootstrapping registry and package to current versions...done\nDetermining current state...done\n\nCurrent state of SQL patches:\nPatch 21555660 (Database PSU 12.1.0.2.5, Oracle JavaVM Component (Oct2015)):\n  Installed in the binary registry only\nBundle series PSU:\n  ID 5 in the binary registry and not installed in any PDB\n\nAdding patches to installation queue and performing prereq checks...\nInstallation queue:\n  For the following PDBs: CDB$ROOT PDB$SEED PDB1 PDB2\n    Nothing to roll back\n    The following patches will be applied:\n      21555660 (Database PSU 12.1.0.2.5, Oracle JavaVM Component (Oct2015))\n      21359755 (Database Patch Set Update : 12.1.0.2.5 (21359755))\n\nInstalling patches...\nPatch installation complete.  Total patches installed: 8\n\nValidating logfiles...\nPatch 21555660 apply (pdb CDB$ROOT): SUCCESS\n  logfile: \/home\/oracle\/app\/oracle\/cfgtoollogs\/sqlpatch\/21555660\/19361790\/21555660_apply_CDB12C_CDBROOT_2015Nov29_22_00_20.log (no errors)\nPatch 21359755 apply (pdb CDB$ROOT): SUCCESS\n  logfile: \/home\/oracle\/app\/oracle\/cfgtoollogs\/sqlpatch\/21359755\/19194568\/21359755_apply_CDB12C_CDBROOT_2015Nov29_22_00_56.log (no errors)\nPatch 21555660 apply (pdb PDB$SEED): SUCCESS\n  logfile: \/home\/oracle\/app\/oracle\/cfgtoollogs\/sqlpatch\/21555660\/19361790\/21555660_apply_CDB12C_PDBSEED_2015Nov29_22_01_04.log (no errors)\nPatch 21359755 apply (pdb PDB$SEED): SUCCESS\n  logfile: \/home\/oracle\/app\/oracle\/cfgtoollogs\/sqlpatch\/21359755\/19194568\/21359755_apply_CDB12C_PDBSEED_2015Nov29_22_01_51.log (no errors)\nPatch 21555660 apply (pdb PDB1): SUCCESS\n  logfile: \/home\/oracle\/app\/oracle\/cfgtoollogs\/sqlpatch\/21555660\/19361790\/21555660_apply_CDB12C_PDB1_2015Nov29_22_01_04.log (no errors)\nPatch 21359755 apply (pdb PDB1): SUCCESS\n  logfile: \/home\/oracle\/app\/oracle\/cfgtoollogs\/sqlpatch\/21359755\/19194568\/21359755_apply_CDB12C_PDB1_2015Nov29_22_01_51.log (no errors)\nPatch 21555660 apply (pdb PDB2): SUCCESS\n  logfile: \/home\/oracle\/app\/oracle\/cfgtoollogs\/sqlpatch\/21555660\/19361790\/21555660_apply_CDB12C_PDB2_2015Nov29_22_01_04.log (no errors)\nPatch 21359755 apply (pdb PDB2): SUCCESS\n  logfile: \/home\/oracle\/app\/oracle\/cfgtoollogs\/sqlpatch\/21359755\/19194568\/21359755_apply_CDB12C_PDB2_2015Nov29_22_01_51.log (no errors)\nSQL Patching tool complete on Sun Nov 29 22:02:01 2015\n[oracle@localhost OPatch]$ \n<\/pre>\n
Restart the database in normal mode.<\/p>\n
Now, let’s do some DBMS_QOPATCH queries.<\/p>\n
Following shows the patches installed. Notice that along with patches, it also shows the files updated. You also get the names of the patch apply and patch rollback scripts.<\/p>\n
SQL> set pages 9999\nSQL> set long 32000\nSQL> select xmltransform(dbms_qopatch.get_opatch_list, dbms_qopatch.get_opatch_xslt) X from dual;\n\nX\n--------------------------------------------------------------------------------\nPatch Details:\n\nPatch(sqlpatch) 21555660:   applied on 2015-11-29T21:26:24-08:00\nUnique Patch ID: 19361790\n  Patch Description: Database PSU 12.1.0.2.5, Oracle JavaVM Component (Oct2015)\n  Created on\t : 18 Sep 2015, 02:55:45 hrs PST8PDT\n  Bugs fixed:\n\t 21047803  19699946  19245191  19223010  21047766  20408829  19231857  2\n1566944  21566993  21068507  19176885  20408866  19877336  19895326  21811517  1\n9153980  20415564  19909862  21555660  19855285  19895362  19623450\n  Files Touched:\n\n    21555660_apply.sql\n    21555660_rollback.sql\n    jvmpsu.sql\n    jvmpsupdii.sql\n    jvmpsupdi.sql\n    jvmpsui.sql\n    jvmpsupii.sql\n    jvmpsupi.sql\n    aurora.zip\n    ins_rdbms.mk\n    libjavavm12.a\n    libjavavm12.a\n    jce.jar\n    jce.jar\n    cacerts\n    cacerts\n    sunjce_provider.jar\n    sunjce_provider.jar\n    classes.bin\n    classes.bin\n    jvmpsupii.sql\n    jvmpsupi.sql\n    jvmpsu.sql\n    jvmpsupdii.sql\n    jvmpsupdi.sql\n    jvmpsui.sql\n\nPatch(sqlpatch) 21359755:   applied on 2015-11-29T19:46:36-08:00\nUnique Patch ID: 19194568\n  Patch Description: Database Patch Set Update : 12.1.0.2.5 (21359755)\n  Created on\t : 21 Oct 2015, 02:52:58 hrs PST8PDT\n  Bugs fixed:\n\t 19243521  20048359  19571367  20397490  20476175  20925795  21442094  2\n0245930  20134339  21281532  21421886  20413820  18966843  20441797  20281121  2\n1620471  19791273  20361671  18411216  19587324  19032777  19468991  17365043  2\n2062026  20471920  18743542  20688221  20122715\n  Files Touched:\n\n    \/oracle\/sysman\/assistants\/dbca\/dbcx\/XMLHost.class\n    sjsex.o\n    ins_rdbms.mk\n    ins_rdbms.mk\n    \/kcb.o\n    \/kcbz.o\n    \/kcl.o\n    \/kjfm.o\n    \/kjgcr.o\n    \/kxes.o\n    \/kql.o\n    \/kokt.o\n    \/kwqmn.o\n    \/kpdba.o\n    \/rpi.o\n    \/kfd.o\n    \/kfdva.o\n    \/kff.o\n    \/krbc.o\n    \/kfns.o\n    \/ktsk.o\n    \/kfvx.o\n    \/kdc.o\n    \/kdt.o\n    \/kcrfw.o\n    \/krb.o\n    \/krbm.o\n    \/knlogc.o\n    \/kzam.o\n    \/kzan.o\n    \/ktsp.o\n    \/ktsplb.o\n    \/ktspsrch.o\n    \/qksbg.o\n    \/kspt.o\n    \/qmixo.o\n    bundledata_PSU.xml\n    ins_rdbms.mk\n    21359755_apply.sql\n    21359755_rollback.sql\n    bug20876308_rollback.sql\n    prvtpckl.plb\n    bug19532017_downgrade.sql\n    prvtlmd.plb\n    prvtpexei.plb\n    prvtilm.plb\n    utluppkg.sql\n    bug19587324.sql\n    bug18909599.sql\n    bug19587324.sql\n    prvtsqlpatch.plb\n    prvtqopi.plb\n    sqlpatch.pm\n    prvtpexei.plb\n    prvtlmd.plb\n    prvtilm.plb\n    tfa_setup\n\nPatch(sqlpatch) 20831110:   applied on 2015-11-29T19:46:32-08:00\nUnique Patch ID: 18977826\n  Patch Description: Database Patch Set Update : 12.1.0.2.4 (20831110)\n  Created on\t : 11 Jul 2015, 00:45:40 hrs PST8PDT\n  Bugs fixed:\n\t 20424899  19307662  20746251  20919320  20331945  20657441  20387265  2\n0294666  19703301  20165574  20899461  20558005  19399918  20402832  21225209  1\n9284031  20474192  19699191  20093776  19989009\n  Files Touched:\n\n    \/kcbk.o\n    \/kcl.o\n    \/kxs.o\n    \/kks1.o\n    \/rfrdb.o\n    \/rfrxpt.o\n    \/koklv.o\n    \/kokm.o\n    \/krsd.o\n    \/kzaf.o\n    \/ktslj.o\n    \/qksvc.o\n    \/prsc.o\n    \/kzia.o\n    \/ksk.o\n    asmcmdshare.pm\n    asmcmdug.pm\n    bundledata_PSU.xml\n    ins_rdbms.mk\n    ins_rdbms.mk\n    bug20876308_apply.sql\n    bug20876308_rollback.sql\n    bug20876308_rollback.sql\n    prvtpckl.plb\n    utluppkg.sql\n    bug19532017_downgrade.sql\n    bug18909599.sql\n    20831110_apply.sql\n    20831110_rollback.sql\n    xoqclnup.sql\n    xoqu112.sql\n    bug20558005.sql\n    libccme_base_non_fips.so\n    libccme_ecc_accel_non_fips.so\n    libccme_ecc_non_fips.so\n    tfa_setup\n    catfga.sql\n    catschv.sql\n    catctl.pl\n    ins_net_client.mk\n\nPatch(sqlpatch) 20299023:   applied on 2015-11-29T19:46:29-08:00\nUnique Patch ID: 18703022\n  Patch Description: Database Patch Set Update : 12.1.0.2.3 (20299023)\n  Created on\t : 16 Mar 2015, 22:21:54 hrs PST8PDT\n  Bugs fixed:\n\t 20440930  18306996  19865345  19536415  18607546  19487147  19035573  1\n9873610  19081128  19606174  19272708  17274537  19358317  19291380  19012119  1\n9687159  19547370  20348653  20425790  19524384  19385656  19928926  18681056  1\n9512341  18856999  16619249  19018447  19393542  20235511  19627012  19649152  1\n9670108  19684504  18417036  20347562  19658708  19896336  19805359  19637186  1\n8940497  19183343  19978542  19644859  18202441  19023822  19791377  18909599  1\n9335438  19238590  19841800  19619732  19315691  19730508  19597583  19065677  1\n9915271\n  Files Touched:\n\n    tfa_setup\n    ins_rdbms.mk\n    \/kgfm.o\n    \/kgfm.o\n    \/dbgrup.o\n    \/dbgrupt.o\n    \/dbgtc.o\n    \/dbgtfd.o\n    \/dbgtfm.o\n    \/qcs.o\n    \/qmx0.o\n    ins_net_client.mk\n    ins_rdbms.mk\n    \/kcbz.o\n    \/kkdl.o\n    \/kkm2.o\n    \/kxs.o\n    \/kql.o\n    \/kqlb.o\n    \/kks1.o\n    \/kkae.o\n    \/kkp.o\n    \/rfmrole.o\n    \/rfrdb.o\n    \/jskr.o\n    \/kwra.o\n    \/kpdb.o\n    \/kpdba.o\n    \/kpdbc.o\n    \/kpdbe.o\n    \/kpdbf.o\n    \/kpdbicd.o\n    \/kpdbutl.o\n    \/kpdbxmlt.o\n    \/kpbf.o\n    \/opiexe.o\n    \/opiosq.o\n    \/kf.o\n    \/kfd.o\n    \/kfdp.o\n    \/kfg.o\n    \/kdbl.o\n    \/kdblc.o\n    \/kdt.o\n    \/kdu.o\n    \/kcv.o\n    \/knanr.o\n    \/knl.o\n    \/kzft.o\n    \/kzrt.o\n    \/kkfd.o\n    \/kxfp.o\n    \/kxfpt.o\n    \/kxfr.o\n    \/kxft.o\n    \/kxfx.o\n    \/qerpx.o\n    \/qerwn.o\n    \/qkadrv.o\n    \/qkexr.o\n    \/qksop.o\n    \/qkswc.o\n    \/dbsmig.o\n    \/qsmqutl.o\n    \/ktur.o\n    asmcmdsys.pm\n    bundledata_PSU.xml\n    ins_rdbms.mk\n    ins_rdbms.mk\n    ins_rdbms.mk\n    bug18909599.sql\n    bug19532017_downgrade.sql\n    bug19532017_upgrade.sql\n    dbmssqlpatch.sql\n    prvtsqlpatch.plb\n    prvtqopi.plb\n    sqlpatch_bootstrap.sql\n    sqlpatch.pm\n    sqlpatch.pl\n    prvtpckl.plb\n    bug19532017_downgrade.sql\n    utluppkg.sql\n    bug18909599.sql\n    20299023_apply.sql\n    20299023_rollback.sql\n    c1201000.sql\n    catadvtb.sql\n    catdpb.sql\n    catmetx.sql\n    catsqlreg.sql\n    catupstr.sql\n    e1201000.sql\n    utluppkg.sql\n    prvtbsat.plb\n    prvtdrep.plb\n    ins_rdbms.mk\n    libnnz12.a\n    libnnzst12.a\n    libnnz12.so\n\nPatch(sqlpatch) 19769480:   applied on 2015-11-29T19:46:22-08:00\nUnique Patch ID: 18350083\n  Patch Description: Database Patch Set Update : 12.1.0.2.2 (19769480)\n  Created on\t : 15 Dec 2014, 06:54:52 hrs PST8PDT\n  Bugs fixed:\n\t 20284155  19157754  18885870  19303936  19708632  19371175  18618122  1\n9329654  19075256  19074147  19044962  19289642  19068610  18988834  19028800  1\n9561643  19058490  19390567  18967382  19174942  19174521  19176223  19501299  1\n9178851  18948177  18674047  19723336  19189525  19001390  19176326  19280225  1\n9143550  18250893  19180770  19155797  19016730  19185876  18354830  19067244  1\n8845653  18849537  18964978  19065556  19440586  19439759  19024808  18952989  1\n8990693  19052488  19189317  19409212  19124589  19154375  19279273  19468347  1\n9054077  19048007  19248799  19018206  18921743  14643995  18456643  16870214  1\n9434529  19706965  17835294  20074391  18791688  19197175  19134173  19174430  1\n9050649  19769480  19077215  19577410  18288842  18436647  19520602  19149990  1\n9076343  19195895  18610915  19068970  19518079  19304354  19001359  19676905  1\n9309466  19382851  18964939  16359751  19022470  19532017  19597439  18674024  1\n9430401\n  Files Touched:\n\n    ins_rdbms.mk\n    xmlpatch\n    xmldiff\n    xsl\n    xmlcg\n    xvm\n    orachk.zip\n    tfa_setup\n    diaus.msg\n    \/kcb.o\n    \/kcbb.o\n    \/kcbw.o\n    \/kcbz.o\n    \/kcl.o\n    \/kjxgm.o\n    \/kjfc.o\n    \/dbkifw.o\n    \/kkm.o\n    \/qcis.o\n    \/kql.o\n    \/rfmon.o\n    \/krvg.o\n    \/krvt.o\n    \/kpdb.o\n    \/kpdba.o\n    \/kpdbc.o\n    \/kpdbcv.o\n    \/kpdbd.o\n    \/kpdbe.o\n    \/kpdbf.o\n    \/kpdbicd.o\n    \/kpdbs.o\n    \/kpdbutl.o\n    \/kpodp.o\n    \/kpolon.o\n    \/kfd.o\n    \/kfdp.o\n    \/kfds.o\n    \/kff.o\n    \/kffm.o\n    \/kfg.o\n    \/kfgb.o\n    \/kfiof.o\n    \/kfn.o\n    \/kfnm.o\n    \/kfnp.o\n    \/kfns.o\n    \/kfpkg.o\n    \/kfrc.o\n    \/kfsp.o\n    \/kdd.o\n    \/kdlxdup.o\n    \/kcffo.o\n    \/kcv.o\n    \/kcvfdb.o\n    \/krsd.o\n    \/gra.o\n    \/kzp.o\n    \/kzr.o\n    \/kzsr.o\n    \/kzu.o\n    \/kzup.o\n    \/updexe.o\n    \/kerutl.o\n    \/ksfd.o\n    \/ksp.o\n    \/kspt.o\n    \/ksu.o\n    \/qmxstr.o\n    bundledata_PSU.xml\n    ins_rdbms.mk\n    ins_rdbms.mk\n    ins_rdbms.mk\n    ins_rdbms.mk\n    bug19532017_downgrade.sql\n    bug19532017_upgrade.sql\n    catbundle.sql\n    dbmsqopi.sql\n    prvtqopi.plb\n    dbmssqlpatch.sql\n    prvtsqlpatch.plb\n    sqlpatch_bootstrap.sql\n    sqlpatch.pm\n    sqlpatch.pl\n    sqlpatch\n    bug19532017_downgrade.sql\n    utluppkg.sql\n    prvtpckl.plb\n    19769480_apply.sql\n    19769480_rollback.sql\n    catctl.pl\n    catlmnr.sql\n    catmmig.sql\n    catupstr.sql\n    noncdb_to_pdb.sql\n    utluppkg.sql\n    utlusts.sql\n    prvtpckl.plb\n    xml\n    \/xsfisop.o\n    \/xsiosec.o\n    \/lpxfsmbuf.o\n    \/kfmu.o\n    \/kgfz.o\n    \/kfmu.o\n    \/kgfz.o\n    \/qcdl.o\n    \/kgl.o\n    \/kgl2.o\n    \/kgsc.o\n    \/qci.o\n    \/qcs.o\n    \/qcs2.o\n    \/qcsvctx.o\n    \/qmxsax.o\n    diaus.msb\n    diaus.msg\n    oraus.msb\n    oraus.msg\n    libzt12.a\n    ins_net_client.mk\n    ins_rdbms.mk\n    ins_rdbms.mk\n    libzt12.a\n    libnnzst12.a\n    libnnz12.a\n    libcryptocme.sig\n    libcryptocme.so\n    libccme_asym.so\n    libccme_base.so\n    libccme_ecc.so\n    libccme_ecc_accel_fips.so\n    libnnz12.so\n\n\nSQL> \n<\/pre>\n
If you are not interested in the patch details, but only want to know the count of patches, use this query:<\/p>\n
SQL> select xmltransform(dbms_qopatch.get_opatch_count, dbms_qopatch.get_opatch_xslt) X from dual;\n\nX\n--------------------------------------------------------\nInterim patches: (5)\n\nSQL> \n<\/pre>\n
I want to apply patch\u00a021153266, but want to verify if the patch is applied.<\/p>\n
SQL> set pages 999 long 32000\nSQL> select xmltransform(dbms_qopatch.is_patch_installed(21153266), dbms_qopatch.get_opatch_xslt) X from dual;\n\nX\n----------------------------------------------------------\n\nSQL> \n<\/pre>\n
No results, so patch not installed.<\/p>\n
Download and install the patch using OPatch.<\/p>\n
[oracle@localhost 21153266]$ $ORACLE_HOME\/OPatch\/opatch apply\nOracle Interim Patch Installer version 12.1.0.1.10\nCopyright (c) 2015, Oracle Corporation.  All rights reserved.\n\nOracle Home       : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\nCentral Inventory : \/home\/oracle\/app\/oraInventory\n   from           : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\/oraInst.loc\nOPatch version    : 12.1.0.1.10\nOUI version       : 12.1.0.2.0\nLog file location : \/home\/oracle\/app\/oracle\/db\/12.1.0.2\/cfgtoollogs\/opatch\/21153266_Dec_01_2015_12_53_25\/apply2015-12-01_12-53-25PM_1.log\n\nVerifying environment and performing prerequisite checks...\nOPatch continues with these patches:   21153266  \n\nDo you want to proceed? [y|n]\ny\nUser Responded with: Y\nAll checks passed.\nProvide your email address to be informed of security issues, install and\ninitiate Oracle Configuration Manager. Easier for you if you use your My\nOracle Support Email address\/User Name.\nVisit http:\/\/www.oracle.com\/support\/policies.html for details.\nEmail address\/User Name: \n\nYou have not provided an email address for notification of security issues.\nDo you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y\n\nPlease shutdown Oracle instances running out of this ORACLE_HOME on the local system.\n(Oracle Home = '\/home\/oracle\/app\/oracle\/db\/12.1.0.2')\n\nIs the local system ready for patching? [y|n]\ny\nUser Responded with: Y\nBacking up files...\nApplying interim patch '21153266' to OH '\/home\/oracle\/app\/oracle\/db\/12.1.0.2'\n\nPatching component oracle.rdbms, 12.1.0.2.0...\nPatch 21153266 successfully applied.\nLog file location: \/home\/oracle\/app\/oracle\/db\/12.1.0.2\/cfgtoollogs\/opatch\/21153266_Dec_01_2015_12_53_25\/apply2015-12-01_12-53-25PM_1.log\n\nOPatch succeeded.\n[oracle@localhost 21153266]$ \n<\/pre>\n
Now, let us query the database again for patch installed.<\/p>\n
SQL> set long 32000 pages 9999\nSQL> select xmltransform(dbms_qopatch.is_patch_installed(21153266), dbms_qopatch.get_opatch_xslt) X from dual;\n\nX\n--------------------------------------------------------------------------------\nPatch Information:\n\t 21153266:   applied on 2015-12-01T12:54:08-08:00\nSQL> \n<\/pre>\n
To find out which files were updated by a patch, use:<\/p>\n
SQL> select xmltransform(dbms_qopatch.get_opatch_files(21153266), dbms_qopatch.get_opatch_xslt) patch_status from dual;\n\nPATCH_STATUS\n--------------------------------------------------------------------------------\nPatch Id :\t   21153266\n    \/kkm.o\n    ins_rdbms.mk\n\nSQL> \n<\/pre>\n
To find out which bug fixes are applied to the database, use:<\/p>\n
SQL> set pages 999 long 32000\nSQL> select xmltransform(dbms_qopatch.get_opatch_bugs, dbms_qopatch.get_opatch_xslt) X from dual;\n\nX\n--------------------------------------------------------------------------------\n  Bugs fixed:\n\t 21153266\n  Bugs fixed:\n\t 21047803  19699946  19245191  19223010  21047766  20408829  19231857  2\n1566944  21566993  21068507  19176885  20408866  19877336  19895326  21811517  1\n9153980  20415564  19909862  21555660  19855285  19895362  19623450\n  Bugs fixed:\n\t 19243521  20048359  19571367  20397490  20476175  20925795  21442094  2\n0245930  20134339  21281532  21421886  20413820  18966843  20441797  20281121  2\n1620471  19791273  20361671  18411216  19587324  19032777  19468991  17365043  2\n2062026  20471920  18743542  20688221  20122715\n  Bugs fixed:\n\t 20424899  19307662  20746251  20919320  20331945  20657441  20387265  2\n0294666  19703301  20165574  20899461  20558005  19399918  20402832  21225209  1\n9284031  20474192  19699191  20093776  19989009\n  Bugs fixed:\n\t 20440930  18306996  19865345  19536415  18607546  19487147  19035573  1\n9873610  19081128  19606174  19272708  17274537  19358317  19291380  19012119  1\n9687159  19547370  20348653  20425790  19524384  19385656  19928926  18681056  1\n9512341  18856999  16619249  19018447  19393542  20235511  19627012  19649152  1\n9670108  19684504  18417036  20347562  19658708  19896336  19805359  19637186  1\n8940497  19183343  19978542  19644859  18202441  19023822  19791377  18909599  1\n9335438  19238590  19841800  19619732  19315691  19730508  19597583  19065677  1\n9915271\n  Bugs fixed:\n\t 20284155  19157754  18885870  19303936  19708632  19371175  18618122  1\n9329654  19075256  19074147  19044962  19289642  19068610  18988834  19028800  1\n9561643  19058490  19390567  18967382  19174942  19174521  19176223  19501299  1\n9178851  18948177  18674047  19723336  19189525  19001390  19176326  19280225  1\n9143550  18250893  19180770  19155797  19016730  19185876  18354830  19067244  1\n8845653  18849537  18964978  19065556  19440586  19439759  19024808  18952989  1\n8990693  19052488  19189317  19409212  19124589  19154375  19279273  19468347  1\n9054077  19048007  19248799  19018206  18921743  14643995  18456643  16870214  1\n9434529  19706965  17835294  20074391  18791688  19197175  19134173  19174430  1\n9050649  19769480  19077215  19577410  18288842  18436647  19520602  19149990  1\n9076343  19195895  18610915  19068970  19518079  19304354  19001359  19676905  1\n9309466  19382851  18964939  16359751  19022470  19532017  19597439  18674024  1\n9430401\n\nSQL> \n<\/pre>\n
Using Queryable Patch Inventory, you need not be on the database sever to find out the patches applied. You can connect to the database remotely and run these queries. This also helps to build reporting and may be a patch repository.<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Oracle started releasing OVJM component of \u00a0DB PSU in October 2014, and recommend applying OVJM PSU along with (or after) DB PSU. I will demo applying DB PSU, and OVJM PSU on 12.1.0.2 database. Use this opportunity to introduce you to Queryable Patch Inventory (DBMS_QOPATCH), where you can query OPatch information directly from the database. … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":64,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[133],"tags":[],"class_list":["post-1641","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracledb"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=1641"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1641\/revisions"}],"predecessor-version":[{"id":3013,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1641\/revisions\/3013"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}