Patch 26609817: DATABASE RELEASE UPDATE 12.2.0.1.170814
Last Updated 14-Aug-2017 18:32 (1+ month ago)
Product Oracle Database - Enterprise Edition
(More...)
Release Oracle Database 12.2.0.1.0 Platform Linux x86-64
Size 39.4 MB
Download Access Software
Classification General
Patch Tag All Database
-rw-r--r-- 1 oracle oinstall 41275925 Sep 24 12:45 p26609817_122010_Linux-x86-64.zip
unzip p26609817_122010_Linux-x86-64.zip
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.6
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/db_2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/db_2/oraInst.loc
OPatch version : 12.2.0.1.6
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.1.0/db_2/cfgtoollogs/opatch/opatch2017-09-24_12-54-11PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@cloud-ora 26609817]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.6
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/12.1.0/db_2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/db_2/oraInst.loc
OPatch version : 12.2.0.1.6
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.1.0/db_2/cfgtoollogs/opatch/opatch2017-09-24_12-54-11PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@cloud-ora 26609817]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.6
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/db_2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/db_2/oraInst.loc
OPatch version : 12.2.0.1.6
OUI version : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.1.0/db_2/cfgtoollogs/opatch/opatch2017-09-24_12-56-06PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 26609817
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/12.1.0/db_2')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '26609817' to OH '/u01/app/oracle/product/12.1.0/db_2'
Patching component oracle.oracore.rsf, 12.2.0.1.0...
Patching component oracle.ctx, 12.2.0.1.0...
Patching component oracle.rdbms.deconfig, 12.2.0.1.0...
Patching component oracle.rdbms.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.rman, 12.2.0.1.0...
Patching component oracle.rdbms, 12.2.0.1.0...
Patching component oracle.rdbms.util, 12.2.0.1.0...
Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...
Patching component oracle.tfa, 12.2.0.1.0...
Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0...
Patch 26609817 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0/db_2/cfgtoollogs/opatch/opatch2017-09-24_12-56-06PM_1.log
OPatch succeeded.
[oracle@cloud-ora 26609817]$
[oracle@cloud-ora 26609817]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Sep 24 13:01:39 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 3321888768 bytes
Fixed Size 8798216 bytes
Variable Size 1929383928 bytes
Database Buffers 1375731712 bytes
Redo Buffers 7974912 bytes
Database mounted.
Database opened.
SQL> def
DEFINE _DATE = "24-SEP-17" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "vihcdb1" (CHAR)
DEFINE _USER = "SYS" (CHAR)
DEFINE _PRIVILEGE = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1202000100" (CHAR)
DEFINE _EDITOR = "vi" (CHAR)
DEFINE _O_VERSION = "Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production" (CHAR)
DEFINE _O_RELEASE = "1202000100" (CHAR)
SQL> alter pluggable database all open;
Pluggable database altered.
SQL> quit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@cloud-ora 26609817]$ cd $ORACLE_HOME/OPatch
[oracle@cloud-ora OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Sun Sep 24 13:02:54 2017
Copyright (c) 2012, 2017, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_31769_2017_09_24_13_02_54/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 DBRU:
ID 170814 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 ANUJ
Nothing to roll back
The following patches will be applied:
26609817 (DATABASE RELEASE UPDATE 12.2.0.1.170814)
Installing patches...
Patch installation complete. Total patches installed: 3
Validating logfiles...
Patch 26609817 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26609817/21483023/26609817_apply_VIHCDB1_CDBROOT_2017Sep24_13_03_17.log (no errors)
Patch 26609817 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26609817/21483023/26609817_apply_VIHCDB1_PDBSEED_2017Sep24_13_04_00.log (no errors)
Patch 26609817 apply (pdb ANUJ): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26609817/21483023/26609817_apply_VIHCDB1_ANUJ_2017Sep24_13_04_00.log (no errors)
SQL Patching tool complete on Sun Sep 24 13:04:25 2017
select owner, status, count(*) from all_objects where object_type like '%JAVA%' group by owner, status;
select owner, status, count(*) from all_objects where object_type like '%JAVA%' group by owner, status;SQL>
no rows selected
SQL> SELECT version, status FROM dba_registry WHERE comp_id='JAVAVM';
no rows selected
This patch now includes the OJVM Mitigation patch (Patch:19721304). If an OJVM RU is installed or planned to be installed, no further actions are necessary. Otherwise, the workaround of using the OJVM Mitigation patch can be activated. As SYSDBA do the following from the admin directory:
SQL > @dbmsjdev.sql
SQL > exec dbms_java_dev.disable
Check the following log files in $ORACLE_BASE/cfgtoollogs/sqlpatch/26609817/
set linesize 200
select patch_id,action,status,description from dba_registry_sqlpatch
PATCH_ID ACTION STATUS DESCRIPTION
---------- --------------- --------------- ----------------------------------------------------------------------------------------------------
26609817 APPLY SUCCESS DATABASE RELEASE UPDATE 12.2.0.1.170814
