Verifying Database operating system groups consistency check ...failed

Verification Check          :  User Mask

Verification Check          :  User Mask

Verification Check          :  Database operating system groups consistency check

Verification Check        :  DB Log Mode

[grid@rac02:+ASM2:/home/grid]

$ locate cvusys.sql

/u01/app/11.2.0.4/grid/cv/admin/cvusys.sql

/u01/app/oracle/product/11.2.0.4/db_1/cv/admin/cvusys.sql

[grid@rac02:+ASM2:/home/grid]

$ diff /u01/app/11.2.0.4/grid/cv/admin/cvusys.sql /u01/app/oracle/product/11.2.0.4/db_1/cv/admin/cvusys.sql

[grid@rac02:+ASM2:/home/grid]

$

++++++++++

[grid@rac02:+ASM2:/home/grid]

$ cluvfy

ERROR:

Invalid command line syntax.

USAGE:

cluvfy [-help|-version]

cluvfy stage {-list|-help}

cluvfy stage {-pre|-post} <stage-name> <stage-specific options>  [-verbose]

cluvfy comp  {-list|-help}

cluvfy comp  <component-name> <component-specific options>  [-verbose]

[grid@rac02:+ASM2:/home/grid]

$ cluvfy comp -list

USAGE:

cluvfy comp  <component-name> <component-specific options>  [-verbose]

Valid Components are:

      nodereach       : checks reachability between nodes

      nodecon         : checks node connectivity

      cfs             : checks CFS integrity

      ssa             : checks shared storage accessibility

      space           : checks space availability

      sys             : checks minimum system requirements

      clu             : checks cluster integrity

      clumgr          : checks cluster manager integrity

      ocr             : checks OCR integrity

      olr             : checks OLR integrity

      ha              : checks HA integrity

      freespace       : checks free space in CRS Home

      crs             : checks CRS integrity

      nodeapp         : checks node applications existence

      admprv          : checks administrative privileges

      peer            : compares properties with peers

      software        : checks software distribution

      acfs            : checks ACFS integrity

      asm             : checks ASM integrity

      gpnp            : checks GPnP integrity

      gns             : checks GNS integrity

      scan            : checks SCAN configuration

      ohasd           : checks OHASD integrity

      clocksync       : checks Clock Synchronization

      vdisk           : checks Voting Disk configuration and UDEV settings

      healthcheck     : checks mandatory requirements and/or best practice recommendations

      dhcp            : checks DHCP configuration

      dns             : checks DNS configuration

[grid@rac02:+ASM2:/home/grid]

$ cluvfy comp healthcheck

Verifying OS mandatory requirements

Verifying Multicast check ...passed

Verifying ASMLib installation and configuration verification. ...passed

Verifying Physical Memory ...passed

Verifying Available Physical Memory ...passed

Verifying Swap Size ...passed

Verifying Free Space: rac02:/u01/app/11.2.0.4/grid,rac02:/tmp ...passed

Verifying Free Space: rac01:/u01/app/11.2.0.4/grid,rac01:/tmp ...passed

Verifying User Existence: grid ...passed

Verifying Group Existence: oinstall ...passed

Verifying Group Membership: oinstall(Primary) ...passed

Verifying Run Level ...passed

Verifying Hard Limit: maximum open file descriptors ...passed

Verifying Soft Limit: maximum open file descriptors ...passed

Verifying Hard Limit: maximum user processes ...passed

Verifying Soft Limit: maximum user processes ...passed

Verifying Architecture ...passed

Verifying OS Kernel Version ...passed

Verifying OS Kernel Parameter: semmsl ...passed

Verifying OS Kernel Parameter: semmns ...passed

Verifying OS Kernel Parameter: semopm ...passed

Verifying OS Kernel Parameter: semmni ...passed

Verifying OS Kernel Parameter: shmmax ...passed

Verifying OS Kernel Parameter: shmmni ...passed

Verifying OS Kernel Parameter: shmall ...passed

Verifying OS Kernel Parameter: file-max ...passed

Verifying OS Kernel Parameter: ip_local_port_range ...passed

Verifying OS Kernel Parameter: rmem_default ...passed

Verifying OS Kernel Parameter: rmem_max ...passed

Verifying OS Kernel Parameter: wmem_default ...passed

Verifying OS Kernel Parameter: wmem_max ...passed

Verifying OS Kernel Parameter: aio-max-nr ...passed

Verifying Package: binutils-2.20.51.0.2 ...passed

Verifying Package: compat-libcap1-1.10 ...passed

Verifying Package: compat-libstdc++-33-3.2.3 (x86_64) ...passed

Verifying Package: libgcc-4.4.4 (x86_64) ...passed

Verifying Package: libstdc++-4.4.4 (x86_64) ...passed

Verifying Package: libstdc++-devel-4.4.4 (x86_64) ...passed

Verifying Package: sysstat-9.0.4 ...passed

Verifying Package: gcc-4.4.4 ...passed

Verifying Package: gcc-c++-4.4.4 ...passed

Verifying Package: ksh-20100621 ...passed

Verifying Package: make-3.81 ...passed

Verifying Package: glibc-2.12 (x86_64) ...passed

Verifying Package: glibc-devel-2.12 (x86_64) ...passed

Verifying Package: libaio-0.3.107 (x86_64) ...passed

Verifying Package: libaio-devel-0.3.107 (x86_64) ...passed

Verifying Users With Same UID ...passed

Verifying Current Group ID ...passed

Verifying Root user consistency ...passed

Verifying Network Time Protocol (NTP) ...passed

Verifying Same core file name pattern ...passed

Verifying User Not In Group: grid ...passed

Verifying User Mask ...failed

Verifying Task resolv.conf Integrity ...passed

Verifying Time zone consistency ...passed

Verifying Reverse path filter setting ...met

Verifying OS Best Practice

Verifying Hardware Clock synchronization at shutdown ...met

Verifying availability of port 8888 ...met

Verifying Reverse path filter setting ...met

Verifying Clusterware mandatory requirements

Verifying Node Connectivity ...passed

Verifying Multicast check ...passed

Verifying Time zone consistency ...passed

Verifying Voting Disk ...passed

Verifying Cluster Manager Integrity ...passed

Verifying UDev attributes check ...passed

Verifying UDev attributes check ...passed

Verifying User Mask ...failed

Verifying Cluster Integrity ...passed

Verifying OCR Integrity ...passed

Verifying CRS Integrity ...passed

Verifying Node Application Existence ...passed

Verifying Single Client Access Name (SCAN) ...passed

Verifying OLR Integrity ...passed

Verifying ACFS Integrity ...passed

Verifying User Not In Group: grid ...passed

Verifying Clock Synchronization ...passed

Verifying VIP Subnet configuration check ...passed

Verifying Clusterware Best Practice

Verifying CSS misscount parameter ...met

Verifying CSS reboottime parameter ...met

Verifying CSS disktimeout parameter ...met

Verifying Database "emu"

Please specify password for user "cvusys" :

Verifying Database mandatory requirements for "emu"

Verifying Easy Connect configuration ...passed

Verifying Database operating system groups consistency check ...failed

Verifying Database Best Practice for "emu"

Verifying PRE_PAGE_SGA ...met

Verifying OPTIMIZER_DYNAMIC_SAMPLING ...met

Verifying Invalid Java Objects ...met

Verifying SYSAUX tablespace existence ...met

Verifying JVM configuration for database ...not verified

Verifying Java based user in database ...met

Verifying Java Role Count ...not met

Verifying Invalid SYS or SYSTEM Schema Objects ...met

Verifying INVALID objects in the application related schemas ...met

Verifying SPFILE ...met

Verifying Database word size(bits) ...met

Verifying Duplicate SYS or SYSTEM Schema Objects ...met

Verifying MAX_DUMP_FILE_SIZE ...met

Verifying REMOTE_LISTENER ...met

Verifying Database Datafiles in Backup Mode ...met

Verifying Files Needing Media Recovery ...met

Verifying In-doubt Distributed Transactions ...met

Verifying Orphaned Dictionary Rows ...met

Verifying SYS-Owned Object Tables Check ...met

Verifying Users Granted CONNECT Role ...not met

Verifying Invalid Objects in dba_registry ...met

Verifying SSL Authenticated Database Users ...met

Verifying Materialized View Group Refresh Jobs ...met

Verifying Materialized View Manual Group Refresh ...met

Verifying DB Log Mode ...not met

Verifying Redo Log Size (MB) ...met

Verifying All tablespaces are locally managed ...met

Verifying Cluster Interconnects ...met

Verifying Automatic segment storage management ...met

Verifying Average GC CR Block Receive Time ...met

Verifying Average GC Current Block Receive Time ...met

Verifying Automatic Undo Management ...met

******************************************************************************************

        Summary of environment

******************************************************************************************

Date (mm/dd/yyyy)    :  10/22/2016

Time (hh:mm:ss)      :  04:41:31

Cluster name         :  dinh

Clusterware version  :  11.2.0.4.0

Grid home            :  /u01/app/11.2.0.4/grid

Grid User            :  grid

Operating system     :  Linux2.6.39-400.17.1.el6uek.x86_64

Database1            :  Database name     -  emu

                        Database version  -  11.2.0.4

                        Database home     -

                        /u01/app/oracle/product/11.

                        2.0.4/db_1

******************************************************************************************

System requirements

******************************************************************************************

Verification Check          :  User Mask

Verification Description    :  This is a prerequisite condition to make sure the user

                               file creation mask (umask) is "0022".

Verification Result         :  FAILED

Cluster-wide error details  :  Error - <CV_VAL>The Oracle base remains unchanged with

                               value

                               /u01/app/grid|CV_BEGIN|0002|CV_END|</CV_VAL><CV_VRES>0</C

                               V_VRES><CV_LOG>Exectask: Umask retrieval

                               successful</CV_LOG><CV_ERES>0</CV_ERES><CV_VAL>The

                               Oracle base remains unchanged with value

                               /u01/app/grid|CV_BEGIN|0002|CV_END|</CV_VAL><CV_VRES>0</C

                               V_VRES><CV_LOG>Exectask: Umask retrieval

                               successful</CV_LOG><CV_ERES>0</CV_ERES>

                               Cause - Cause Of Problem Not Available

                               Action - User Action Not Available

Node                Status    Expected Value                Actual Value

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

rac02               FAILED    0022                          0002

rac01               FAILED    0022                          0002

__________________________________________________________________________________________

Node                Error details

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

rac02               Error - PRVF-7611 : Proper user file creation  mask (umask) for

                    user "grid" is not found on node "rac02" [Expected = "0022" ; Found

                    = "0002"]

                    Cause -  The user's OS file creation mask (umask) was not the

                    required setting.

                    Action -  Set appropriate user file creation mask. Modify the users

                    .profile or .cshrc or .bashrc to include the required umask.

rac01               Error - PRVF-7611 : Proper user file creation  mask (umask) for

                    user "grid" is not found on node "rac01" [Expected = "0022" ; Found

                    = "0002"]

                    Cause -  The user's OS file creation mask (umask) was not the

                    required setting.

                    Action -  Set appropriate user file creation mask. Modify the users

                    .profile or .cshrc or .bashrc to include the required umask.

__________________________________________________________________________________________

Verification Check        :  Reverse path filter setting

Verification Description  :  Checks if reverse path filter setting for all private

                             interconnect network interfaces is correct

Verification Result       :  MET

Verification Summary      :  Check for Reverse path filter setting passed

Additional Details        :  Reverse path filter parameter "rp_filter" must be set to

                             the value of 0 or 2 for all the private interconnect

                             network interfaces, this will disable or relax the

                             filtering and allow Clusterware to function correctly

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    0|2                           0|2

rac01               PASSED    0|2                           0|2

__________________________________________________________________________________________

Verification Check        :  Time zone consistency

Verification Description  :  This task checks for the consistency of time zones across

                             systems.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Task resolv.conf Integrity

Verification Description  :  This task checks consistency of file /etc/resolv.conf file

                             across nodes

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  User Not In Group: grid

Verification Description  :  This is a prerequisite condition to make sure user "grid"

                             is not part of "root" group.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Same core file name pattern

Verification Description  :  This task checks the consistency of core file name pattern

                             across systems.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Network Time Protocol (NTP)

Verification Description  :  This task verifies cluster time synchronization on

                             clusters that use Network Time Protocol (NTP).

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Root user consistency

Verification Description  :  This test checks the consistency of the primary group of

                             the root user across the cluster nodes

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Current Group ID

Verification Description  :  This test verifies that the user is currently logged in to

                             the user's primary group.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Users With Same UID

Verification Description  :  This test checks that multiple users do not exist with

                             user id as "0".

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Package: libaio-devel-0.3.107 (x86_64)

Verification Description  :  This is a prerequisite condition to test whether the

                             package "libaio-devel-0.3.107 (x86_64)" is available on

                             the system.

Verification Result       :  PASSED

Verification Summary      :  Package libaio-devel(x86_64) meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    libaio-devel(x86_64)-0.3.107  libaio-devel(x86_64)-0.3.107

                                                            -10.el6

rac01               PASSED    libaio-devel(x86_64)-0.3.107  libaio-devel(x86_64)-0.3.107

                                                            -10.el6

__________________________________________________________________________________________

Verification Check        :  Package: libaio-0.3.107 (x86_64)

Verification Description  :  This is a prerequisite condition to test whether the

                             package "libaio-0.3.107 (x86_64)" is available on the

                             system.

Verification Result       :  PASSED

Verification Summary      :  Package libaio(x86_64) meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    libaio(x86_64)-0.3.107        libaio(x86_64)-0.3.107-10.el

                                                            6

rac01               PASSED    libaio(x86_64)-0.3.107        libaio(x86_64)-0.3.107-10.el

                                                            6

__________________________________________________________________________________________

Verification Check        :  Package: glibc-devel-2.12 (x86_64)

Verification Description  :  This is a prerequisite condition to test whether the

                             package "glibc-devel-2.12 (x86_64)" is available on the

                             system.

Verification Result       :  PASSED

Verification Summary      :  Package glibc-devel(x86_64) meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    glibc-devel(x86_64)-2.12      glibc-devel(x86_64)-2.12-1.1

                                                            49.el6

rac01               PASSED    glibc-devel(x86_64)-2.12      glibc-devel(x86_64)-2.12-1.1

                                                            49.el6

__________________________________________________________________________________________

Verification Check        :  Package: glibc-2.12 (x86_64)

Verification Description  :  This is a prerequisite condition to test whether the

                             package "glibc-2.12 (x86_64)" is available on the system.

Verification Result       :  PASSED

Verification Summary      :  Package glibc(x86_64) meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    glibc(x86_64)-2.12            glibc(x86_64)-2.12-1.149.el6

rac01               PASSED    glibc(x86_64)-2.12            glibc(x86_64)-2.12-1.149.el6

__________________________________________________________________________________________

Verification Check        :  Package: make-3.81

Verification Description  :  This is a prerequisite condition to test whether the

                             package "make-3.81" is available on the system.

Verification Result       :  PASSED

Verification Summary      :  Package make meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    make-3.81                     make-3.81-20.el6

rac01               PASSED    make-3.81                     make-3.81-20.el6

__________________________________________________________________________________________

Verification Check        :  Package: ksh-20100621

Verification Description  :  This is a prerequisite condition to test whether the

                             package "ksh-20100621" is available on the system.

Verification Result       :  PASSED

Verification Summary      :  Package ksh meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    ksh-20100621                  ksh-20120801-21.el6.1

rac01               PASSED    ksh-20100621                  ksh-20120801-21.el6.1

__________________________________________________________________________________________

Verification Check        :  Package: gcc-c++-4.4.4

Verification Description  :  This is a prerequisite condition to test whether the

                             package "gcc-c++-4.4.4" is available on the system.

Verification Result       :  PASSED

Verification Summary      :  Package gcc-c++ meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    gcc-c++-4.4.4                 gcc-c++-4.4.7-11.el6

rac01               PASSED    gcc-c++-4.4.4                 gcc-c++-4.4.7-11.el6

__________________________________________________________________________________________

Verification Check        :  Package: gcc-4.4.4

Verification Description  :  This is a prerequisite condition to test whether the

                             package "gcc-4.4.4" is available on the system.

Verification Result       :  PASSED

Verification Summary      :  Package gcc meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    gcc-4.4.4                     gcc-4.4.7-11.el6

rac01               PASSED    gcc-4.4.4                     gcc-4.4.7-11.el6

__________________________________________________________________________________________

Verification Check        :  Package: sysstat-9.0.4

Verification Description  :  This is a prerequisite condition to test whether the

                             package "sysstat-9.0.4" is available on the system.

Verification Result       :  PASSED

Verification Summary      :  Package sysstat meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    sysstat-9.0.4                 sysstat-9.0.4-20.el6

rac01               PASSED    sysstat-9.0.4                 sysstat-9.0.4-20.el6

__________________________________________________________________________________________

Verification Check        :  Package: libstdc++-devel-4.4.4 (x86_64)

Verification Description  :  This is a prerequisite condition to test whether the

                             package "libstdc++-devel-4.4.4 (x86_64)" is available on

                             the system.

Verification Result       :  PASSED

Verification Summary      :  Package libstdc++-devel(x86_64) meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    libstdc++-devel(x86_64)-4.4.  libstdc++-devel(x86_64)-4.4.

                              4                             7-11.el6

rac01               PASSED    libstdc++-devel(x86_64)-4.4.  libstdc++-devel(x86_64)-4.4.

                              4                             7-11.el6

__________________________________________________________________________________________

Verification Check        :  Package: libstdc++-4.4.4 (x86_64)

Verification Description  :  This is a prerequisite condition to test whether the

                             package "libstdc++-4.4.4 (x86_64)" is available on the

                             system.

Verification Result       :  PASSED

Verification Summary      :  Package libstdc++(x86_64) meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    libstdc++(x86_64)-4.4.4       libstdc++(x86_64)-4.4.7-11.e

                                                            l6

rac01               PASSED    libstdc++(x86_64)-4.4.4       libstdc++(x86_64)-4.4.7-11.e

                                                            l6

__________________________________________________________________________________________

Verification Check        :  Package: libgcc-4.4.4 (x86_64)

Verification Description  :  This is a prerequisite condition to test whether the

                             package "libgcc-4.4.4 (x86_64)" is available on the system.

Verification Result       :  PASSED

Verification Summary      :  Package libgcc(x86_64) meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    libgcc(x86_64)-4.4.4          libgcc(x86_64)-4.4.7-11.el6

rac01               PASSED    libgcc(x86_64)-4.4.4          libgcc(x86_64)-4.4.7-11.el6

__________________________________________________________________________________________

Verification Check        :  Package: compat-libstdc++-33-3.2.3 (x86_64)

Verification Description  :  This is a prerequisite condition to test whether the

                             package "compat-libstdc++-33-3.2.3 (x86_64)" is available

                             on the system.

Verification Result       :  PASSED

Verification Summary      :  Package compat-libstdc++-33(x86_64) meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    compat-libstdc++-33(x86_64)-  compat-libstdc++-33(x86_64)-

                              3.2.3                         3.2.3-69.el6

rac01               PASSED    compat-libstdc++-33(x86_64)-  compat-libstdc++-33(x86_64)-

                              3.2.3                         3.2.3-69.el6

__________________________________________________________________________________________

Verification Check        :  Package: compat-libcap1-1.10

Verification Description  :  This is a prerequisite condition to test whether the

                             package "compat-libcap1-1.10" is available on the system.

Verification Result       :  PASSED

Verification Summary      :  Package compat-libcap1 meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    compat-libcap1-1.10           compat-libcap1-1.10-1

rac01               PASSED    compat-libcap1-1.10           compat-libcap1-1.10-1

__________________________________________________________________________________________

Verification Check        :  Package: binutils-2.20.51.0.2

Verification Description  :  This is a prerequisite condition to test whether the

                             package "binutils-2.20.51.0.2" is available on the system.

Verification Result       :  PASSED

Verification Summary      :  Package binutils meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    binutils-2.20.51.0.2          binutils-2.20.51.0.2-5.36.el

                                                            6

rac01               PASSED    binutils-2.20.51.0.2          binutils-2.20.51.0.2-5.36.el

                                                            6

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: aio-max-nr

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "aio-max-nr" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter aio-max-nr meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=1048576;              Current=1048576;

                              Configured=1048576            Configured=1048576

rac01               PASSED    Current=1048576;              Current=1048576;

                              Configured=1048576            Configured=1048576

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: wmem_max

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "wmem_max" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter wmem_max meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=1048576;              Current=1048576;

                              Configured=1048576            Configured=1048576

rac01               PASSED    Current=1048576;              Current=1048576;

                              Configured=1048576            Configured=1048576

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: wmem_default

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "wmem_default" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter wmem_default meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=262144;               Current=262144;

                              Configured=262144             Configured=262144

rac01               PASSED    Current=262144;               Current=262144;

                              Configured=262144             Configured=262144

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: rmem_max

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "rmem_max" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter rmem_max meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=4194304;              Current=4194304;

                              Configured=4194304            Configured=4194304

rac01               PASSED    Current=4194304;              Current=4194304;

                              Configured=4194304            Configured=4194304

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: rmem_default

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "rmem_default" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter rmem_default meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=262144;               Current=262144;

                              Configured=262144             Configured=262144

rac01               PASSED    Current=262144;               Current=262144;

                              Configured=262144             Configured=262144

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: ip_local_port_range

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "ip_local_port_range" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter ip_local_port_range meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=between 9000.0 &      Current=between 9000.0 &

                              65500.0; Configured=between   65500.0; Configured=between

                              9000.0 & 65500.0              9000.0 & 65500.0

rac01               PASSED    Current=between 9000.0 &      Current=between 9000.0 &

                              65500.0; Configured=between   65500.0; Configured=between

                              9000.0 & 65500.0              9000.0 & 65500.0

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: file-max

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "file-max" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter file-max meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=6815744;              Current=6815744;

                              Configured=6815744            Configured=6815744

rac01               PASSED    Current=6815744;              Current=6815744;

                              Configured=6815744            Configured=6815744

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: shmall

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "shmall" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter shmall meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=2097152;              Current=4294967296;

                              Configured=2097152            Configured=4294967296

rac01               PASSED    Current=2097152;              Current=4294967296;

                              Configured=2097152            Configured=4294967296

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: shmmni

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "shmmni" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter shmmni meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=4096;                 Current=4096;

                              Configured=4096               Configured=4096

rac01               PASSED    Current=4096;                 Current=4096;

                              Configured=4096               Configured=4096

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: shmmax

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "shmmax" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter shmmax meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=4194373632;           Current=4398046511104;

                              Configured=4194373632         Configured=4398046511104

rac01               PASSED    Current=4194373632;           Current=4398046511104;

                              Configured=4194373632         Configured=4398046511104

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: semmni

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "semmni" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter semmni meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=128; Configured=128   Current=128; Configured=128

rac01               PASSED    Current=128; Configured=128   Current=128; Configured=128

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: semopm

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "semopm" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter semopm meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=100; Configured=100   Current=100; Configured=100

rac01               PASSED    Current=100; Configured=100   Current=100; Configured=100

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: semmns

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "semmns" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter semmns meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=32000;                Current=32000;

                              Configured=32000              Configured=32000

rac01               PASSED    Current=32000;                Current=32000;

                              Configured=32000              Configured=32000

__________________________________________________________________________________________

Verification Check        :  OS Kernel Parameter: semmsl

Verification Description  :  This is a prerequisite condition to test whether the OS

                             kernel parameter "semmsl" is properly set.

Verification Result       :  PASSED

Verification Summary      :  Kernel parameter semmsl meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    Current=250; Configured=250   Current=250; Configured=250

rac01               PASSED    Current=250; Configured=250   Current=250; Configured=250

__________________________________________________________________________________________

Verification Check        :  OS Kernel Version

Verification Description  :  This is a prerequisite condition to test whether the

                             system kernel version is at least "2.6.32".

Verification Result       :  PASSED

Verification Summary      :  Kernel version meets recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    2.6.32                        2.6.39-400.17.1.el6uek.x86_6

                                                            4

rac01               PASSED    2.6.32                        2.6.39-400.17.1.el6uek.x86_6

                                                            4

__________________________________________________________________________________________

Verification Check        :  Architecture

Verification Description  :  This is a prerequisite condition to test whether the

                             system has a certified architecture.

Verification Result       :  PASSED

Verification Summary      :  Architecture recommendation is met

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    x86_64                        x86_64

rac01               PASSED    x86_64                        x86_64

__________________________________________________________________________________________

Verification Check        :  Soft Limit: maximum user processes

Verification Description  :  This is a prerequisite condition to test whether the soft

                             limit for "maximum user processes" is set to at least 2047.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    2047                          16384

rac01               PASSED    2047                          16384

__________________________________________________________________________________________

Verification Check        :  Hard Limit: maximum user processes

Verification Description  :  This is a prerequisite condition to test whether the hard

                             limit for "maximum user processes" is set to at least

                             16384.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    16384                         16384

rac01               PASSED    16384                         16384

__________________________________________________________________________________________

Verification Check        :  Soft Limit: maximum open file descriptors

Verification Description  :  This is a prerequisite condition to test whether the soft

                             limit for "maximum open file descriptors" is set to at

                             least 1024.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    1024                          1024

rac01               PASSED    1024                          1024

__________________________________________________________________________________________

Verification Check        :  Hard Limit: maximum open file descriptors

Verification Description  :  This is a prerequisite condition to test whether the hard

                             limit for "maximum open file descriptors" is set to at

                             least 65536.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    65536                         65536

rac01               PASSED    65536                         65536

__________________________________________________________________________________________

Verification Check        :  Run Level

Verification Description  :  This is a prerequisite condition to test whether the

                             system is running with proper run level.

Verification Result       :  PASSED

Verification Summary      :  Run level recommendation are met

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    3,5                           5

rac01               PASSED    3,5                           5

__________________________________________________________________________________________

Verification Check        :  Group Membership: oinstall(Primary)

Verification Description  :  This is a prerequisite condition to test whether user

                             "grid" has group "oinstall" as its primary group.

Verification Result       :  PASSED

Verification Summary      :  Group oinstall is the primary group of user grid

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Group Existence: oinstall

Verification Description  :  This is a prerequisite condition to test whether group

                             "oinstall" exists on the system.

Verification Result       :  PASSED

Verification Summary      :  Group oinstall exists

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    true                          true

rac01               PASSED    true                          true

__________________________________________________________________________________________

Verification Check        :  User Existence: grid

Verification Description  :  This is a prerequisite condition to test whether user

                             "grid" exists on the system.

Verification Result       :  PASSED

Verification Summary      :  User grid exists

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    true                          true

rac01               PASSED    true                          true

__________________________________________________________________________________________

Verification Check        :  Free Space: rac01:/u01/app/11.2.0.4/grid,rac01:/tmp

Verification Description  :  This is a prerequisite condition to test whether

                             sufficient free space is available in the file system.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac01               PASSED    7.5GB                         36.9375GB

__________________________________________________________________________________________

Verification Check        :  Free Space: rac02:/u01/app/11.2.0.4/grid,rac02:/tmp

Verification Description  :  This is a prerequisite condition to test whether

                             sufficient free space is available in the file system.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    7.5GB                         36.96GB

__________________________________________________________________________________________

Verification Check        :  Swap Size

Verification Description  :  This is a prerequisite condition to test whether

                             sufficient total swap space is available on the system.

Verification Result       :  PASSED

Verification Summary      :  Swap configuration meets or exceeds recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    3.8126GB (3997832.0KB)        8GB (8388604.0KB)

rac01               PASSED    4.8048GB (5038216.0KB)        8GB (8388604.0KB)

__________________________________________________________________________________________

Verification Check        :  Available Physical Memory

Verification Description  :  This is a prerequisite condition to test whether the

                             system has at least 50MB (51200.0KB) of available physical

                             memory.

Verification Result       :  PASSED

Verification Summary      :  Available memory meets or exceeds recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    50MB (51200.0KB)              2.5582GB (2682448.0KB)

rac01               PASSED    50MB (51200.0KB)              3.5146GB (3685308.0KB)

__________________________________________________________________________________________

Verification Check        :  Physical Memory

Verification Description  :  This is a prerequisite condition to test whether the

                             system has at least 1.5GB (1572864.0KB) of total physical

                             memory.

Verification Result       :  PASSED

Verification Summary      :  Physical memory meets or exceeds recommendation

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    1.5GB (1572864.0KB)           7.8126GB (8192136.0KB)

rac01               PASSED    1.5GB (1572864.0KB)           7.8126GB (8192136.0KB)

__________________________________________________________________________________________

Verification Check        :  ASMLib installation and configuration verification.

Verification Description  :  This task checks the ASMLib installation and configuration

                             across the systems.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Multicast check

Verification Description  :  This task checks that network interfaces in subnet are

                             able to communicate over multicast IP address

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

******************************************************************************************

System recommendations

******************************************************************************************

Verification Check        :  Reverse path filter setting

Verification Description  :  Checks if reverse path filter setting for all private

                             interconnect network interfaces is correct

Verification Result       :  MET

Verification Summary      :  Check for Reverse path filter setting passed

Additional Details        :  Reverse path filter parameter "rp_filter" must be set to

                             the value of 0 or 2 for all the private interconnect

                             network interfaces, this will disable or relax the

                             filtering and allow Clusterware to function correctly

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    0|2                           0|2

rac01               PASSED    0|2                           0|2

__________________________________________________________________________________________

Verification Check        :  availability of port 8888

Verification Description  :  availability of port 8888

Verification Result       :  MET

Verification Summary      :  Check for availability of port 8888 passed

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    true                          true

rac01               PASSED    true                          true

__________________________________________________________________________________________

Verification Check        :  Hardware Clock synchronization at shutdown

Verification Description  :  Checks whether Hardware Clock is synchronized with the

                             system clock during system shutdown

Verification Result       :  MET

Verification Summary      :  Check for Hardware Clock synchronization at shutdown passed

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    HWCLOCKSYNC=1                 HWCLOCKSYNC=1

rac01               PASSED    HWCLOCKSYNC=1                 HWCLOCKSYNC=1

__________________________________________________________________________________________

******************************************************************************************

Clusterware requirements

******************************************************************************************

Verification Check          :  User Mask

Verification Description    :  This is a prerequisite condition to make sure the user

                               file creation mask (umask) is "0022".

Verification Result         :  FAILED

Cluster-wide error details  :  Error - <CV_VAL>The Oracle base remains unchanged with

                               value

                               /u01/app/grid|CV_BEGIN|0002|CV_END|</CV_VAL><CV_VRES>0</C

                               V_VRES><CV_LOG>Exectask: Umask retrieval

                               successful</CV_LOG><CV_ERES>0</CV_ERES><CV_VAL>The

                               Oracle base remains unchanged with value

                               /u01/app/grid|CV_BEGIN|0002|CV_END|</CV_VAL><CV_VRES>0</C

                               V_VRES><CV_LOG>Exectask: Umask retrieval

                               successful</CV_LOG><CV_ERES>0</CV_ERES>

                               Cause - Cause Of Problem Not Available

                               Action - User Action Not Available

Node                Status    Expected Value                Actual Value

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

rac02               FAILED    0022                          0002

rac01               FAILED    0022                          0002

__________________________________________________________________________________________

Node                Error details

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

rac02               Error - PRVF-7611 : Proper user file creation  mask (umask) for

                    user "grid" is not found on node "rac02" [Expected = "0022" ; Found

                    = "0002"]

                    Cause -  The user's OS file creation mask (umask) was not the

                    required setting.

                    Action -  Set appropriate user file creation mask. Modify the users

                    .profile or .cshrc or .bashrc to include the required umask.

rac01               Error - PRVF-7611 : Proper user file creation  mask (umask) for

                    user "grid" is not found on node "rac01" [Expected = "0022" ; Found

                    = "0002"]

                    Cause -  The user's OS file creation mask (umask) was not the

                    required setting.

                    Action -  Set appropriate user file creation mask. Modify the users

                    .profile or .cshrc or .bashrc to include the required umask.

__________________________________________________________________________________________

Verification Check        :  VIP Subnet configuration check

Verification Description  :  This task checks that all VIP subnetworks match each other

                             and at least one public network interface of the cluster

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Clock Synchronization

Verification Description  :  This test checks the Oracle Cluster Time Synchronization

                             Services across the cluster nodes.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  User Not In Group: grid

Verification Description  :  This is a prerequisite condition to make sure user "grid"

                             is not part of "root" group.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  ACFS Integrity

Verification Description  :  This test checks the integrity of Oracle ASM Cluster File

                             System across the cluster nodes.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  OLR Integrity

Verification Description  :  This test checks the integrity of OLR on the local node.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Single Client Access Name (SCAN)

Verification Description  :  This test verifies the Single Client Access Name

                             configuration.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Node Application Existence

Verification Description  :  This test checks the existence of Node Applications on the

                             system.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  CRS Integrity

Verification Description  :  This test checks the integrity of Oracle Clusterware stack

                             across the cluster nodes.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  OCR Integrity

Verification Description  :  This test checks the integrity of OCR across the cluster

                             nodes.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Cluster Integrity

Verification Description  :  This test checks the integrity of the cluster.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  UDev attributes check

Verification Description  :  This is a pre-check condition to check if the devices

                             entries in the Udev permissions file have been set up

                             correctly.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  UDev attributes check

Verification Description  :  This is a pre-check condition to check if the devices

                             entries in the Udev permissions file have been set up

                             correctly.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Cluster Manager Integrity

Verification Description  :  This test checks the integrity of cluster manager across

                             the cluster nodes.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Voting Disk

Verification Description  :  This test verifies the Oracle Clusterware voting disk

                             configuration which is used to determine which instances

                             are members of a cluster.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Time zone consistency

Verification Description  :  This task checks for the consistency of time zones across

                             systems.

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Multicast check

Verification Description  :  This task checks that network interfaces in subnet are

                             able to communicate over multicast IP address

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

Verification Check        :  Node Connectivity

Verification Description  :  This is a prerequisite condition to test whether

                             connectivity exists amongst all the nodes. The

                             connectivity is being tested for the subnets

                             "192.168.56.0,10.0.0.0"

Verification Result       :  PASSED

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

******************************************************************************************

Clusterware recommendations

******************************************************************************************

Verification Check        :  CSS disktimeout parameter

Verification Description  :  Checks if the CSS disktimeout is set correctly on the

                             system

Verification Result       :  MET

Verification Summary      :  Check for CSS disktimeout parameter passed

Additional Details        :  The maximum amount of time allowed for a voting file I/O

                             to complete; if this time is exceeded the voting disk will

                             be marked as offline.  Note that this is also the amount

                             of time that will be required for initial cluster

                             formation, i.e. when no nodes have previously been up and

                             in a cluster.

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=294430.1

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    200                           200

rac01               PASSED    200                           200

__________________________________________________________________________________________

Verification Check        :  CSS reboottime parameter

Verification Description  :  Checks if the CSS reboottime is set correctly on the system

Verification Result       :  MET

Verification Summary      :  Check for CSS reboottime parameter passed

Additional Details        :  reboottime (default 3 seconds) is the amount of time

                             allowed for a node to complete a reboot after the CSS

                             daemon has been evicted.

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=294430.1

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    3                             3

rac01               PASSED    3                             3

__________________________________________________________________________________________

Verification Check        :  CSS misscount parameter

Verification Description  :  Checks if the CSS misscount is set correctly on the system

Verification Result       :  MET

Verification Summary      :  Check for CSS misscount parameter passed

Additional Details        :  The CSS misscount parameter represents the maximum time,

                             in seconds, that a network heartbeat can be missed before

                             entering into a cluster reconfiguration to evict the node

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=294430.1

Node                Status    Expected Value                Actual Value

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

rac02               PASSED    30                            30

rac01               PASSED    30                            30

__________________________________________________________________________________________

******************************************************************************************

Database requirement checks for "emu"

******************************************************************************************

Verification Check          :  Database operating system groups consistency check

Verification Description    :  This task verifies consistency of database operating

                               system groups across nodes.

Verification Result         :  FAILED

Cluster-wide error details  :  Error - PRVG-11314 : The operating system groups for the

                               following databases are not consistent across all nodes:

                               emu

                               Cause -  An operating system group was not found or did

                               not have expected

                               name on all nodes where corresponding database is

                               present.

                               Action -  Ensure that the same operating system groups

                               exist and have the

                               same name on all nodes where corresponding database is

                               present.

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 FAILED    not applicable                not applicable

__________________________________________________________________________________________

Database(Instance)  Error details

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

emu                 Error - The database operating system group SYSOPER is inconsistent

                    across nodes rac01rac02,  for database emu.

                    Cause - Cause Of Problem Not Available

                    Action - User Action Not AvailableError - The database operating

                    system group SYSASM is inconsistent across nodes rac01rac02,  for

                    database emu.

                    Cause - Cause Of Problem Not Available

                    Action - User Action Not AvailableError - Database operating system

                    groups consistency check failed for database emu.

                    Cause - Cause Of Problem Not Available

                    Action - User Action Not Available

__________________________________________________________________________________________

Verification Check        :  Easy Connect configuration

Verification Description  :  This check ensures that the Easy Connect is configured as

                             an Oracle Net name resolution method

Verification Result       :  PASSED

Database(Instance)  Status    Expected Value                Actual Value

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

rac02               PASSED    not applicable                not applicable

rac01               PASSED    not applicable                not applicable

__________________________________________________________________________________________

******************************************************************************************

Database recommendation checks for "emu"

******************************************************************************************

Verification Check        :  DB Log Mode

Verification Description  :  Checks the database log archiving mode

Verification Result       :  NOT MET

Verification Summary      :  Check for DB Log Mode failed

Additional Details        :  If the database is in log archiving mode, then it is

                             always desirable and advisable to upgrade the database in

                             noarchivelog mode as that will reduce the time taken to

                             upgrade the database. After the upgrade, the database can

                             be reverted to the archivelog mode.

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=429825.1

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 FAILED    db_log_mode = NOARCHIVELOG    db_log_mode = ARCHIVELOG

__________________________________________________________________________________________

Database(Instance)  Error details

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

emu                 Error - NOARCHIVELOG mode is recommended when upgrading

                    Cause - Cause Of Problem Not Available

                    Action - User Action Not Available

__________________________________________________________________________________________

Verification Check        :  Users Granted CONNECT Role

Verification Description  :  Checks for the presence of any users with CONNECT role

Verification Result       :  NOT MET

Verification Summary      :  Check for Users Granted CONNECT Role failed

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 FAILED    connect_role_grantees = 0     connect_role_grantees = 5

__________________________________________________________________________________________

Database(Instance)  Error details

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

emu                 Error - CONNECT role granted users found

                    Cause - Cause Of Problem Not Available

                    Action - User Action Not Available

__________________________________________________________________________________________

Verification Check        :  Java Role Count

Verification Description  :  Checks JVM roles

Verification Result       :  NOT MET

Verification Summary      :  Check for Java Role Count failed

Additional Details        :  A healthy JVM should contain six roles. If there are more

                             or less than six roles, the JVM is inconsistent.

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 FAILED    java_role_count = 6           java_role_count = 0

__________________________________________________________________________________________

Database(Instance)  Error details

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

emu                 Error - The JVM roles appear to be inconsistent

                    Cause - Cause Of Problem Not Available

                    Action - User Action Not Available

__________________________________________________________________________________________

Verification Check        :  JVM configuration for database

Verification Description  :  Checks JVM configuration for database

Verification Result       :  NOT MET

Verification Summary      :  Check for JVM configuration for database failed

Additional Details        :  The query 'select dbms_java.longname('true') "JAVAVM

                             TESTING" from dual;' should return "true" if the JVM is

                             working correctly

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 FAILED    not applicable                not applicable

__________________________________________________________________________________________

Database(Instance)  Error details

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

emu                 Error - ORA-00904: "DBMS_JAVA"."LONGNAME": invalid identifier

                    Cause - Cause Of Problem Not Available

                    Action - User Action Not Available

__________________________________________________________________________________________

Verification Check        :  Automatic Undo Management

Verification Description  :  Check automatic undo management

Verification Result       :  MET

Verification Summary      :  Check for Automatic Undo Management passed

Additional Details        :  Oracle provides a fully automated mechanism, referred to

                             as automatic undo management, for managing undo

                             information and space. In this management mode, you create

                             an undo tablespace, and the server automatically manages

                             undo segments and space among the various active

                             sessions.You should set the UNDO_MANAGEMENT initialization

                             parameter to AUTO to enable automatic undo management.

Database(Instance)  Status    Expected Value                Actual Value

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

emu(emu1)           PASSED    undo_management = AUTO        undo_management = AUTO

emu(emu2)           PASSED    undo_management = AUTO        undo_management = AUTO

__________________________________________________________________________________________

Verification Check        :  Average GC Current Block Receive Time

Verification Description  :  Check Avg GC Current Block Receive Time

Verification Result       :  MET

Verification Summary      :  Check for Average GC Current Block Receive Time passed

Additional Details        :  The average global cache current block receive time should

                             typically be less than 15 milliseconds depending on your

                             system configuration and volume.  This is the average

                             latency of a current request round-trip from the

                             requesting instance to the holding instance and back to

                             the requesting instance.

Database(Instance)  Status    Expected Value                Actual Value

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

emu(emu1)           PASSED    avg_gc_current_block_recv_ti  avg_gc_current_block_recv_ti

                              me <= 15                      me =

                                                            2.84712860609328660016176867

                                                            080075492046

emu(emu2)           PASSED    avg_gc_current_block_recv_ti  avg_gc_current_block_recv_ti

                              me <= 15                      me =

                                                            2.65750286368843069873997709

                                                            049255441008

__________________________________________________________________________________________

Verification Check        :  Average GC CR Block Receive Time

Verification Description  :  Check Avg GC CR Block Receive Time

Verification Result       :  MET

Verification Summary      :  Check for Average GC CR Block Receive Time passed

Additional Details        :  The average gc cr block receive time should typically be

                             less than 15 milliseconds depending on your system

                             configuration and volume.  This is the average latency of

                             a consistent-read request round-trip from the requesting

                             instance to the holding instance and back to the

                             requesting instance.

Database(Instance)  Status    Expected Value                Actual Value

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

emu(emu1)           PASSED    avg_gc_cr_block_receive_time  avg_gc_cr_block_receive_time

                              <= 15                         =

                                                            0.60283687943262411347517730

                                                            4964539007092

emu(emu2)           PASSED    avg_gc_cr_block_receive_time  avg_gc_cr_block_receive_time

                              <= 15                         =

                                                            0.45454545454545454545454545

                                                            4545454545455

__________________________________________________________________________________________

Verification Check        :  Automatic segment storage management

Verification Description  :  Checks all tablespaces are using automatic segment storage

                             management

Verification Result       :  MET

Verification Summary      :  Check for Automatic segment storage management passed

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    auto_segment_space_managemen  auto_segment_space_managemen

                              t <= 0                        t = 0

__________________________________________________________________________________________

Verification Check        :  Cluster Interconnects

Verification Description  :  Check Cluster Interconnects

Verification Result       :  MET

Verification Summary      :  Check for Cluster Interconnects passed

Database(Instance)  Status    Expected Value                Actual Value

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

emu(emu1)           PASSED    cluster_interconnects >= 1    cluster_interconnects = 1

emu(emu2)           PASSED    cluster_interconnects >= 1    cluster_interconnects = 1

__________________________________________________________________________________________

Verification Check        :  All tablespaces are locally managed

Verification Description  :  Checks that all tablespaces are locally managed

Verification Result       :  MET

Verification Summary      :  Check for All tablespaces are locally managed passed

Additional Details        :  In order to reduce contention to the data dictionary,

                             rollback data, and reduce the amount of generated redo,

                             locally managed tablespaces should be used rather than

                             dictionary managed tablespaces.

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=175434.1

                             https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=105120.1

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    no_of_dictionary_managed_ts   no_of_dictionary_managed_ts

                              = 0                           = 0

__________________________________________________________________________________________

Verification Check        :  Redo Log Size (MB)

Verification Description  :  Checks if the redo log size is sufficient

Verification Result       :  MET

Verification Summary      :  Check for Redo Log Size (MB) passed

Additional Details        :  Ensure that the redo logfile size is greater than 4MB when

                             upgrading to 11g

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=601807.1

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    redo_log_file_less_than_4mb   redo_log_file_less_than_4mb

                              = 0                           = 0

__________________________________________________________________________________________

Verification Check        :  Materialized View Manual Group Refresh

Verification Description  :  Checks if there are any materialized view group refresh in

                             progress

Verification Result       :  MET

Verification Summary      :  Check for Materialized View Manual Group Refresh passed

Additional Details        :  Before proceeding with an upgrade ensure that all snapshot

                             refreshes are successfully completed, and that replication

                             is stopped.

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=258021.1

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    mv_group_manual_refresh = 0   mv_group_manual_refresh = 0

__________________________________________________________________________________________

Verification Check        :  Materialized View Group Refresh Jobs

Verification Description  :  Checks if there are any materialized view group refresh in

                             progress

Verification Result       :  MET

Verification Summary      :  Check for Materialized View Group Refresh Jobs passed

Additional Details        :  Before proceeding with an upgrade ensure that all snapshot

                             refreshes are successfully completed, and that replication

                             is stopped.

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=258021.1

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    mv_group_refresh_jobs = 0     mv_group_refresh_jobs = 0

__________________________________________________________________________________________

Verification Check        :  SSL Authenticated Database Users

Verification Description  :  Checks for SSL authenticated database users

Verification Result       :  MET

Verification Summary      :  Check for SSL Authenticated Database Users passed

Additional Details        :  Check whether database has any externally authenticated

                             SSL users. Refer the reference section after upgrade when

                             there are SSL authenticated database users.

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=429825.1

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    ext_ssl_authenticated_users   ext_ssl_authenticated_users

                              = 0                           = 0

__________________________________________________________________________________________

Verification Check        :  Invalid Objects in dba_registry

Verification Description  :  Checks for the presence of any invalid objects in

                             dba_registry

Verification Result       :  MET

Verification Summary      :  Check for Invalid Objects in dba_registry passed

Additional Details        :  Checking for invalid components and objects before

                             upgrade. There should not be any invalid objects in the

                             database before upgrade. Prior to upgrade, resolving

                             invalid objects under SYS and SYSTEM is mandatory. Run

                             $ORACLE_HOME/rdbms/admin/utlrp.sql to validate the invalid

                             objects in the database and then re-execute multiple

                             times, until there is no change in the number of invalid

                             objects.

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=556477.1

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    invalid_registry_comp_count   invalid_registry_comp_count

                              = 0                           = 0

__________________________________________________________________________________________

Verification Check        :  SYS-Owned Object Tables Check

Verification Description  :  Checks for the presence of any SYS-owned object tables

Verification Result       :  MET

Verification Summary      :  Check for SYS-Owned Object Tables Check passed

Additional Details        :  Refer the reference section before proceeding with any

                             upgrade.

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=579523.1

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    sys_obj_tables = 0            sys_obj_tables = 0

__________________________________________________________________________________________

Verification Check        :  Orphaned Dictionary Rows

Verification Description  :  Checks if there are any orphaned dictionary rows

Verification Result       :  MET

Verification Summary      :  Check for Orphaned Dictionary Rows passed

Additional Details        :  Refer the reference section before proceeding with any

                             upgrade.

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    orphan_dictionary_rows = 0    orphan_dictionary_rows = 0

__________________________________________________________________________________________

Verification Check        :  In-doubt Distributed Transactions

Verification Description  :  Checks if there are any in-doubt distributed transactions

Verification Result       :  MET

Verification Summary      :  Check for In-doubt Distributed Transactions passed

Additional Details        :  Indoubt distributed transactions need to be investigated

                             before attempting any database upgrade.  Refer the notes

                             in the reference section for more details.

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    indoubt_dist_trans = 0        indoubt_dist_trans = 0

__________________________________________________________________________________________

Verification Check        :  Files Needing Media Recovery

Verification Description  :  Checks if there are any files needing media recovery

Verification Result       :  MET

Verification Summary      :  Check for Files Needing Media Recovery passed

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    media_recovery_files = 0      media_recovery_files = 0

__________________________________________________________________________________________

Verification Check        :  Database Datafiles in Backup Mode

Verification Description  :  Checks if there are any database datafiles in backup mode

Verification Result       :  MET

Verification Summary      :  Check for Database Datafiles in Backup Mode passed

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    files_in_backup = 0           files_in_backup = 0

__________________________________________________________________________________________

Verification Check        :  REMOTE_LISTENER

Verification Description  :  Checks that the REMOTE_LISTENER parameter is set

Verification Result       :  MET

Verification Summary      :  Check for REMOTE_LISTENER passed

Additional Details        :  Setting the database REMOTE_LISTENER parameter makes it

                             possible to use listener-based load balancing and failover

                             features.

Database(Instance)  Status    Expected Value                Actual Value

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

emu(emu1)           PASSED    remote_listener != NULL       remote_listener =

                                                            dinh-scan:1521

emu(emu2)           PASSED    remote_listener != NULL       remote_listener =

                                                            dinh-scan:1521

__________________________________________________________________________________________

Verification Check        :  MAX_DUMP_FILE_SIZE

Verification Description  :  Checks the setting of MAX_DUMP_FILE_SIZE

Verification Result       :  MET

Verification Summary      :  Check for MAX_DUMP_FILE_SIZE passed

Additional Details        :  Initialization parameter MAX_DUMP_FILE_SIZE should be set

                             to 'unlimited' to avoid limiting the capture of failure

                             and hang diagnostic data. See MOS note 30762.1 for more

                             information.

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=30762.1

Database(Instance)  Status    Expected Value                Actual Value

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

emu(emu1)           PASSED    max_dump_file_size =          max_dump_file_size =

                              UNLIMITED                     unlimited

emu(emu2)           PASSED    max_dump_file_size =          max_dump_file_size =

                              UNLIMITED                     unlimited

__________________________________________________________________________________________

Verification Check        :  Duplicate SYS or SYSTEM Schema Objects

Verification Description  :  Checks for duplicate SYS or SYSTEM schema objects

Verification Result       :  MET

Verification Summary      :  Check for Duplicate SYS or SYSTEM Schema Objects passed

Additional Details        :  If any duplicate objects were found in the SYS and SYSTEM

                             schemas, refer to articles in the references section. Read

                             the exceptions carefully before taking action.

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=1030426.6

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    sys_duplicate_obj ~ 0|4       sys_duplicate_obj = 4

__________________________________________________________________________________________

Verification Check        :  Database word size(bits)

Verification Description  :  Checks that the database is created with 64-bit word size

Verification Result       :  MET

Verification Summary      :  Check for Database word size(bits) passed

Additional Details        :  When database is created with 32-bit word size and

                             upgrading database to 10.2.0.3.0  (64-bit)  there are

                             known issues.

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    db wordsize != B023           db wordsize = B047

__________________________________________________________________________________________

Verification Check        :  SPFILE

Verification Description  :  Checks that the instances are using SPFILE

Verification Result       :  MET

Verification Summary      :  Check for SPFILE passed

Additional Details        :  Using one and the same SPFILE for all instances in

                             clustered database is recommended.

Database(Instance)  Status    Expected Value                Actual Value

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

emu(emu1)           PASSED    spfile != NULL                spfile =

                                                            +DATA2/emu/spfileemu.ora

emu(emu2)           PASSED    spfile != NULL                spfile =

                                                            +DATA2/emu/spfileemu.ora

__________________________________________________________________________________________

Verification Check        :  INVALID objects in the application related schemas

Verification Description  :  Checks for the presence of INVALID objects in the

                             application related schemas (non SYS and SYSTEM)

Verification Result       :  MET

Verification Summary      :  Check for INVALID objects in the application related

                             schemas passed

Additional Details        :  Investigate invalid objects in the application related

                             schemas (non SYS and SYSTEM).

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    app_invalid_obj = 0           app_invalid_obj = 0

__________________________________________________________________________________________

Verification Check        :  Invalid SYS or SYSTEM Schema Objects

Verification Description  :  Checks presence of any invalid SYS or SYSTEM schema objects

Verification Result       :  MET

Verification Summary      :  Check for Invalid SYS or SYSTEM Schema Objects passed

Additional Details        :  There should not be any invalid SYS or SYSTEM schema

                             objects. Investigate invalid objects in the SYS and SYSTEM

                             schemas.

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    sys_invalid_obj = 0           sys_invalid_obj = 0

__________________________________________________________________________________________

Verification Check        :  Java based user in database

Verification Description  :  Checks presence of any Java based user in database

Verification Result       :  MET

Verification Summary      :  Check for Java based user in database passed

Additional Details        :  There should not be any Java Based users for database

                             version 9.0.1 and above.

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    java_based_users_count = 0    java_based_users_count = 0

__________________________________________________________________________________________

Verification Check        :  SYSAUX tablespace existence

Verification Description  :  Checks existence of SYSAUX tablespace

Verification Result       :  MET

Verification Summary      :  Check for SYSAUX tablespace existence passed

Additional Details        :  The SYSAUX tablespace is required for versions 10 and

                             above.  Refer to the Upgrade Companion for your target

                             version for more details.

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    SYSAUX_TS = 1                 SYSAUX_TS = 1

__________________________________________________________________________________________

Verification Check        :  Invalid Java Objects

Verification Description  :  Checks invalid java objects

Verification Result       :  MET

Verification Summary      :  Check for Invalid Java Objects passed

Database(Instance)  Status    Expected Value                Actual Value

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

emu                 PASSED    invalid_java_obj = 0          invalid_java_obj = 0

__________________________________________________________________________________________

Verification Check        :  OPTIMIZER_DYNAMIC_SAMPLING

Verification Description  :  Checks OPTIMIZER_DYNAMIC_SAMPLING setting

Verification Result       :  MET

Verification Summary      :  Check for OPTIMIZER_DYNAMIC_SAMPLING passed

Additional Details        :  Not having OPTIMIZER_DYNAMIC_SAMPLING set to the default

                             value of 2 can have an adverse impact on cost based

                             optimizer performance.  This is a required setting for EBS

                             and PeopleSoft applications.

Database(Instance)  Status    Expected Value                Actual Value

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

emu(emu1)           PASSED    optimizer_dynamic_sampling    optimizer_dynamic_sampling

                              = 2                           = 2

emu(emu2)           PASSED    optimizer_dynamic_sampling    optimizer_dynamic_sampling

                              = 2                           = 2

__________________________________________________________________________________________

Verification Check        :  PRE_PAGE_SGA

Verification Description  :  Checks PRE_PAGE_SGA setting

Verification Result       :  MET

Verification Summary      :  Check for PRE_PAGE_SGA passed

Additional Details        :  PRE_PAGE_SGA=true can significantly increase the time

                             required to establish database connections. In cases where

                             the connections to the database are very slow, check the

                             configuration of this parameter and set this parameter to

                             false, it avoids mapping the entire SGA and process

                             startup and consuming time.

References (URLs/Notes)   :  https://support.oracle.com/CSP/main/article?cmd=show&type=N

                             OT&id=289585.1

Database(Instance)  Status    Expected Value                Actual Value

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

emu(emu1)           PASSED    pre_page_sga = FALSE          pre_page_sga = FALSE

emu(emu2)           PASSED    pre_page_sga = FALSE          pre_page_sga = FALSE

__________________________________________________________________________________________

[grid@rac02:+ASM2:/home/grid]

$