Oracle 12c database patch
Patch 24968615: DATABASE PROACTIVE BUNDLE PATCH 12.1.0.2.170117
|
Imp matalink Note
Oracle Recommended Patches -- Oracle Database (Doc ID 756671.1)
Recommendations / Certifications
Mandatory for Oracle Exadata Real Application Clusters 12.1.0.2.0
Recommended for Oracle Exadata Real Application Clusters 12.1.0.2.0
Recommended when Oracle Clusterware 12.1.0.2.0 is used with:
Oracle Exadata Database 12.1.0.2.0
Oracle Exadata Real Application Clusters 12.1.0.2.0
System Patch Contents
The following patches are included. Disabled items are included in the system patch and cannot be downloaded independently. Some patches may not apply to your configuration. Use Configuration Manager for a detailed applicability analysis.
24732088 DATABASE BUNDLE PATCH 12.1.0.2.170117 (Oracle Database)
24732088 DATABASE BUNDLE PATCH 12.1.0.2.170117 (Oracle Database)
24732088 DATABASE BUNDLE PATCH 12.1.0.2.170117 (Oracle Database)
24732088 DATABASE BUNDLE PATCH 12.1.0.2.170117 (Oracle Database)
25101514 MERGE REQUEST ON TOP OF OCW PSU 12.1.0.2.170117 FOR BUGS 21210985 21692274 (Oracle Database)
24732088 DATABASE BUNDLE PATCH 12.1.0.2.170117 (Oracle Database)
24732088 DATABASE BUNDLE PATCH 12.1.0.2.170117 (Oracle Database)
24732088 DATABASE BUNDLE PATCH 12.1.0.2.170117 (Oracle Database)
24732088 DATABASE BUNDLE PATCH 12.1.0.2.170117 (Oracle Database)
24732088 DATABASE BUNDLE PATCH 12.1.0.2.170117 (Oracle Database)
patch file info ..
-rw-r--r-- 1 oracle oinstall 1419459488 Apr 14 16:08 p24917825_121020_Linux-x86-64.zip
-rw-r--r-- 1 oracle oinstall 79808592 Apr 14 16:20 p6880880_122010_Linux-x86-64.zip
ora12c:/u01/app/oracle/product/12.1.0.2/db_1:N # line added by Agent
#orawin:/u01/app/oracle/product/12.1.0.2/db_1:N # line added by Agent
orawin:/u01/app/oracle/product/11.2.0.4/db_1:N # line added by Agent
vihaan:/u01/app/oracle/product/11.2.0.4/db_1:N # line added by Agent
+ASM:/u01/app/12.1.0.2/grid:N # line added by Agent
[oracle@oraasm12c ~]$ . oraenv
ORACLE_SID = [oracle] ? ora12c
The Oracle base has been set to /u01/app/oracle
[oracle@oraasm12c ~]$ . oraenv
ORACLE_SID = [ora12c] ?
The Oracle base remains unchanged with value /u01/app/oracle
[root@oraasm12c ~]# . oraenv
ORACLE_SID = [root] ? ora12c
The Oracle base has been set to /u01/app/oracle
[root@oraasm12c ~]# export PATH=$ORACLE_HOME/bin:$PATH:$ORACLE_HOME/OPatch
unzip p6880880_122010_Linux-x86-64.zip -d $ORACLE_HOME/
[root@oraasm12c oracle]# opatchauto apply /home/oracle/24917825 -oh /u01/app/oracle/product/12.1.0.2/db_1
OPatchauto session is initiated at Sat Apr 15 08:51:47 2017
System initialization log file is /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchautodb/systemconfig2017-04-15_08-51-55AM.log.
Session log file is /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchauto/opatchauto2017-04-15_08-52-06AM.log
The id for this session is TWWV
Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0.2/db_1
Patch applicablity verified successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Verifying patch inventory on home /u01/app/oracle/product/12.1.0.2/db_1
Patch inventory verified successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Preparing to bring down database service on home /u01/app/oracle/product/12.1.0.2/db_1
Successfully prepared home /u01/app/oracle/product/12.1.0.2/db_1 to bring down database service
Bringing down database service on home /u01/app/oracle/product/12.1.0.2/db_1
Database service successfully brought down on home /u01/app/oracle/product/12.1.0.2/db_1
Start applying binary patch on home /u01/app/oracle/product/12.1.0.2/db_1
Binary patch applied successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Starting database service on home /u01/app/oracle/product/12.1.0.2/db_1
Database service successfully started on home /u01/app/oracle/product/12.1.0.2/db_1
Preparing home /u01/app/oracle/product/12.1.0.2/db_1 after database service restarted
No step execution required.........
Prepared home /u01/app/oracle/product/12.1.0.2/db_1 successfully after database service restarted
Trying to apply SQL patch on home /u01/app/oracle/product/12.1.0.2/db_1
[WARNING] The local database(s) on "/u01/app/oracle/product/12.1.0.2/db_1" is not running. SQL changes, if any, cannot be applied;
[WARNING] The database instance 'ora12c' from '/u01/app/oracle/product/12.1.0.2/db_1', in host'oraasm12c' is not running. SQL changes, if any, will not be applied.
To apply. the SQL changes, bring up the database instance and run the command manually from any one node (run as oracle).
Refer to the readme to get the correct steps for applying the sql changes.
SQL patch applied successfully on home /u01/app/oracle/product/12.1.0.2/db_1
Verifying patches applied on home /u01/app/oracle/product/12.1.0.2/db_1
Patch verification completed with warning on home /u01/app/oracle/product/12.1.0.2/db_1
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:oraasm12c
SIDB Home:/u01/app/oracle/product/12.1.0.2/db_1
Summary:
==Following patches were SKIPPED:
Patch: /home/oracle/24917825/21436941
Reason: This patch is not applicable to this specified target type - "oracle_database"
Patch: /home/oracle/24917825/24828643
Reason: This patch is not applicable to this specified target type - "oracle_database"
==Following patches were SUCCESSFULLY applied:
Patch: /home/oracle/24917825/24732082
Log: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-04-15_08-53-33AM_1.log
Patch: /home/oracle/24917825/24828633
Log: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-04-15_08-53-33AM_1.log
OPatchauto session completed at Sat Apr 15 09:07:03 2017
Time taken to complete the session 15 minutes, 17 seconds
=====
SQL> startup ;
ORACLE instance started.
Total System Global Area 725614592 bytes
Fixed Size 2928632 bytes
Variable Size 557842440 bytes
Database Buffers 159383552 bytes
Redo Buffers 5459968 bytes
Database mounted.
Database opened.
SQL> startup ;
ORACLE instance started.
Total System Global Area 725614592 bytes
Fixed Size 2928632 bytes
Variable Size 557842440 bytes
Database Buffers 159383552 bytes
Redo Buffers 5459968 bytes
Database mounted.
Database opened.
SQL> alter pluggable database all open;
SQL> SELECT name, open_mode FROM v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
ORA12CPDB READ WRITE
SQL> select * from dba_registry_sqlpatch ;
no rows selected
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
Oracle Database 12c after restarting the database simply run datapatch from the OPatch directory:
cd $ORACLE_HOME/OPatch
or
[oracle@oraasm12c ~]$ cd /u01/app/oracle/product/12.1.0.2/db_1/OPatch/
[oracle@oraasm12c OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Sat Apr 15 09:15:11 2017
Copyright (c) 2012, 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_18210_2017_04_15_09_15_11/sqlpatch_invocation.log
Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done
Current state of SQL patches:
Bundle series PSU:
ID 170117 in the binary registry and not installed in any PDB
Adding patches to installation queue and performing prereq checks...
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED
Nothing to roll back
The following patches will be applied:
24732082 (DATABASE PATCH SET UPDATE 12.1.0.2.170117)
Installing patches...
Patch installation complete. Total patches installed: 2
Validating logfiles...
Patch 24732082 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/24732082/20904347/24732082_apply_ORA12C_CDBROOT_2017Apr15_09_16_35.log (no errors)
Patch 24732082 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/24732082/20904347/24732082_apply_ORA12C_PDBSEED_2017Apr15_09_17_35.log (no errors)
SQL Patching tool complete on Sat Apr 15 09:18:52 2017
col owner for a20
col DIRECTORY_NAME for a25
col DIRECTORY_PATH for a50
select owner, directory_name, directory_path from dba_directories where directory_name like 'OPATCH%' order by 2;
OWNER DIRECTORY_NAME DIRECTORY_PATH
-------------------- ------------------------- --------------------------------------------------
SYS OPATCH_INST_DIR /u01/app/oracle/product/12.1.0.2/db_1/OPatch
SYS OPATCH_LOG_DIR /u01/app/oracle/product/12.1.0.2/db_1/QOpatch
SYS OPATCH_SCRIPT_DIR /u01/app/oracle/product/12.1.0.2/db_1/QOpatch
ls -ltr /u01/app/oracle/product/12.1.0.2/db_1/QOpatch
total 16
-r-xr-xr-- 1 oracle oinstall 1372 Apr 7 2013 qopiprep.bat
-rw-r----- 1 oracle asmadmin 120 Mar 12 19:43 qopatch.log
-rw-r--r-- 1 oracle asmadmin 7251 Apr 15 09:35 qopatch_log.log
[oracle@oraasm12c OPatch]$ cd /u01/app/oracle/product/12.1.0.2/db_1/QOpatch
-r-xr-xr-- 1 oracle oinstall 1372 Apr 7 2013 qopiprep.bat
-rw-r----- 1 oracle asmadmin 120 Mar 12 19:43 qopatch.log
-rw-r--r-- 1 oracle asmadmin 7251 Apr 15 09:35 qopatch_log.log
Patch log file info ...
[oracle@oraasm12c QOpatch]$ cat qopatch_log.log
LOG file opened at 03/12/17 19:47:59
KUP-05004: Warning: Intra source concurrency disabled because parallel select was not requested.
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
KUP-04004: error while reading file /u01/app/oracle/product/12.1.0.2/db_1/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: /u01/app/oracle/product/12.1.0.2/db_1/QOpatch/qopiprep.bat: line 38: /u01/app/oracle/product/12.1.0.2/db_1/QOpatch/stout.txt: Permission denied
/u01/app/oracle/
KUP-04118: operation "pipe read", location "skudmir"
LOG file opened at 03/12/17 19:48:28
KUP-05004: Warning: Intra source concurrency disabled because parallel select was not requested.
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
LOG file opened at 03/12/17 19:48:35
KUP-05004: Warning: Intra source concurrency disabled because parallel select was not requested.
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
LOG file opened at 04/15/17 09:10:05
KUP-05004: Warning: Intra source concurrency disabled because parallel select was not requested.
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
LOG file opened at 04/15/17 09:15:59
KUP-05004: Warning: Intra source concurrency disabled because parallel select was not requested.
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
LOG file opened at 04/15/17 09:16:07
KUP-05004: Warning: Intra source concurrency disabled because parallel select was not requested.
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
LOG file opened at 04/15/17 09:16:14
KUP-05004: Warning: Intra source concurrency disabled because parallel select was not requested.
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
LOG file opened at 04/15/17 09:16:21
KUP-05004: Warning: Intra source concurrency disabled because parallel select was not requested.
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
LOG file opened at 04/15/17 09:27:15
KUP-05004: Warning: Intra source concurrency disabled because parallel select was not requested.
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
LOG file opened at 04/15/17 09:27:56
KUP-05004: Warning: Intra source concurrency disabled because parallel select was not requested.
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
LOG file opened at 04/15/17 09:34:06
KUP-05004: Warning: Intra source concurrency disabled because parallel select was not requested.
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
LOG file opened at 04/15/17 09:35:01
KUP-05004: Warning: Intra source concurrency disabled because parallel select was not requested.
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
*****************************************************
SQL> !$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | egrep -i 'DATABASE'
Oracle Database 12c 12.1.0.2.0
OF DATABASE RESOURCES
THE MGMT DATABASE IS DROPPED
18850051 24828633 Sat Apr 15 09:06:06 BST 2017 HPI-12102 GOT TYPO IN THE OUTPUT OF DATABASE DEPEN
18920408 24828633 Sat Apr 15 09:06:06 BST 2017 SOLSP-12.1-GH-SCF MOVE DATABASE BACK TO THE
18956780 24828633 Sat Apr 15 09:06:06 BST 2017 LNX64-12.1-GH MOVE DATABASE WITHOUT PATH DOES NOT
DATABASE
19067804 24828633 Sat Apr 15 09:06:06 BST 2017 LNX64-12.1-GH MOVE DATABASE FROM UNMANAGED HOME
19148982 24828633 Sat Apr 15 09:06:06 BST 2017 LNX64-12.1-GH MOVE DATABASE FROM LOCAL NON-SHARED
19150313 24828633 Sat Apr 15 09:06:06 BST 2017 LNX64-12.1-GH MOVE DATABASE FAILED WHEN SOURCE
19632437 24828633 Sat Apr 15 09:06:06 BST 2017 ADD FAST DATABASE NODE DEATH DETECTION SUPPORT ON
19925992 24828633 Sat Apr 15 09:06:06 BST 2017 DATABASE UPGRADE FAILED FROM 11.2.0.3 11.2.0.4 TO
FOR DATABASE
24451580 24828633 Sat Apr 15 09:06:06 BST 2017 SERVICE RESOURE BECOMES UNKNOWN WHEN DATABASE
DATABASE 12.1
23170620 24732082 Sat Apr 15 08:59:16 BST 2017 STORE CONTENTS OF PATCH DIRECTORY INTO DATABASE
24437510 24732082 Sat Apr 15 08:59:16 BST 2017 DATAPATCH FAILED WITH 'THE DATABASE MUST BE IN
DATABASE VAULT ENVIRONMENT
20017509 24006101 Sat Apr 15 08:58:50 BST 2017 SRVCTL STOP DATABASE -D HUNG AT CJQ PROCESS
20139391 24006101 Sat Apr 15 08:58:50 BST 2017 BROKER CALLS CRS TO RESTART FOR DATABASES NOT
20627866 24006101 Sat Apr 15 08:58:50 BST 2017 LOGICAL DICTIONARY CORRUPTION WHEN DATABASE IS
24577566 24006101 Sat Apr 15 08:58:50 BST 2017 INVALID DATABASE VAULT DVSYS PACKAGES AFTER DB
DURING DATABASE/PDB OPEN
AFFECTING DATABASE PERFORMANCE
DATABASE NATIONAL CHARACTER SET
21847223 22291127 Sat Apr 15 08:57:41 BST 2017 ORA-07445 [KSUSIG] FROM PMON LEADING TO DATABASE C
19879746 21948354 Sat Apr 15 08:57:08 BST 2017 DATABASE CRASHED WITH ORA-600 [2251], [65535], [42
19902195 21948354 Sat Apr 15 08:57:08 BST 2017 SETTING COMPATIBLE=11.0.0 FOR A 10.2 DATABASE
DATABASE SMART FLASH CACHE
18909599 20299023 Sat Apr 15 08:56:15 BST 2017 MOVE DATABASE FROM SHARE NFS TO SHARE NFS REPORT
ORA$BASE EDITION IN SOURCE DATABASE
19524384 20299023 Sat Apr 15 08:56:15 BST 2017 ORA-704, ORA-604, ORA-2240 AND DATABASE DOESN'T
18250893 19769480 Sat Apr 15 08:55:54 BST 2017 TT12.1.0.2SQLFUZZ2 DATABASE GUARD ALL BLOCKS
UPGRADED NCDB DATABASE PLUGGED AS PDB
19178851 19769480 Sat Apr 15 08:55:54 BST 2017 SOLSP-12.1-GH MOVE DATABASE FAILED BECAUSE CAN'T
19195895 19769480 Sat Apr 15 08:55:54 BST 2017 ORA-16000 DATABASE OPEN FOR READ-ONLY ACCESS
19279273 19769480 Sat Apr 15 08:55:54 BST 2017 STANDBY DATABASE SEARCHES INCORRECT DIRECTORY
19303936 19769480 Sat Apr 15 08:55:54 BST 2017 DATABASE PATCH SET UPDATE 12.1.0.2.1 (OCT2014)
19597439 19769480 Sat Apr 15 08:55:54 BST 2017 PRIMARY DATABASE AUTO BLOCK MEDIA RECOVERY NOT
19769480 19769480 Sat Apr 15 08:55:54 BST 2017 DATABASE PATCH SET UPDATE 12.1.0.2.2 (JAN2015)
$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | egrep -i 'DATABASE PSU|DATABASE PATCH SET UPDATE'
19303936 19769480 Sat Apr 15 08:55:54 BST 2017 DATABASE PATCH SET UPDATE 12.1.0.2.1 (OCT2014)
19769480 19769480 Sat Apr 15 08:55:54 BST 2017 DATABASE PATCH SET UPDATE 12.1.0.2.2 (JAN2015)
On sqlplus
[oracle@oraasm12c OPatch]$ !sql
sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sat Apr 15 09:19:13 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
col DESCRIPTION for a45
col ACTION_TIME for a30
col BUNDLE_SERIES for a15
select patch_id, patch_uid, description, action_time, action, status, bundle_series, bundle_id from dba_registry_sqlpatch ;
PATCH_ID PATCH_UID DESCRIPTION ACTION_TIME ACTION STATUS BUNDLE_SER BUNDLE_ID
---------- ---------- --------------------------------------------- ------------------------------ --------------- --------------- ---------- ----------
24732082 20904347 DATABASE PATCH SET UPDATE 12.1.0.2.170117 15-APR-17 09.18.38.433166 AM APPLY SUCCESS PSU 170117
set linesize 200 pagesize 200
with a as (select dbms_qopatch.get_opatch_lsinventory patch_output from dual)
select x.patch_id, x.patch_uid, x.description
from a,
xmltable('InventoryInstance/patches/*'
passing a.patch_output
columns
patch_id number path 'patchID',
patch_uid number path 'uniquePatchID',
description varchar2(80) path 'patchDescription',
sql_patch varchar2(8) path 'sqlPatch'
) x
PATCH_ID PATCH_UID DESCRIPTION
---------- ---------- --------------------------------------------------------------------------------
24828633 20758346 OCW Patch Set Update : 12.1.0.2.170117 (24828633)
24732082 20904347 Database Patch Set Update : 12.1.0.2.170117 (24732082)
24006101 20683584 Database Patch Set Update : 12.1.0.2.161018 (24006101)
23054246 20464632 Database Patch Set Update : 12.1.0.2.160719 (23054246)
22291127 19694308 Database Patch Set Update : 12.1.0.2.160419 (22291127)
21948354 19553095 Database Patch Set Update : 12.1.0.2.160119 (21948354)
21359755 19194568 Database Patch Set Update : 12.1.0.2.5 (21359755)
20831110 18977826 Database Patch Set Update : 12.1.0.2.4 (20831110)
20299023 18703022 Database Patch Set Update : 12.1.0.2.3 (20299023)
19769480 18350083 Database Patch Set Update : 12.1.0.2.2 (19769480)
10 rows selected.
set linesize 200 pagesize 200
col DESCRIPTION for a55
with a as (select dbms_qopatch.get_opatch_lsinventory patch_output from dual)
select x.*
from a,
xmltable('InventoryInstance/patches/*'
passing a.patch_output
columns
patch_id number path 'patchID',
patch_uid number path 'uniquePatchID',
description varchar2(80) path 'patchDescription',
constituent number path 'constituent',
patch_type varchar2(20) path 'patchType',
rollbackable varchar2(20) path 'rollbackable',
sql_patch varchar2(8) path 'sqlPatch',
DBStartMode varchar2(10) path 'sqlPatchDatabaseStartupMode'
) x
PATCH_ID PATCH_UID DESCRIPTION CONSTITUENT PATCH_TYPE ROLLBACKABLE SQL_PATC DBSTARTMOD
---------- ---------- ------------------------------------------------------- ----------- -------------------- -------------------- -------- ----------
24828633 20758346 OCW Patch Set Update : 12.1.0.2.170117 (24828633) bundle_member true false
24732082 20904347 Database Patch Set Update : 12.1.0.2.170117 (24732082) 24732082 singleton true true normal
24006101 20683584 Database Patch Set Update : 12.1.0.2.161018 (24006101) 24732082 singleton true true normal
23054246 20464632 Database Patch Set Update : 12.1.0.2.160719 (23054246) 24732082 singleton true true normal
22291127 19694308 Database Patch Set Update : 12.1.0.2.160419 (22291127) 24732082 singleton true true normal
21948354 19553095 Database Patch Set Update : 12.1.0.2.160119 (21948354) 24732082 singleton true true normal
21359755 19194568 Database Patch Set Update : 12.1.0.2.5 (21359755) 24732082 singleton true true normal
20831110 18977826 Database Patch Set Update : 12.1.0.2.4 (20831110) 24732082 singleton true true normal
20299023 18703022 Database Patch Set Update : 12.1.0.2.3 (20299023) 24732082 singleton true true normal
19769480 18350083 Database Patch Set Update : 12.1.0.2.2 (19769480) 24732082 singleton true true normal
10 rows selected.
select xmltransform(dbms_qopatch.get_opatch_install_info, dbms_qopatch.get_opatch_xslt) from dual;
XMLTRANSFORM(DBMS_QOPATCH.GET_OPATCH_INSTALL_INFO,DBMS_QOPATCH.GET_OPATCH_XSLT)
--------------------------------------------------------------------------------
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Inventory : /
SQL> select xmltransform(dbms_qopatch.is_patch_installed('24828633'), dbms_qopatch.get_opatch_xslt) from dual;
XMLTRANSFORM(DBMS_QOPATCH.IS_PATCH_INSTALLED('24828633'),DBMS_QOPATCH.GET_OPATCH
--------------------------------------------------------------------------------
Patch Information:
24828633: applied on 2017-04-15T09:06:06+01:00
set linesize 200
select patch_id, patch_uid, version, status, description from dba_registry_sqlpatch where bundle_series = 'PSU'
PATCH_ID PATCH_UID VERSION STATUS DESCRIPTION
---------- ---------- -------------------- --------------- ----------------------------------------------------------------------------------------------------
24732082 20904347 12.1.0.2 SUCCESS DATABASE PATCH SET UPDATE 12.1.0.2.170117
for rollback
$ORACLE_HOME/OPatch/datapatch -rollback 24828633 -force
