Search This Blog

Total Pageviews

Sunday 24 September 2017

Patch 26609817: DATABASE RELEASE UPDATE 12.2.0.1.170814


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/ for errors:



 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

Oracle DBA

anuj blog Archive