Step-by-Step One Node Rac Applying Psu Patch on 12c Grid and DB Home

Description:-

As we already seen how to configure Oracle One node RAC in 12cR1 and the relocation of the instance from one node to another node. In this article, let us apply the July’18 PSU patch to the same environment.

For Oracle One Node RAC configuration, please click here. Below is the configuration of the environment.

High Level steps for applying the Patch:-

  • Current OPatch Version
  • Upgrade Opatch utility
  • Prepare for Patching
  • Applying Patch
  • Patch Verification

Current OPatch Version:-

Step 1:- Current version of Opatch Tool in our environment

$ export PATH=$ORACLE_HOME/OPatch:$PATH
$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.1.0.1.3

OPatch succeeded.

From the above output,the opatch version is 12.1.0.1.3. But as per our README document, the minimum OPatch utility version shoul be 12.2.0.1.12 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 12.2, which is available for download from My Oracle Support patch 6880880 by selecting the 12.2.0.1.0 release.

Upgrade Opatch utility:-

Step 2:- Backup the existing Opatch folder

Backup the OPatch directory as root user for GRID_HOME and oracle user for ORACLE_HOME(Database) in both the nodes of the cluster. Otherwise, if we try to backup as oracle user in GRID_HOME, we will receive permission issues.

GRID_HOME:
$ su - root
$ cd /oradb/app/12.1.0.2/grid/
$ mv OPatch/ OPatch_bkp
$ unzip <PATH_TO_PATCH>/p6880880_122010_Linux-x86-64.zip -d .
$ chown -R oracle:oinstall OPatch
$ chmod -R 755 OPatch

ORACLE_HOME:
$ su - oracle
$ cd /oradb/app/oracle/product/12.1.0.2/db_1
$ mv OPatch/ OPatch_bkp
$ unzip <PATH_TO_PATCH>/p6880880_122010_Linux-x86-64.zip -d .
$ chmod -R 755 OPatch

Now, as oracle user verify the OPatch utility version.

GRID_HOME:-(Both Nodes)

$ export ORACLE_HOME=/oradb/app/12.1.0.2/grid
$ export PATH=$ORACLE_HOME/OPatch:$PATH
$ opatch version
OPatch Version: 12.2.0.1.14

OPatch succeeded.

ORACLE_HOME:-(Both Nodes)

$ export ORACLE_HOME=/oradb/app/oracle/product/12.1.0.2/db_1
$ export PATH=$ORACLE_HOME/OPatch:$PATH
$ opatch version
OPatch Version: 12.2.0.1.14

OPatch succeeded.

Prepare for Patching:-

Step 3:- Preparing Node 1 to apply the PSU Patch

Now, login as root user and set the environmental variables

Applying Patch:-

Step 4:- Navigate to the patch location and follow the below steps to apply the patch.

$ cd <PATH_TO_PATCH>
$ unzip p27967747_121020_Linux-x86-64.zip
$ cd 27967747
$ $ORACLE_HOME/OPatch/opatchauto apply ./

OPatchauto session is initiated at Wed Sep 26 02:39:52 2018

System initialization log file is /oradb/app/12.1.0.2/grid/cfgtoollogs/opatchautodb/systemconfig2018-09-26_02-40-10AM.log.

Session log file is /oradb/app/12.1.0.2/grid/cfgtoollogs/opatchauto/opatchauto2018-09-26_02-41-29AM.log
The id for this session is WYWB

Executing OPatch prereq operations to verify patch applicability on home /oradb/app/12.1.0.2/grid

Executing OPatch prereq operations to verify patch applicability on home /oradb/app/oracle/product/12.1.0.2/db_1
Patch applicability verified successfully on home /oradb/app/oracle/product/12.1.0.2/db_1

Patch applicability verified successfully on home /oradb/app/12.1.0.2/grid

Verifying SQL patch applicability on home /oradb/app/oracle/product/12.1.0.2/db_1
SQL patch applicability verified successfully on home /oradb/app/oracle/product/12.1.0.2/db_1

Preparing to bring down database service on home /oradb/app/oracle/product/12.1.0.2/db_1

WARNING: The service ORCL.oracledbwr.com configured on orcl will not be switched as it is not configured to run on any other node(s).
Successfully prepared home /oradb/app/oracle/product/12.1.0.2/db_1 to bring down database service

Relocating RACOne home before patching on home /oradb/app/oracle/product/12.1.0.2/db_1
Relocated RACOne home before patching on home /oradb/app/oracle/product/12.1.0.2/db_1

Bringing down CRS service on home /oradb/app/12.1.0.2/grid
Prepatch operation log file location: /oradb/app/12.1.0.2/grid/cfgtoollogs/crsconfig/crspatch_prodrac101_2018-09-26_02-49-04AM.log
CRS service brought down successfully on home /oradb/app/12.1.0.2/grid

Performing prepatch operation on home /oradb/app/oracle/product/12.1.0.2/db_1
Perpatch operation completed successfully on home /oradb/app/oracle/product/12.1.0.2/db_1

Start applying binary patch on home /oradb/app/oracle/product/12.1.0.2/db_1
Binary patch applied successfully on home /oradb/app/oracle/product/12.1.0.2/db_1

Performing postpatch operation on home /oradb/app/oracle/product/12.1.0.2/db_1
Postpatch operation completed successfully on home /oradb/app/oracle/product/12.1.0.2/db_1


Start applying binary patch on home /oradb/app/12.1.0.2/grid
Binary patch applied successfully on home /oradb/app/12.1.0.2/grid

Starting CRS service on home /oradb/app/12.1.0.2/grid
Postpatch operation log file location: /oradb/app/12.1.0.2/grid/cfgtoollogs/crsconfig/crspatch_prodrac101_2018-09-26_03-42-46AM.log
CRS service started successfully on home /oradb/app/12.1.0.2/grid

Relocating back RACOne to home /oradb/app/oracle/product/12.1.0.2/db_1
Relocated back RACOne home successfully to home /oradb/app/oracle/product/12.1.0.2/db_1


Preparing home /oradb/app/oracle/product/12.1.0.2/db_1 after database service restarted
No step execution required.........


Trying to apply SQL patch on home /oradb/app/oracle/product/12.1.0.2/db_1
SQL patch applied successfully on home /oradb/app/oracle/product/12.1.0.2/db_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:prodrac101
RAC Home:/oradb/app/oracle/product/12.1.0.2/db_1
Version:12.1.0.2.0
Summary:

==Following patches were SKIPPED:

Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/26983807
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/27762277
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/27547329
Log: /oradb/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-09-26_02-55-50AM_1.log

Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/27762253
Log: /oradb/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-09-26_02-55-50AM_1.log


Host:prodrac101
CRS Home:/oradb/app/12.1.0.2/grid
Version:12.1.0.2.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/26983807
Log: /oradb/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-09-26_03-08-36AM_1.log

Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/27547329
Log: /oradb/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-09-26_03-08-36AM_1.log

Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/27762253
Log: /oradb/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-09-26_03-08-36AM_1.log

Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/27762277
Log: /oradb/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-09-26_03-08-36AM_1.log

OPatchauto session completed at Wed Sep 26 04:03:09 2018
Time taken to complete the session 83 minutes, 17 seconds

Patch Verification:-

Step 5:- Once the patch has been applied successfully, verify it in the database like below.

$ sqlplus / as sysdba
SQL> set serveroutput on
SQL> exec dbms_qopatch.get_sqlpatch_status;

Patch Id : 27547329
Action : APPLY
Action Time : 26-SEP-2018 04:03:06
Description : DATABASE PATCH SET UPDATE 12.1.0.2.180717
Logfile :
/oradb/app/oracle/cfgtoollogs/sqlpatch/27547329/22280349/27547329_apply_ORCL_201
8Sep26_04_00_51.log
Status : SUCCESS

PL/SQL procedure successfully completed.

Similarly, follow the same steps to apply the patch in Node 2.

Catch Me On:- Hariprasath Rajaram

Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba

 

Step-by-Step Applying PSU Patch in Oracle 12c For Single-Instance

Description:-

In this article we are going to see Oracle12c-Step-by-Step Applying PSU Patch in Oracle 12c For Single-Instance

High Level steps for applying the Patch 

  • Check current version of Opatch Tool
  • Upgrade the Opatch utility
  • Take the backup of ORACLE_HOME
  • Shutdown the Database and Listener
  • Apply PSU patch on ORACLE_HOME
  • Execute Post installation Scripts (datapatch)
  • Startup the Database and Listener
  • Check the dba_registry_sqlpatch .

Let’s Start the Demo:-

Step 1:- Current version of Opatch Tool in our environment 

[oracle@orcl:~ orcldemo] export PATH=$ORACLE_HOME/OPatch:$PATH
[oracle@orcl:~ orcldemo] $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.6

OPatch succeeded.

From the above output,the opatch version is 12.2.0.1.6.You must use the OPatch utility version 12.2.0.1.12 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 12.2, which is available for download from My Oracle Support patch 6880880 by selecting the 12.2.0.1.0 release.

Upgrade Opatch utility :-

Step 2:- Backup the existing Opatch folder

[oracle@orcl:~ orcldemo] cd $ORACLE_HOME
[oracle@orcl:db_1 orcldemo] mv OPatch/ OPatch_bkp

[oracle@orcl:~ orcldemo] ls -lrt
-rwxrw-rw- 1 oracle oinstall 271289497 Sep 21 18:52 p28163133_122010_Linux-x86-64.zip
-rwxrw-rw- 1 oracle oinstall 99183505 Sep 22 00:51 p6880880_122010_Linux-x86-64.zip

Step 3:- Unzip 6880880 patch

[oracle@orcl:~ orcldemo] unzip p6880880_122010_Linux-x86-64.zip -d $ORACLE_HOME
Archive: p6880880_122010_Linux-x86-64.zip
creating: /oradb/app/oracle/product/12.2.0.1/db_1/OPatch/

Step 4:- Check the opatch lsinventory

[oracle@orcl:~ orcldemo] $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2018, Oracle Corporation. All rights reserved.

Oracle Home : /oradb/app/oracle/product/12.2.0.1/db_1
Central Inventory : /oradb/app/oraInventory
from : /oradb/app/oracle/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.14
OUI version : 12.2.0.1.4
Log file location : /oradb/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2018-09-22_00-58-49AM_1.log

Lsinventory Output file location : /oradb/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-09-22_00-58-49AM.txt
-----------------------------------------------------------------------
Local Machine Information::
Hostname: orcl.localdomain.com
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.

There are no Interim patches installed in this Oracle Home.
----------------------------------------------------------------------
OPatch succeeded.

Step 5:- Take Backup of ORACLE_HOME (Rollback plan)

[oracle@orcl:~ orcldemo]$ tar -cvf oracle_home_Sep22_2018.tar $ORACLE_HOME

Step 6:- Shutdown Standby Database and Listener

[oracle@orcl:~ orcldemo]  export ORACLE_SID=orcldemo

[oracle@orcl:~ orcldemo] sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sat Sep 22 01:17:15 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
[oracle@orcl:~ orcldemo] lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-SEP-2018 01:20:00

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl.localdomain.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 22-SEP-2018 01:19:45
Uptime 0 days 0 hr. 0 min. 14 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oradb/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
Listener Log File /oradb/app/oracle/diag/tnslsnr/orcl/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.localdomain.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "DG4SQL" has 1 instance(s).
Instance "DG4SQL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Step 7 :- Apply PSU patch on ORACLE_HOME.

[oracle@orcl:~ orcldemo] unzip p28163133_122010_Linux-x86-64.zip

[oracle@orcl:28163133 orcldemo] ls -lrt
total 88
drwxr-x--- 13 oracle oinstall  4096 Jul  6 20:35 files
drwxr-x---  3 oracle oinstall  4096 Jul  6 20:35 etc
-rw-r--r--  1 oracle oinstall    21 Jul  6 20:35 README.txt
-rw-rw-r--  1 oracle oinstall 74345 Jul 16 07:46 README.html
[oracle@orcl:28163133 orcldemo] export PATH=/oradb/app/oracle/product/12.2.0.1/db_1/OPatch:$PATH

[oracle@orcl:28163133 orcldemo] opatch apply
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2018, Oracle Corporation. All rights reserved.

Oracle Home : /oradb/app/oracle/product/12.2.0.1/db_1
Central Inventory : /oradb/app/oraInventory
from : /oradb/app/oracle/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.14
OUI version : 12.2.0.1.4
Log file location : /oradb/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2018-09-22_01-26-15AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 28163133

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 = '/oradb/app/oracle/product/12.2.0.1/db_1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '28163133' to OH '/oradb/app/oracle/product/12.2.0.1/db_1'
ApplySession: Optional component(s) [ oracle.oid.client, 12.2.0.1.0 ] , [ oracle.has.crs, 12.2.0.1.0 ] , [ oracle.ons.daemon, 12.2.0.1.0 ] , [ oracle.network.cman, 12.2.0.1.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.precomp.common, 12.2.0.1.0...
Patching component oracle.has.deconfig, 12.2.0.1.0...
Patching component oracle.tfa, 12.2.0.1.0...
Patching component oracle.assistants.server, 12.2.0.1.0...
Patching component oracle.rdbms.rman, 12.2.0.1.0...
Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0...
Patching component oracle.rdbms, 12.2.0.1.0...
Patching component oracle.rdbms.deconfig, 12.2.0.1.0...
Patching component oracle.rdbms.util, 12.2.0.1.0...
Patching component oracle.ldap.rsf, 12.2.0.1.0...
Patching component oracle.ctx, 12.2.0.1.0...
Patching component oracle.rdbms.rsf, 12.2.0.1.0...
Patching component oracle.nlsrtl.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.dv, 12.2.0.1.0...
Patching component oracle.rdbms.lbac, 12.2.0.1.0...
Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...
Patching component oracle.oracore.rsf, 12.2.0.1.0...
Patching component oracle.xdk.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.oci, 12.2.0.1.0...
Patching component oracle.ctx.rsf, 12.2.0.1.0...
Patching component oracle.ldap.client, 12.2.0.1.0...
Patching component oracle.ons, 12.2.0.1.0...
Patching component oracle.xdk, 12.2.0.1.0...
Patching component oracle.xdk.parser.java, 12.2.0.1.0...
Patching component oracle.rdbms.crs, 12.2.0.1.0...
Patching component oracle.precomp.lang, 12.2.0.1.0...
Patching component oracle.network.rsf, 12.2.0.1.0...
Patching component oracle.ldap.rsf.ic, 12.2.0.1.0...
Patching component oracle.sdo, 12.2.0.1.0...
Patch 28163133 successfully applied.
Log file location: /oradb/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2018-09-22_01-26-15AM_1.log

OPatch succeeded.

Step 8:- Startup the Database and Listener

[oracle@orcl:28163133 orcldemo] sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sat Sep 22 01:33:17 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 1610612736 bytes
Fixed Size 8621232 bytes
Variable Size 1006633808 bytes
Database Buffers 587202560 bytes
Redo Buffers 8155136 bytes
Database mounted.
Database opened.
[oracle@orcl:28163133 orcldemo] lsnrctl start

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-SEP-2018 01:34:20

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Starting /oradb/app/oracle/product/12.2.0.1/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /oradb/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
Log messages written to /oradb/app/oracle/diag/tnslsnr/orcl/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.localdomain.com)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl.localdomain.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 22-SEP-2018 01:34:21
Uptime 0 days 0 hr. 13 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oradb/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
Listener Log File /oradb/app/oracle/diag/tnslsnr/orcl/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl.localdomain.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "DG4SQL" has 1 instance(s).
Instance "DG4SQL", status UNKNOWN, has 1 handler(s) for this service...
Service "orcldemo.localdomain.com" has 1 instance(s).
Instance "orcldemo", status READY, has 1 handler(s) for this service...
Service "orcldemoXDB.localdomain.com" has 1 instance(s).
Instance "orcldemo", status READY, has 1 handler(s) for this service...
The command completed successfully

Step 9:- Execute post patch steps and run datapatch command

[oracle@orcl:OPatch orcldemo] ./datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Sat Sep 22 01:38:48 2018
Copyright (c) 2012, 2018, Oracle. All rights reserved.

Log file for this invocation: /oradb/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_21552_2018_09_22_01_38_48/sqlpatch_invocation.log

Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of SQL patches:
Bundle series DBRU:
ID 180717 in the binary registry and not installed in the SQL registry

Adding patches to installation queue and performing prereq checks...
Installation queue:
Nothing to roll back
The following patches will be applied:
28163133 (DATABASE JUL 2018 RELEASE UPDATE 12.2.0.1.180717)

Installing patches...
Patch installation complete. Total patches installed: 1

Validating logfiles...
Patch 28163133 apply: SUCCESS
logfile: /oradb/app/oracle/cfgtoollogs/sqlpatch/28163133/22313390/28163133_apply_ORCLDEMO_2018Sep22_01_39_13.log (no errors)
SQL Patching tool complete on Sat Sep 22 01:41:53 2018

Step 10 :- After applying PSU patch,Check the DBA_REGISTRY_SQLPATCH

Step 11:- Check opatch lsinventory  and list of patches applied in ORACLE_HOME

[oracle@orcl:OPatch orcldemo] /oradb/app/oracle/product/12.2.0.1/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2018, Oracle Corporation. All rights reserved.

Oracle Home : /oradb/app/oracle/product/12.2.0.1/db_1
Central Inventory : /oradb/app/oraInventory
from : /oradb/app/oracle/product/12.2.0.1/db_1/oraInst.loc
OPatch version : 12.2.0.1.14
OUI version : 12.2.0.1.4
Log file location : /oradb/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2018-09-22_01-50-06AM_1.log

Lsinventory Output file location : /oradb/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-09-22_01-50-06AM.txt

-----------------------------------------------------------------------
Local Machine Information::
Hostname: orcl.localdomain.com
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 28163133 : applied on Sat Sep 22 01:30:43 IST 2018
Unique Patch ID: 22313390
Patch description: "Database Jul 2018 Release Update : 12.2.0.1.180717 (28163133)"
Created on 6 Jul 2018, 08:05:03 hrs PST8PDT
Bugs fixed:
8480838, 13554903, 14690846, 15931756, 16002385, 16727454, 16942578
17027695, 17533661, 17947871, 18308268, 18521691, 18594510, 18774543
19072655, 19211433, 19285025, 19327292, 19526548, 19614243, 19647894
19649997, 19721304, 20003668, 20087519, 20118035, 20324049, 20532077
20591151, 20620169, 20736227, 20756305, 20866970, 20976443, 21143725
21147908, 21159907, 21178363, 21186167, 21216226, 21320338, 21433452
21479706, 21520266, 21547051, 21981529, 21985256, 22007324, 22070853
22072543, 22087683, 22104866, 22179537, 22347493, 22364044, 22367053
22379010, 22446455, 22495673, 22503283, 22503297, 22504793, 22564336
22568728, 22581771, 22594071, 22599050, 22628825, 22645009, 22654475
22700845, 22729345, 22826067, 22843979, 22845846, 22864303, 22898198
22950945, 22970869, 22981722, 23019710, 23026585, 23035249, 23055900
23061453, 23065002, 23066146, 23080557, 23105538, 23125560, 23126545
23127945, 23151677, 23179662, 23184263, 23197730, 23234232, 23249829
23271203, 23300142, 23310101, 23312077, 23481673, 23491861, 23499160
23521523, 23527363, 23548817, 23572982, 23581777, 23588722, 23599216
23600861, 23602213, 23645516, 23665623, 23709062, 23715460, 23730961
23733981, 23735292, 23741944, 23746128, 23749454, 24010030, 24289874
24294174, 24303148, 24307571, 24308349, 24326444, 24326846, 24332831
24334708, 24336249, 24337882, 24341675, 24343905, 24345420, 24346821
24348685, 24350620, 24368004, 24373756, 24374976, 24376875, 24376878
24385983, 24401351, 24403922, 24415926, 24421668, 24423416, 24425056
24425998, 24435982, 24437162, 24443539, 24457597, 24461826, 24468470
24470606, 24473736, 24485034, 24485161, 24485174, 24486059, 24486237
24509056, 24534401, 24554533, 24555417, 24556967, 24560906, 24563422
24570598, 24573817, 24578718, 24578797, 24589081, 24589590, 24593740
24595699, 24600330, 24609592, 24609996, 24616637, 24617969, 24623975
24624166, 24642495, 24654629, 24655717, 24664211, 24668398, 24674197
24674955, 24676172, 24677696, 24680959, 24689376, 24692973, 24693290
24699619, 24710696, 24713381, 24714096, 24717183, 24717859, 24719799
24735430, 24737064, 24737403, 24737581, 24744383, 24744686, 24757934
24759556, 24760407, 24766309, 24786669, 24792678, 24793511, 24796092
24797119, 24800423, 24801152, 24802934, 24811725, 24812047, 24827228
24827654, 24831514, 24835919, 24843188, 24844549, 24845157, 24848746
24848923, 24850622, 24907917, 24908321, 24911709, 24912588, 24922704
24923080, 24923215, 24923338, 24923790, 24929210, 24938784, 24940060
24942749, 24953434, 24960044, 24966788, 24968162, 24976007, 24978100
25027852, 25029022, 25029423, 25034396, 25036474, 25044977, 25045228
25050160, 25051628, 25057811, 25058080, 25062592, 25063971, 25065563
25072986, 25078611, 25086233, 25087436, 25093872, 25098160, 25099339
25099497, 25099758, 25100063, 25100579, 25103996, 25107662, 25110233
25120284, 25121089, 25123585, 25124363, 25129925, 25140197, 25145163
25145215, 25150925, 25159176, 25162645, 25164293, 25166187, 25171084
25175723, 25176408, 25178032, 25178101, 25178179, 25179774, 25182817
25184555, 25186079, 25191872, 25192044, 25192729, 25199585, 25201454
25202355, 25203656, 25206864, 25207410, 25209912, 25210268, 25210499
25211628, 25223839, 25224242, 25225795, 25226665, 25227381, 25230945
25237577, 25240590, 25241448, 25241625, 25244807, 25248384, 25251648
25257085, 25259611, 25262869, 25263960, 25265499, 25287072, 25296876
25299227, 25305405, 25307368, 25313154, 25313411, 25316758, 25317989
25320555, 25328518, 25329664, 25335249, 25335360, 25335790, 25337332
25337640, 25348956, 25353983, 25357142, 25382812, 25383204, 25384462
25386748, 25388896, 25392535, 25395696, 25397936, 25405813, 25410017
25410180, 25410802, 25410877, 25411036, 25417050, 25417056, 25417958
25425451, 25425760, 25427662, 25429959, 25430120, 25433696, 25437699
25440818, 25444961, 25451531, 25455795, 25457409, 25459958, 25462714
25463844, 25472112, 25476149, 25478885, 25489342, 25489367, 25489607
25492379, 25498930, 25498994, 25516250, 25524955, 25528838, 25530080
25530814, 25536819, 25537470, 25539063, 25540738, 25546580, 25546608
25547901, 25551676, 25553616, 25554787, 25555252, 25557886, 25558986
25561296, 25569149, 25570929, 25575348, 25575628, 25579458, 25579761
25594901, 25597525, 25598473, 25600342, 25600421, 25602488, 25603923
25606091, 25607726, 25612095, 25614866, 25616268, 25616359, 25616417
25616645, 25631933, 25633101, 25634317, 25634348, 25635149, 25638456
25639019, 25643818, 25643931, 25646373, 25647325, 25648731, 25653109
25654459, 25654936, 25655390, 25655966, 25659655, 25660847, 25661819
25662088, 25662101, 25662524, 25669791, 25672640, 25674386, 25680221
25685152, 25687460, 25691904, 25694206, 25695903, 25700654, 25710420
25715167, 25717371, 25722055, 25722608, 25722720, 25728085, 25729507
25736747, 25739065, 25754606, 25757748, 25760195, 25764020, 25766822
25768681, 25772669, 25774077, 25775213, 25784002, 25785331, 25785441
25788879, 25789041, 25789277, 25789579, 25790353, 25797092, 25797124
25803545, 25807997, 25813931, 25822410, 25823754, 25825910, 25826740
25830492, 25832935, 25834581, 25838361, 25852885, 25856821, 25858672
25861398, 25865785, 25870579, 25871177, 25871639, 25871753, 25872127
25874050, 25874678, 25885148, 25888073, 25890056, 25895224, 25897615
25904273, 25904490, 25906117, 25911724, 25914276, 25919622, 25932524
25941836, 25943271, 25945130, 25947799, 25953857, 25954022, 25954054
25957038, 25963024, 25964954, 25967544, 25967985, 25970731, 25973152
25975723, 25977302, 25980605, 25980770, 25981498, 25982666, 25990907
25995938, 26006257, 26019148, 26024732, 26025681, 26029780, 26032573
26036748, 26037215, 26038086, 26039623, 26040483, 26045732, 26078437
26080410, 26083298, 26088426, 26088836, 26090767, 26091640, 26091786
26095327, 26095405, 26096382, 26108080, 26110632, 26111842, 26121990
26138085, 26149904, 26153977, 26169341, 26169345, 26170715, 26176002
26187943, 26189861, 26198757, 26198926, 26201113, 26223039, 26237431
26237773, 26242031, 26243698, 26244115, 26245237, 26249718, 26256131
26259265, 26261327, 26263328, 26263721, 26271001, 26308650, 26324769
26327624, 26330994, 26331743, 26333141, 26351334, 26353617, 26358670
26362821, 26366517, 26367012, 26374791, 26375250, 26380097, 26385189
26388538, 26396790, 26399626, 26412540, 26418088, 26420561, 26421667
26426526, 26430737, 26434999, 26435073, 26436168, 26438612, 26440749
26442308, 26444601, 26444887, 26446098, 26452606, 26475419, 26476244
26478970, 26479173, 26486365, 26492866, 26493289, 26498354, 26513709
26522439, 26523432, 26526726, 26537307, 26542135, 26544823, 26545688
26546070, 26546664, 26546754, 26548363, 26556014, 26569225, 26575788
26582460, 26584641, 26597140, 26599395, 26608137, 26609942, 26615291
26615690, 26623652, 26626879, 26629381, 26633355, 26635897, 26637273
26637824, 26639167, 26641610, 26650226, 26658759, 26659182, 26680105
26712331, 26714910, 26729494, 26729611, 26740700, 26744595, 26751106
26751171, 26758193, 26764561, 26765212, 26775602, 26784509, 26794786
26797591, 26802503, 26820076, 26822620, 26840654, 26849779, 26875822
26896659, 26898563, 26907327, 26908788, 26909100, 26911000, 26939314
26944190, 26967713, 26969321, 26970717, 26981902, 26983259, 26992964
27009164, 27034890, 27044297, 27052607, 27060167, 27060859, 27073314
27079140, 27087426, 27090765, 27110878, 27117822, 27119621, 27124624
27125872, 27133662, 27135993, 27138325, 27142373, 27153641, 27161071
27162405, 27163928, 27165231, 27169796, 27181537, 27199245, 27207110
27213224, 27229389, 27244337, 27250547, 27274536, 27285244, 27292213
27304410, 27305039, 27314206, 27314390, 27329612, 27333106, 27334316
27338912, 27338946, 27345231, 27346709, 27348081, 27349393, 27367194
27370965, 27375542, 27394703, 27395416, 27396624, 27396813, 27400598
27434193, 27439835, 27441326, 27442041, 27501373, 27501413, 27502420
27504770, 27508985, 27510959, 27534509, 27544973, 27548131, 27558861
27560602, 27595973, 27611612, 27613080, 27687880, 27688036, 27688692
27709046, 27748954, 27799032, 27847259, 27882176, 27959048, 27997875
28033429, 28040776, 28099662, 28140658, 28184554, 28188330, 28174827
-----------------------------------------------------------------------
OPatch succeeded.

 

Catch Me On:- Hariprasath Rajaram

Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba