DBA.BG BlogDBA CommunityKrasimir KovachkiRadoslav StanoevPolya MilkovaAbout this siteContactLog in
  • DBA Community
  • Krasimir Kovachki
  • Radoslav Stanoev
  • Polya Milkova
  • About this site
  • Contact

Polya Milkova

  • Front Page
  • Categories
  • Archives
  • Latest comments
  • « Redo is inconsistent with data block ORA-00600: internal error code, arguments: [3020]
Patching Oracle DB home with - Patch 26636295: COMBO OF OJVM COMPONENT 12.1.0.2.171017 DB PSU + DB BP 12.1.0.2.171017

Patching Oracle DB home with - Patch 26636295: COMBO OF OJVM COMPONENT 12.1.0.2.171017 DB PSU + DB BP 12.1.0.2.171017

posted on 09 Nov 2017 by polya in Oracle 12c Patching

Patching Oracle DB home with - Patch 26636295: COMBO OF OJVM COMPONENT 12.1.0.2.171017 DB PSU + DB BP 12.1.0.2.171017 

It took me a lot of time to decide what to be my first post, because the Internet is full of information, cases and etc.
But I have decided to write about this case because I think that it would be good to have it here and share knowledge with you all.

 This topic is about patching Oracle Database Home 12.1.0.2 with the below Combo:

Patch 26636295: COMBO OF OJVM COMPONENT 12.1.0.2.171017 DB PSU + DB BP 12.1.0.2.171017

With this Combo you can also patch GI Home, but in our case we are patching only Database Home. (For reference you could check the readme in MOS)

Let's start with the steps that should be followed in order to accomplish the task.

First of all, you have to change the Opatch version to 12.2.0.1.7 or later based on the readme from the patch and as a best practises
Also you should be aware that lower OPatch version may lead to conflicts during patching process and this is primary due to patch level changes in the OPatch version.

In order to change the version do the following:

cd $ORACLE_HOME

mv OPatch OPatch_old

cd /stage/newpatch/

unzip p6880880_122010_Linux-x86-64.zip -d /u01/app/db/12.1.0.2/db1_temp/

Check the OPatch version:

$ORACLE_HOME/OPatch/opatch -version

Then unzip the Combo patch:

unzip p26636295_121020_Linux-x86-64.zip

[oracle@polya-rac1 newpatch]$ cd 26636295/
ls -lart
total 40
drwxrwxr-x. 4 oracle oinstall 4096 Sep 17 14:27 26635845
drwxr-xr-x. 7 oracle oinstall 4096 Oct 5 09:49 26635880
-rw-r--r--. 1 oracle oinstall 18 Oct 17 12:58 README.txt
-rw-r--r--. 1 oracle oinstall 19572 Oct 17 13:00 README.html
drwxr-xr-x. 4 oracle oinstall 4096 Oct 17 13:00 .
drwxr-xr-x. 3 oracle oinstall 4096 Nov 6 16:08 ..

One of the folders (26635845) is fro DB PSU and BP and the other is for OJVM (26635845)

.... Now we have to perform some pre-requisite steps

[oracle@polya-rac1 26636295]$ /u01/app/db/12.1.0.2/db1_temp/OPatch/opatch lsinventory -detail -oh /u01/app/db/12.1.0.2/db1_temp/

Oracle Interim Patch Installer version 12.2.0.1.10
Copyright (c) 2017, Oracle Corporation. All rights reserved.


Oracle Home : /u01/app/db/12.1.0.2/db1_temp
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/db/12.1.0.2/db1_temp//oraInst.loc
OPatch version : 12.2.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatch/opatch2017-11-06_16-10-30PM_1.log

Lsinventory Output file location : /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatch/lsinv/lsinventory2017-11-06_16-10-30PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: polya-rac1
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.


Installed Products (135):

.... cut

OPatch succeeded.
--------------------------------------------------------------------------------

Then check only for Database Home as home user - in our case oracle user :


[oracle@polya-rac1 26635880]$ cd /stage/newpatch/26636295
[oracle@polya-rac1 26636295]$ /u01/app/db/12.1.0.2/db1_temp/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/newpatch/26636295/26635880/26717470
Oracle Interim Patch Installer version 12.2.0.1.10
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/db/12.1.0.2/db1_temp
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/db/12.1.0.2/db1_temp/oraInst.loc
OPatch version : 12.2.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatch/opatch2017-11-06_16-13-38PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@polya-rac1 26636295]$ /u01/app/db/12.1.0.2/db1_temp/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/newpatch/26636295/26635880/26392192
Oracle Interim Patch Installer version 12.2.0.1.10
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/db/12.1.0.2/db1_temp
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/db/12.1.0.2/db1_temp/oraInst.loc
OPatch version : 12.2.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatch/opatch2017-11-06_16-13-51PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
--------------------------------------------------------------------------------

Now we will check if  enough free space is available in the Database Home:

Create file /tmp/patch_list_dbhome.txt with the following content:


cat /tmp/patch_list_dbhome.txt
/stage/newpatch/26636295/26635880/26392192
/stage/newpatch/26636295/26635880/26717470

Then run the following:

/u01/app/db/12.1.0.2/db1_temp/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt

....
Oracle Interim Patch Installer version 12.2.0.1.10
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/db/12.1.0.2/db1_temp
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/db/12.1.0.2/db1_temp/oraInst.loc
OPatch version : 12.2.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatch/opatch2017-11-06_16-15-56PM_1.log

Invoking prereq "checksystemspace"

Prereq "checkSystemSpace" passed.

OPatch succeeded.
--------------------------------------------------------------------------------

Then as root you have to run opatchauto apply -analyze option. It is simuating all steps online which will be done at the time of the patching:

[root@polya-rac1 26636295]# /u01/app/db/12.1.0.2/db1_temp/OPatch/opatchauto apply /stage/newpatch/26636295/26635880 -oh /u01/app/db/12.1.0.2/db1_temp/ -analyze

OPatchauto session is initiated at Mon Nov 6 16:26:30 2017
System initialization log file is /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatchautodb/systemconfig2017-11-06_04-27-00PM.log.

Session log file is /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatchauto/opatchauto2017-11-06_04-27-29PM.log
The id for this session is A4FL

Executing OPatch prereq operations to verify patch applicability on home /u01/app/db/12.1.0.2/db1_temp
Patch applicability verified successfully on home /u01/app/db/12.1.0.2/db1_temp


Verifying SQL patch applicability on home /u01/app/db/12.1.0.2/db1_temp
No step execution required.........
SQL patch applicability verified successfully on home /u01/app/db/12.1.0.2/db1_temp

OPatchAuto successful.

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

Analysis for applying patches has completed successfully:

Host:polya-rac1
RAC Home:/u01/app/db/12.1.0.2/db1_temp


==Following patches were SKIPPED:

Patch: /stage/newpatch/26636295/26635880/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /stage/newpatch/26636295/26635880/26392164
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /stage/newpatch/26636295/26635880/26392192
Log: /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-06_16-27-38PM_1.log

Patch: /stage/newpatch/26636295/26635880/26717470
Log: /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-06_16-27-38PM_1.log

OPatchauto session completed at Mon Nov 6 16:28:26 2017
Time taken to complete the session 1 minute, 56 seconds
--------------------------------------------------------------------------------

**** In the session log file we can see what checks are performed. The log file can be found in the output of the prompt command.

.... All seems fine. With this command we will patch explicitly only DB home and will shutdown only databases that are running of this home.

When it completes run the below command without -analyze again with root user:

[root@polya-rac1 26636295]# /u01/app/db/12.1.0.2/db1_temp/OPatch/opatchauto apply /stage/newpatch/26636295/26635880 -oh /u01/app/db/12.1.0.2/db1_temp/

OPatchauto session is initiated at Mon Nov 6 16:31:42 2017

System initialization log file is /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatchautodb/systemconfig2017-11-06_04-31-59PM.log.

Session log file is /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatchauto/opatchauto2017-11-06_04-32-25PM.log
The id for this session is L339

Executing OPatch prereq operations to verify patch applicability on home /u01/app/db/12.1.0.2/db1_temp
Patch applicability verified successfully on home /u01/app/db/12.1.0.2/db1_temp


Verifying SQL patch applicability on home /u01/app/db/12.1.0.2/db1_temp
No step execution required.........
SQL patch applicability verified successfully on home /u01/app/db/12.1.0.2/db1_temp


Preparing to bring down database service on home /u01/app/db/12.1.0.2/db1_temp
No step execution required.........
Successfully prepared home /u01/app/db/12.1.0.2/db1_temp to bring down database service


Performing prepatch operation on home /u01/app/db/12.1.0.2/db1_temp
Perpatch operation completed successfully on home /u01/app/db/12.1.0.2/db1_temp


Start applying binary patch on home /u01/app/db/12.1.0.2/db1_temp
Binary patch applied successfully on home /u01/app/db/12.1.0.2/db1_temp


Performing postpatch operation on home /u01/app/db/12.1.0.2/db1_temp
Postpatch operation completed successfully on home /u01/app/db/12.1.0.2/db1_temp


Preparing home /u01/app/db/12.1.0.2/db1_temp after database service restarted
No step execution required.........
Prepared home /u01/app/db/12.1.0.2/db1_temp successfully after database service restarted


Trying to apply SQL patch on home /u01/app/db/12.1.0.2/db1_temp
No step execution required.........
SQL patch applied successfully on home /u01/app/db/12.1.0.2/db1_temp

OPatchAuto successful.

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

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

Host:polya-rac1
RAC Home:/u01/app/db/12.1.0.2/db1_temp
Summary:

==Following patches were SKIPPED:

Patch: /stage/newpatch/26636295/26635880/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /stage/newpatch/26636295/26635880/26392164
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /stage/newpatch/26636295/26635880/26392192
Log: /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-06_16-33-16PM_1.log

Patch: /stage/newpatch/26636295/26635880/26717470
Log: /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatchauto/core/opatch/opatch2017-11-06_16-33-16PM_1.log

OPatchauto session completed at Mon Nov 6 16:59:43 2017
Time taken to complete the session 28 minutes, 2 seconds

**** For more details about the checks and steps that are performed, we can check the session log again.

Now we can check the inventory:

[oracle@polya-rac1 tmp]$ cd /u01/app/db/12.1.0.2/db1_temp/OPatch
[oracle@polya-rac1 OPatch]$ ./opatch lsinv
Oracle Interim Patch Installer version 12.2.0.1.10
Copyright (c) 2017, Oracle Corporation. All rights reserved.


Oracle Home : /u01/app/db/12.1.0.2/db1_temp
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/db/12.1.0.2/db1_temp/oraInst.loc
OPatch version : 12.2.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatch/opatch2017-11-06_17-01-42PM_1.log

Lsinventory Output file location : /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatch/lsinv/lsinventory2017-11-06_17-01-42PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: polya-rac1
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.

Interim patches (3) :

Patch 26717470 : applied on Mon Nov 06 16:59:02 CET 2017
Unique Patch ID: 21611145
Patch description: "Database Bundle Patch : 12.1.0.2.171017 (26717470)"
Created on 4 Oct 2017, 23:16:37 hrs PST8PDT
Sub-patch 26609798; "DATABASE BUNDLE PATCH: 12.1.0.2.170814 (26609798)"
Sub-patch 25869760; "DATABASE BUNDLE PATCH: 12.1.0.2.170718 (25869760)"
Sub-patch 25397136; "DATABASE BUNDLE PATCH: 12.1.0.2.170418 (25397136)"
Sub-patch 24732088; "DATABASE BUNDLE PATCH: 12.1.0.2.170117 (24732088)"
Sub-patch 24340679; "DATABASE BUNDLE PATCH: 12.1.0.2.161018 (24340679)"
Sub-patch 23144544; "DATABASE BUNDLE PATCH: 12.1.0.2.160719 (23144544)"
Sub-patch 22806133; "DATABASE BUNDLE PATCH: 12.1.0.2.160419 (22806133)"
Sub-patch 21949015; "DATABASE BUNDLE PATCH: 12.1.0.2.160119 (21949015)"
Sub-patch 21694919; "DATABASE BUNDLE PATCH: 12.1.0.2.13 (21694919)"
Sub-patch 21527488; "DATABASE BUNDLE PATCH: 12.1.0.2.12 (21527488)"
Sub-patch 21359749; "DATABASE BUNDLE PATCH: 12.1.0.2.11 (21359749)"
Sub-patch 21125181; "DATABASE BUNDLE PATCH: 12.1.0.2.10 (21125181)"
Sub-patch 20950328; "DATABASE BUNDLE PATCH: 12.1.0.2.9 (20950328)"
Sub-patch 20788771; "DATABASE BUNDLE PATCH: 12.1.0.2.8 (20788771)"
Sub-patch 20594149; "DATABASE BUNDLE PATCH: 12.1.0.2.7 (20594149)"
Sub-patch 20415006; "DATABASE BUNDLE PATCH: 12.1.0.2.6 (20415006)"
Sub-patch 20243804; "DATABASE BUNDLE PATCH: 12.1.0.2.5 (20243804)"
Bugs fixed:

... cut...

Patch 26392192 : applied on Mon Nov 06 16:33:28 CET 2017
Unique Patch ID: 21527520
Patch description: "OCW Patch Set Update : 12.1.0.2.171017 (26392192)"
Created on 2 Oct 2017, 09:28:19 hrs PST8PDT
Bugs fixed:

... cut ...

Patch 19877336 : applied on Wed Mar 11 13:44:48 CET 2015
Unique Patch ID: 18313828
Patch description: "Database PSU 12.1.0.2.2, Oracle JavaVM Component (Jan2015)"
Created on 21 Dec 2014, 23:48:38 hrs PST8PDT
Bugs fixed:
19699946, 19909862, 19223010, 19877336, 19895326, 19153980, 19855285
19895362, 19231857, 19245191 

--------------------------------------------------------------------------------

OPatch succeeded.

###########
DB PSU + DB BP 12.1.0.2.171017 applied.
###########

Then you have to apply OJVM:

as oracle user check for conflicts:

[oracle@polya-rac1 ~]$ cd /stage/newpatch/26636295/26635845
[oracle@polya-rac1 26635845]$ /u01/app/db/12.1.0.2/db1_temp/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.10
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/db/12.1.0.2/db1_temp
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/db/12.1.0.2/db1_temp/oraInst.loc
OPatch version : 12.2.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatch/opatch2017-11-06_17-04-23PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

 Now applying ... 

[oracle@polya-rac1 26635845]$ /u01/app/db/12.1.0.2/db1_temp/OPatch/opatch apply -local
Oracle Interim Patch Installer version 12.2.0.1.10
Copyright (c) 2017, Oracle Corporation. All rights reserved.


Oracle Home : /u01/app/db/12.1.0.2/db1_temp
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/db/12.1.0.2/db1_temp/oraInst.loc
OPatch version : 12.2.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatch/opatch2017-11-06_17-05-38PM_1.log

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

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/db/12.1.0.2/db1_temp')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '26635845' to OH '/u01/app/db/12.1.0.2/db1_temp'
ApplySession: Optional component(s) [ oracle.sqlj, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.javavm.server, 12.1.0.2.0...

Patching component oracle.javavm.server.core, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.javavm.client, 12.1.0.2.0...

Patching component oracle.dbjava.jdbc, 12.1.0.2.0...

Patching component oracle.dbjava.ic, 12.1.0.2.0...
Patch 26635845 successfully applied.
Sub-set patch [19877336] has become inactive due to the application of a super-set patch [26635845].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatch/opatch2017-11-06_17-05-38PM_1.log

OPatch succeeded.

Check again the inventory in order to see OJVM is applied: 

[oracle@polya-rac1 OPatch]$ ./opatch lsinv
Oracle Interim Patch Installer version 12.2.0.1.10
Copyright (c) 2017, Oracle Corporation. All rights reserved.


Oracle Home : /u01/app/db/12.1.0.2/db1_temp
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/db/12.1.0.2/db1_temp/oraInst.loc
OPatch version : 12.2.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatch/opatch2017-11-08_16-48-42PM_1.log

Lsinventory Output file location : /u01/app/db/12.1.0.2/db1_temp/cfgtoollogs/opatch/lsinv/lsinventory2017-11-08_16-48-42PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: polya-rac1
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.


Interim patches (3) :

Patch 26635845 : applied on Mon Nov 06 17:06:10 CET 2017
Unique Patch ID: 21564421
Patch description: "Database PSU 12.1.0.2.171017, Oracle JavaVM Component (OCT2017)"
Created on 17 Sep 2017, 05:27:37 hrs PST8PDT
Bugs fixed:
26635845, 26637592, 26570171, 26027162, 26023002, 26023025, 25437695
25494413, 25494379, 24917972, 25067795, 24534298, 25076732, 25076756
24315824, 21659726, 24448240, 24448282, 23177536, 22675136, 23265914
23265965, 23727148, 22674709, 22670413, 22670385, 21188537, 22139226
22118835, 22118851, 21555660, 21811517, 19623450, 21566993, 21566944
19176885, 21068507, 21047803, 21047766, 20415564, 20408829, 20408866
19877336, 19855285, 19909862, 19895362, 19895326, 19153980, 19231857
19223010, 19245191, 19699946

### A few steps have left. In order to apply the patches in the database, we have to perform the below steps.
Because we have OJVM, we have to set cluster_database to FALSE and startup upgrade:

[oracle@polya-rac1 OPatch]$ sqlplus / as sysdba
SQL> startup nomount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size 2932632 bytes
Variable Size 2634023016 bytes
Database Buffers 1644167168 bytes
Redo Buffers 13844480 bytes
SQL> show parameter cluster

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 6
cluster_interconnects string
SQL>
SQL>
SQL> alter system set cluster_database=FALSE scope=spfile sid='*';


SQL> shu immediate;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics
and Real Application Testing options
[oracle@polya-rac1 OPatch]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 7 16:12:03 2017

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

Connected to an idle instance.

SQL> startup upgrade;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size 2932632 bytes
Variable Size 2634023016 bytes
Database Buffers 1644167168 bytes
Redo Buffers 13844480 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
[oracle@polya-rac1 OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Tue Nov 7 16:12:49 2017
Copyright (c) 2012, 2017, Oracle. All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_34240_2017_11_07_16_12_49/sqlpatch_invocation.log

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

Current state of SQL patches:
Patch 26635845 (Database PSU 12.1.0.2.171017, Oracle JavaVM Component (OCT2017)):
Installed in the binary registry only
Bundle series DBBP:
ID 171017 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:
26635845 (Database PSU 12.1.0.2.171017, Oracle JavaVM Component (OCT2017))
26717470 (DATABASE BUNDLE PATCH 12.1.0.2.171017)

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

Validating logfiles...
Patch 26635845 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26635845/21564421/26635845_apply_RAC_2017Nov07_16_13_33.log (no errors)
Patch 26717470 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26717470/21611145/26717470_apply_RAC_2017Nov07_16_13_37.log (no errors)
SQL Patching tool complete on Tue Nov 7 16:15:21 2017
[oracle@polya-rac1 OPatch]$


[oracle@polya-rac1 OPatch]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 7 16:15:27 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, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> set lines 300
select PATCH_ID,PATCH_UID,VERSION,FLAGS,ACTION,STATUS,BUNDLE_SERIES,DESCRIPTION from dba_registry_sqlpatch; SQL>

PATCH_ID PATCH_UID VERSION FLAGS ACTION STATUS BUNDLE_SERIES DESCRIPTION
---------- ---------- -------------------- ---------- --------------- --------------- ------------------------------ ----------------------------------------------------------------------------------------------------
26635845 21564421 12.1.0.2 NJJ APPLY SUCCESS Database PSU 12.1.0.2.171017, Oracle JavaVM Component (OCT2017)
26717470 21611145 12.1.0.2 NB APPLY SUCCESS DBBP DATABASE BUNDLE PATCH 12.1.0.2.171017

SQL>
SQL>
SQL> alter system set cluster_database=TRUE scope=spfile sid='*';

System altered.

SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
[oracle@polya-rac1 OPatch]$ srvctl start database -d RAC -n polya-rac1

### Now we have applied successfully COMBO OF OJVM COMPONENT 12.1.0.2.171017 DB PSU + DB BP 12.1.0.2.171017

I hope that this article will be helpful and if you have any comments to share them.

Tags: 12.1.0.2.171017 DB BP 12.1.0.2.171017 Oracle 12c Oracle Database Oracle RAC Oracle RAC One Node Patch 26636295 Patching

2 comments

Comment from: kkovachki Member

Very useful!!
I will use your howto in the next patching!!!

14/11/17 @ 06:28

Comment from: polya Member

Thank you for your feedback! :)

14/11/17 @ 09:50


Form is loading...

This collection ©2023 by Polya Milkova • Contact • Help • Build your own website!

CCMS

Cookies are required to enable core site functionality.