DBA Hub

📋Steps in this guide1/2

Applying JVM patch in oracle 12c RAC DBACLASS

Applying JVM patch in oracle 12c RAC, stop the crs on both the nodes and then..

oracle clusteringintermediate
by OracleDba
11 views
1

Post patch installation:

1. Make cluster_database to false alter system set cluster_database=false scope=spfile; 2. start the database in upgrade in one node : 3. Run datapatch 4. Make cluster_data to true and start the database 5. Check the entry in dba_registry_sqlpatch:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
srvctl stop database -d B2CPRE


SQL> startup upgrade
ORACLE instance started.

Total System Global Area 2.4159E+11 bytes
Fixed Size                  7650192 bytes
Variable Size            2.0831E+11 bytes
Database Buffers         3.2212E+10 bytes
Redo Buffers             1066090496 bytes
Database mounted.
Database opened.

$ORACLE_HOME/OPatch/datapatch -verbose

SQL Patching tool version 12.1.0.2.0 on Sun Aug 14 18:19:27 2016
Copyright (c) 2016, Oracle.  All rights reserved.

Log file for this invocation: /oracle/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_47513_2016_08_14_18_19_27/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 22674709 (Database PSU 12.1.0.2.160419, Oracle JavaVM Component (Apr2016)):
  Installed in the SQL registry only
Patch 23177536 (Database PSU 12.1.0.2.160719, Oracle JavaVM Component (JUL2016)):
  Installed in the binary registry only
Bundle series PSU:
  ID 160719 in the binary registry and ID 160719 in the SQL registry

Adding patches to installation queue and performing prereq checks...
Installation queue:
  The following patches will be rolled back:
    22674709 (Database PSU 12.1.0.2.160419, Oracle JavaVM Component (Apr2016))
  The following patches will be applied:
    23177536 (Database PSU 12.1.0.2.160719, Oracle JavaVM Component (JUL2016))

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

Validating logfiles...
Patch 22674709 rollback: SUCCESS
  logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/22674709/20077446/22674709_rollback_B2CPRE_2016Aug14_18_20_48.log (no errors)
Patch 23177536 apply: SUCCESS
  logfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/23177536/20400009/23177536_apply_B2CPRE_2016Aug14_18_21_42.log (no errors)
SQL Patching tool complete on Sun Aug 14 18:21:42 2016

alter system set cluster_database=true scope=spfile;

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

- start the database

srvctl start database -d B2BCRMPD

SQL> select patch_id,status,description,action from dba_registry_sqlpatch;

  PATCH_ID STATUS          DESCRIPTION                                                                                          ACTION
---------- --------------- ---------------------------------------------------------------------------------------------------- ---------------
  22291127 SUCCESS         Database Patch Set Update : 12.1.0.2.160419 (22291127)                                               APPLY
  22674709 SUCCESS         Database PSU 12.1.0.2.160419, Oracle JavaVM Component (Apr2016)                                      APPLY
  23054246 SUCCESS         Database Patch Set Update : 12.1.0.2.160719 (23054246)                                               APPLY
  22674709 SUCCESS         Database PSU 12.1.0.2.160419, Oracle JavaVM Component (Apr2016)                                      ROLLBACK
  23177536 SUCCESS         Database PSU 12.1.0.2.160719, Oracle JavaVM Component (JUL2016)                                      APPLY
2

Applying JVM patch in standalone database

Applying psu patch in oracle standalone database

Comments (0)

Please to add comments

No comments yet. Be the first to comment!