Oracle Database 12c Release 2 – Release Updates updated

Some time ago, I wrote about the Release Updates for Oracle Database 12c Release 2 (Database ). On Monday August 14th, released new Release Updates (12.2.0.1.170814) which replaces the Release Updates from July.

The patch numbers are:

  • 26610291 for the Grid Infrastructure Release Update 12.2.0.1.170814
  • 26609816 for the Database Release Update 12.2.0.1.170814

There is no updated RU for the OJVM RU (Patch 25811364).

According to the MOS notes, some customers had database startup issues with the first RU.

I haven‘t tested the new patches so far …

MOS-Notes:

  • Oracle Grid Infrastructure Release Update 12.2.0.1.170718 Known Issues (Doc ID 2251214.1)
  • Oracle Database Release Update 12.2.0.1.170718 Known Issues (Doc ID 2251222.1)
Posted in Common | Leave a comment

Oracle Grid Infrastructure: change the interval for the Cluster Verification Utility (ora.cvu)

Since Oracle 11.2.02. Oracle has integrated the Cluster Verification Utility (CVU) as a cluster resource. It‘s invoked every 6 hours and checks of your cluster. If you think, this is too often, you can change the interval. I‘ll show you how.

Let‘s take a look at our cluster first:

1
2
3
4
5
6
7
8
grid@ernie:~/ [-MGMTDB] crsctl status res ora.cvu -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cvu
      1        ONLINE  ONLINE       ernie                    STABLE

The runtime settings of ora.cvu are:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
grid@ernie:~/ [-MGMTDB] crsctl status res ora.cvu -v
NAME=ora.cvu
TYPE=ora.cvu.type
LAST_SERVER=ernie
STATE=ONLINE on ernie
TARGET=ONLINE
CARDINALITY_ID=1
OXR_SECTION=0
RESTART_COUNT=0
FAILURE_COUNT=0
FAILURE_HISTORY=
ID=ora.cvu 1 1
INCARNATION=1
LAST_RESTART=08/13/2017 14:13:43
LAST_STATE_CHANGE=08/13/2017 14:13:43
STATE_DETAILS=
INTERNAL_STATE=STABLE
TARGET_SERVER=ernie
RESOURCE_GROUP=
INSTANCE_COUNT=1

The command „crsctl stat res ora.cvu -p“ will show us the configuration of ora.cvu:

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
grid@ernie:~/ [-MGMTDB] crsctl stat res ora.cvu -p
NAME=ora.cvu
TYPE=ora.cvu.type
ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r--
ACTIONS=
ACTION_SCRIPT=
ACTION_TIMEOUT=60
ACTIVE_PLACEMENT=0
AGENT_FILENAME=%CRS_HOME%/bin/orajagent
AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=60
CHECK_RESULTS=7983364
CHECK_TIMEOUT=600
CLEAN_TIMEOUT=60
CRSHOME_SPACE_ALERT_STATE=OFF
CSS_CRITICAL=no
CV_DESTLOC=
DEGREE=1
DELETE_TIMEOUT=60
DESCRIPTION=Oracle CVU resource
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
GEN_NEXT_CHECK_TIME=1502648023
GEN_RUNNING_NODE=ernie
HOSTING_MEMBERS=
IGNORE_TARGET_ON_FAILURE=no
INSTANCE_FAILOVER=1
INTERMEDIATE_TIMEOUT=0
LOAD=1
LOGGING_LEVEL=1
MODIFY_TIMEOUT=60
NEXT_CHECK_TIME=
NLS_LANG=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=restricted
RELOCATE_BY_DEPENDENCY=1
RELOCATE_KIND=offline
RESOURCE_GROUP=
RESTART_ATTEMPTS=5
RESTART_DELAY=0
RUN_INTERVAL=21600
SCRIPT_TIMEOUT=30
SERVER_CATEGORY=ora.hub.category
SERVER_POOLS=*
START_CONCURRENCY=0
START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network)
START_TIMEOUT=0
STOP_CONCURRENCY=0
STOP_DEPENDENCIES=hard(intermediate:ora.net1.network)
STOP_TIMEOUT=0
TARGET_DEFAULT=default
TYPE_VERSION=1.1
UPTIME_THRESHOLD=1h
USER_WORKLOAD=no
USE_STICKINESS=0
USR_ORA_ENV=
WORKLOAD_CPU=0
WORKLOAD_CPU_CAP=0
WORKLOAD_MEMORY_MAX=0
WORKLOAD_MEMORY_TARGET=0

The CHECK_INTERVAL is the interval (in seconds) which is used by the clusterware to check the availability of the cvu daemon. The RUN_INTERVAL is the interval in which CVU is started by the clusterware. It is reported in seconds (21600 seconds = 360 minutes = 6 hours).

We want to change the RUN_INTERVAL. As with „ora.*“-resource we must not use the command „crsctl modify resource“ to change the settings. Trying to do so will lead to the following message

1
2
grid@ernie:~/ [-MGMTDB] crsctl modify resource ora.cvu -attr "RUN_INTERVAL=86400"
CRS-4995:  The command 'Modify  resource' is invalid in crsctl. Use srvctl for this command.

We have to use „srvctl modify cvu“:

1
2
3
4
5
6
7
grid@ernie:~/ [-MGMTDB] srvctl modify cvu -help
 
Modifies the check interval for the CVU resource.
Usage: srvctl modify cvu [-checkinterval ] [-destloc ]
    -checkinterval  Interval in minutes between checks
    -destloc                 Directory for copying and executing CVU files
    -help                          Print usage

Let‘s check the current setting first:

1
2
3
4
5
6
7
8
9
grid@ernie:~/ [-MGMTDB] srvctl config cvu
CVU is configured to run once every 360 minutes
CVU is enabled.
CVU is individually enabled on nodes:
CVU is individually disabled on nodes:
 
grid@ernie:~/ [-MGMTDB]
grid@ernie:~/ [-MGMTDB] srvctl modify cvu -checkinterval 1440
grid@ernie:~/ [-MGMTDB]

Let‘s crosscheck our change:

1
2
3
4
5
grid@ernie:~/ [-MGMTDB] srvctl config cvu
CVU is configured to run once every 1440 minutes
CVU is enabled.
CVU is individually enabled on nodes:
CVU is individually disabled on nodes:

So: crsctl reports the interval as „RUN_INTERVAL“ in seconds but if we want to change it with srvctl we have to specify the „CHECKINTERVAL“ in minutes – I think that‘s a little bit confusing.

With Oracle 12.2, you can find the CVU results in $ORACLE_BASE//crsdata/@global/cvu/baseline/cvures

1
2
3
4
5
6
7
8
9
10
11
12
grid@ernie:/u00/app/oracle/crsdata/@global/cvu/baseline/cvures/ [-MGMTDB] ls -l
total 1844
-rw-r--r--. 1 grid oinstall  94487 Aug  7 10:59 cvucheckreport_08072017105516.txt
-rw-r--r--. 1 grid oinstall  94487 Aug  7 16:59 cvucheckreport_08072017165512.txt
-rw-r--r--. 1 grid oinstall 277325 Aug  7 16:59 cvucheckreport_08072017165512.zip
-rw-r--r--. 1 grid oinstall  94487 Aug  7 22:59 cvucheckreport_08072017225513.txt
-rw-r--r--. 1 grid oinstall 277326 Aug  7 22:59 cvucheckreport_08072017225513.zip
-rw-r--r--. 1 grid oinstall 278107 Aug 12 09:27 cvucheckreport_08122017092343.zip
-rw-r--r--. 1 grid oinstall  94487 Aug 13 14:18 cvucheckreport_08132017141412.txt
-rw-r--r--. 1 grid oinstall 278192 Aug 13 14:18 cvucheckreport_08132017141412.zip
-rw-r--r--. 1 grid oinstall  94487 Aug 13 17:43 cvucheckreport_08132017173952.txt
-rw-r--r--. 1 grid oinstall 278822 Aug 13 17:43 cvucheckreport_08132017173952.zip

(my test cluster is not running 24 x 7 so you will not find the 6 hours interval in the file listing above).

In Oracle Enterprise Manager Cloud Control 13c Release 2 you will find the CVU output via „Cluster -> Monitoring -> All Metrics -> Clusterware Status -> Cluster Verification Output“.

Links:

MOS-Notes:

  • Clusterware resource ora.cvu FAQ (Doc ID 1524235.1)
  • Cluster Verification Utility (CLUVFY) FAQ (Doc ID 316817.1)
  • ora.cvu Resource Reports not Purged (Doc ID 2054765.1)
  • reports from ora.cvu resource using excessive disk space (Doc ID 1964482.1)
Posted in Common, RAC | Tagged , , , | Leave a comment

Patching Oracle 12.2 Grid Infrastructure before setting up a cluster

One of the first steps after setting up an Oracle cluster is patching the Grid Infrastructure to the most current patchlevel. Usually this has to be done on all cluster nodes separately and requires some time and effort. But what about patching the software before setting up the cluster?

Continue reading

Posted in Common, Oracle 12c, RAC | Tagged , | Leave a comment

Ad: Trivadis Performance Days 2017

More Information

Posted in Common | Comments Off on Ad: Trivadis Performance Days 2017

New kid on the block – let’s install “Database Release Update 12.2.0.1.170718”

At the DOAG database conference in May, Andrew Mendelsohn announced that Oracle will change the release schedule to annual releases and that patch naming will be changed to “Release Updates” (RU). The latter started – as announced – in July 2017 and now the first “Database Release Update” is available.
Let’s start patching.

Continue reading

Posted in Common, Oracle 12c | Tagged , , | Comments Off on New kid on the block – let’s install “Database Release Update 12.2.0.1.170718”