RACcheck

O utilitário RACcheck (RAC Configuration Audit Tool), da própria Oracle, é a forma mais completa de fazer uma verificação completa em um ambiente Oracle RAC, gerando um relatório completo e de excelente visualização, em HTML.
Ele está disponível no MOS (Doc ID 1268927.1), e atualmente está na versão 2.2.

Esta mesma Nota do MOS disponibiliza a versão 2.2.3 como Beta, que estou testando neste Post.

A execução abaixo foi feita na Nerv, no ambiente criado pelos alunos da turma 22OR, um RAC de 8 Nós, em OEL 6.4, e Grid e Database na versão 11.2.0.4.

Outro item interessante do RACcheck é que ele dá uma nota, de 0 a 100, para a aderência de seu ambiente às melhores práticas.

Veja aqui o relatório completo: raccheck_nerv01_RAC01_092513_055913.html

Para utilizar o RACcheck é muito simples, basta baixar, descompactar, e executar o programa raccheck.

[oracle@nerv01 ~]$ ./raccheck
./raccheck: line 10715: perl: command not found
./raccheck: line 10716: perl: command not found
./raccheck: line 10719: [[: -: syntax error: operand expected (error token is "-")
expr: non-numeric argument
expr: syntax error

CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /u01/app/11.2.0/grid?[y/n][y]

Checking ssh user equivalency settings on all nodes in cluster

Node nerv03 is configured for ssh user equivalency for oracle user

Node nerv04 is configured for ssh user equivalency for oracle user

Node nerv05 is configured for ssh user equivalency for oracle user

Node nerv02 is configured for ssh user equivalency for oracle user

Node nerv08 is configured for ssh user equivalency for oracle user

Node nerv07 is configured for ssh user equivalency for oracle user

Node nerv06 is configured for ssh user equivalency for oracle user

Searching for running databases . . . . .

. .
List of running databases registered in OCR
1. RAC01
2. None of above

Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1].
. .

Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
-------------------------------------------------------------------------------------------------------
                                                 Oracle Stack Status
-------------------------------------------------------------------------------------------------------
Host Name  CRS Installed  ASM HOME       RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name
-------------------------------------------------------------------------------------------------------
nerv01      Yes             Yes             Yes             Yes        Yes      Yes      RAC013
nerv03      Yes             Yes             Yes             Yes        Yes      Yes      RAC011
nerv04      Yes             Yes             Yes             Yes        Yes      Yes      RAC012
nerv05      Yes             Yes             Yes             Yes        Yes      Yes      RAC015
nerv02      Yes             Yes             Yes             Yes        Yes      Yes      rac014
nerv08      Yes             Yes             Yes             Yes        Yes      Yes      RAC018
nerv07      Yes             Yes             Yes             Yes        Yes      Yes      RAC017
nerv06      Yes             Yes             Yes             Yes        Yes      Yes      RAC016
-------------------------------------------------------------------------------------------------------

Copying plug-ins

. . . . . . . . . . . . . . . . . .

. . . . . .

12 of the included audit checks require root privileged data collection . If sudo is not configured or the root password is not available, audit checks which  require root privileged data collection can be skipped.

1. Enter 1 if you will enter root password for each  host when prompted

2. Enter 2 if you have sudo configured for oracle user to execute root_raccheck.sh script

3. Enter 3 to skip the root privileged collections

4. Enter 4 to exit and work with the SA to configure sudo  or to arrange for root access and run the tool later.

Please indicate your selection from one of the above options for root access[1-4][1]:-

*** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***

Collections and audit checks log file is
/home/oracle/raccheck_nerv01_RAC01_092513_055913/log/raccheck.log

Running raccheck in serial mode because expect(/usr/bin/expect) is not available to supply root passwords on remote nodes

NOTICE:  Installing the expect utility (/usr/bin/expect) will allow raccheck to gather root passwords at the beginning of the process and execute raccheck on all nodes in parallel speeding up the entire process. For more info - http://www.nist.gov/el/msid/expect.cfm.  Expect is available for all major platforms.  See User Guide for more details.

=============================================================
                    Node name - nerv01
=============================================================

Collecting - ASM DIsk I/O stats
Collecting - ASM Disk Groups
Collecting - ASM Diskgroup Attributes
Collecting - ASM disk partnership imbalance
Collecting - ASM diskgroup attributes
Collecting - ASM initialization parameters
Collecting - Active sessions load balance for RAC01 database
Collecting - Archived Destination Status for RAC01 database
Collecting - Cluster Interconnect Config for RAC01 database
Collecting - Database Archive Destinations for RAC01 database
Collecting - Database Files for RAC01 database
Collecting - Database Instance Settings for RAC01 database
Collecting - Database Parameters for RAC01 database
Collecting - Database Properties for RAC01 database
Collecting - Database Registry for RAC01 database
Collecting - Database Sequences for RAC01 database
Collecting - Database Undocumented Parameters for RAC01 database
Collecting - Database Workload Services for RAC01 database
Collecting - Dataguard Status for RAC01 database
Collecting - Files not opened by ASM
Collecting - Log Sequence Numbers for RAC01 database
Collecting - Percentage of asm disk  Imbalance
Collecting - Process for shipping Redo to standby for RAC01 database
Collecting - RDBMS Feature Usage for RAC01 database
Collecting - Redo Log information for RAC01 database
Collecting - Standby redo log creation status before switchover for RAC01 database
Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - CSS Reboot time
Collecting - CSS disktimout
Collecting - Cluster interconnect (clusterware)
Collecting - Clusterware OCR healthcheck
Collecting - Clusterware Resource Status
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - Network Service Switch
Collecting - OS Packages
Collecting - OS version
Collecting - Operating system release information and kernel version
Collecting - Oracle Executable Attributes
Collecting - Patches for Grid Infrastructure
Collecting - Patches for RDBMS Home
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - Voting disks (clusterware)
Collecting - number of semaphore operations per semop system call
Collecting - slabinfo
Preparing to run root privileged commands  nerv01.  Please enter root password when prompted.
root@nerv01's password:
Collecting - Broadcast Requirements for Networks
Collecting - CRS user time zone check
Collecting - Custom rc init scripts (rc.local)
Collecting - Disk Information
Collecting - Grid Infastructure user shell limits configuration
Collecting - Interconnect interface config
Collecting - Network interface stats
Collecting - OLR Integrity
Collecting - Verify no database server kernel out of memory errors
Collecting - root time zone check

Data collections completed. Checking best practices on nerv01.
--------------------------------------------------------------------------------------

 INFO =>    All redo log files are not same size. for RAC01
 WARNING => Database Parameter memory_target is not set to the recommended value on RAC013 instance
 FAIL =>    Operating system hugepages count does not satisfy total SGA requirements
 WARNING => NIC bonding is not configured for interconnect
 WARNING => NIC bonding is NOT configured for public network (VIP)
 WARNING => OSWatcher is not running as is recommended.
 INFO =>    Jumbo frames (MTU >= 8192) are not configured for interconnect
 WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for RAC01
 FAIL =>    Flashback on PRIMARY is not configured for RAC01
 INFO =>    Operational Best Practices
 INFO =>    Database Consolidation Best Practices
 INFO =>    Computer failure prevention best practices
 INFO =>    Data corruption prevention best practices
 INFO =>    Logical corruption prevention best practices
 INFO =>    Database/Cluster/Site failure prevention best practices
 INFO =>    Client failover operational best practices
 WARNING => fast_start_mttr_target should be greater than or equal to 300. on RAC013 instance
 INFO =>    Information about hanganalyze and systemstate dump
 FAIL =>    Package unixODBC-2.2.14-11.el6-i686 is recommended but NOT installed
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-i686 is recommended but NOT installed
 INFO =>    Database failure prevention best practices
 FAIL =>    Primary database is NOT protected with Data Guard (standby database) for real-time data protection and availability for RAC01
 WARNING => Redo log write time is more than 500 milliseconds for RAC01
 WARNING => TFA Collector is either not installed or not running
 INFO =>    Parallel Execution Health-Checks and Diagnostics Reports for RAC01
 WARNING => OCR and Voting disks are not stored in ASM
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-x86_64 is recommended but NOT installed
 FAIL =>    The data files should be recoverable for RAC01
 WARNING => vm.min_free_kbytes should be set as recommended.
 WARNING => kernel parameter rp_filter is set to 1.
 WARNING => Fast Recovery Area (FRA) should have sufficient reclaimable space for RAC01
 INFO =>    Oracle recovery manager(rman) best practices
 WARNING => RMAN controlfile autobackup should be set to ON for RAC01

Best Practice checking completed.Checking recommended patches on nerv01.
---------------------------------------------------------------------------------

Collecting patch inventory on  CRS HOME /u01/app/11.2.0/grid
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------
0 Recommended CRS patches for 112040 from /u01/app/11.2.0/grid on nerv01
---------------------------------------------------------------------------------
Patch#   CRS  ASM    RDBMS RDBMS_HOME                              Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
0 Recommended RDBMS patches for 112040 from /u01/app/oracle/product/11.2.0/db_1 on nerv01
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              Clusterware patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on CRS Applied on RDBMS Applied on ASM
---------------------------------------------------------------------------------
0              0              0                0
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              RDBMS homes patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
 0              0              0                /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------

=============================================================
                    Node name - nerv03
=============================================================

Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - Cluster interconnect (clusterware)
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - Network Service Switch
Collecting - OS Packages
Collecting - OS version
Collecting - Operating system release information and kernel version
Collecting - Oracle Executable Attributes
Collecting - Patches for Grid Infrastructure
Collecting - Patches for RDBMS Home
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call
Collecting - slabinfo
Preparing to run root privileged commands  nerv03.  Please enter root password when prompted.
root@nerv03's password:
Collecting - Broadcast Requirements for Networks
Collecting - CRS user time zone check
Collecting - Disk Information
Collecting - Grid Infastructure user shell limits configuration
Collecting - Interconnect interface config
Collecting - Network interface stats
Collecting - OLR Integrity
Collecting - Verify no database server kernel out of memory errors
Collecting - root time zone check

Data collections completed. Checking best practices on nerv03.
--------------------------------------------------------------------------------------

 WARNING => $ORACLE_HOME/bin/oradism setuid bit is NOT set for /u01/app/oracle/product/11.2.0/db_1
 WARNING => $ORACLE_HOME/bin/oradism ownership is NOT root for /u01/app/oracle/product/11.2.0/db_1
 WARNING => Database Parameter memory_target is not set to the recommended value on RAC011 instance
 FAIL =>    Operating system hugepages count does not satisfy total SGA requirements
 WARNING => NIC bonding is not configured for interconnect
 WARNING => NIC bonding is NOT configured for public network (VIP)
 WARNING => crsd Log Ownership is NOT Correct (should be root root)
 WARNING => crsd/orarootagent_root Log Ownership is NOT Correct (should be root root)
 WARNING => ohasd/orarootagent_root Log Ownership is NOT Correct (should be root root)
 WARNING => ohasd Log Ownership is NOT Correct (should be root root)
 WARNING => OSWatcher is not running as is recommended.
 INFO =>    Jumbo frames (MTU >= 8192) are not configured for interconnect
 WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for RAC01
 WARNING => fast_start_mttr_target should be greater than or equal to 300. on RAC011 instance
 FAIL =>    Package unixODBC-2.2.14-11.el6-i686 is recommended but NOT installed
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-i686 is recommended but NOT installed
 WARNING => Redo log write time is more than 500 milliseconds for RAC01
 WARNING => OCR and Voting disks are not stored in ASM
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-x86_64 is recommended but NOT installed
 WARNING => vm.min_free_kbytes should be set as recommended.
 WARNING => kernel parameter rp_filter is set to 1.

Best Practice checking completed.Checking recommended patches on nerv03.
---------------------------------------------------------------------------------

Collecting patch inventory on  CRS HOME /u01/app/11.2.0/grid
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------
0 Recommended CRS patches for 112040 from /u01/app/11.2.0/grid on nerv03
---------------------------------------------------------------------------------
Patch#   CRS  ASM    RDBMS RDBMS_HOME                              Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
0 Recommended RDBMS patches for 112040 from /u01/app/oracle/product/11.2.0/db_1 on nerv03
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              Clusterware patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on CRS Applied on RDBMS Applied on ASM
---------------------------------------------------------------------------------
0              0              0                0
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              RDBMS homes patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
 0              0              0                /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------

=============================================================
                    Node name - nerv04
=============================================================

Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - Cluster interconnect (clusterware)
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - Network Service Switch
Collecting - OS Packages
Collecting - OS version
Collecting - Operating system release information and kernel version
Collecting - Oracle Executable Attributes
Collecting - Patches for Grid Infrastructure
Collecting - Patches for RDBMS Home
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call
Collecting - slabinfo
Preparing to run root privileged commands  nerv04.  Please enter root password when prompted.
root@nerv04's password:

Data collections completed. Checking best practices on nerv04.
--------------------------------------------------------------------------------------

 WARNING => Database Parameter memory_target is not set to the recommended value on RAC012 instance
 FAIL =>    Operating system hugepages count does not satisfy total SGA requirements
 WARNING => NIC bonding is not configured for interconnect
 WARNING => NIC bonding is NOT configured for public network (VIP)
 WARNING => OSWatcher is not running as is recommended.
 INFO =>    Jumbo frames (MTU >= 8192) are not configured for interconnect
 WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for RAC01
 WARNING => fast_start_mttr_target should be greater than or equal to 300. on RAC012 instance
 FAIL =>    Package unixODBC-2.2.14-11.el6-i686 is recommended but NOT installed
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-i686 is recommended but NOT installed
 WARNING => Redo log write time is more than 500 milliseconds for RAC01
 WARNING => OCR and Voting disks are not stored in ASM
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-x86_64 is recommended but NOT installed
 WARNING => vm.min_free_kbytes should be set as recommended.
 WARNING => kernel parameter rp_filter is set to 1.

Best Practice checking completed.Checking recommended patches on nerv04.
---------------------------------------------------------------------------------

Collecting patch inventory on  CRS HOME /u01/app/11.2.0/grid
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------
0 Recommended CRS patches for 112040 from /u01/app/11.2.0/grid on nerv04
---------------------------------------------------------------------------------
Patch#   CRS  ASM    RDBMS RDBMS_HOME                              Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
0 Recommended RDBMS patches for 112040 from /u01/app/oracle/product/11.2.0/db_1 on nerv04
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              Clusterware patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on CRS Applied on RDBMS Applied on ASM
---------------------------------------------------------------------------------
0              0              0                0
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              RDBMS homes patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
 0              0              0                /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------

=============================================================
                    Node name - nerv05
=============================================================

Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - Cluster interconnect (clusterware)
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - Network Service Switch
Collecting - OS Packages
Collecting - OS version
Collecting - Operating system release information and kernel version
Collecting - Oracle Executable Attributes
Collecting - Patches for Grid Infrastructure
Collecting - Patches for RDBMS Home
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call
Collecting - slabinfo
Preparing to run root privileged commands  nerv05.  Please enter root password when prompted.
root@nerv05's password:

Data collections completed. Checking best practices on nerv05.
--------------------------------------------------------------------------------------

 WARNING => /tmp is NOT on a dedicated filesystem
 WARNING => Database Parameter memory_target is not set to the recommended value on RAC015 instance
 FAIL =>    Operating system hugepages count does not satisfy total SGA requirements
 WARNING => NIC bonding is not configured for interconnect
 WARNING => NIC bonding is NOT configured for public network (VIP)
 WARNING => ohasd/orarootagent_root Log Ownership is NOT Correct (should be root root)
 WARNING => ohasd Log Ownership is NOT Correct (should be root root)
 WARNING => OSWatcher is not running as is recommended.
 INFO =>    Jumbo frames (MTU >= 8192) are not configured for interconnect
 WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for RAC01
 WARNING => fast_start_mttr_target should be greater than or equal to 300. on RAC015 instance
 FAIL =>    Package unixODBC-2.2.14-11.el6-i686 is recommended but NOT installed
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-i686 is recommended but NOT installed
 WARNING => Redo log write time is more than 500 milliseconds for RAC01
 WARNING => OCR and Voting disks are not stored in ASM
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-x86_64 is recommended but NOT installed
 WARNING => vm.min_free_kbytes should be set as recommended.
 WARNING => kernel parameter rp_filter is set to 1.

Best Practice checking completed.Checking recommended patches on nerv05.
---------------------------------------------------------------------------------

Collecting patch inventory on  CRS HOME /u01/app/11.2.0/grid
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------
0 Recommended CRS patches for 112040 from /u01/app/11.2.0/grid on nerv05
---------------------------------------------------------------------------------
Patch#   CRS  ASM    RDBMS RDBMS_HOME                              Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
0 Recommended RDBMS patches for 112040 from /u01/app/oracle/product/11.2.0/db_1 on nerv05
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              Clusterware patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on CRS Applied on RDBMS Applied on ASM
---------------------------------------------------------------------------------
0              0              0                0
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              RDBMS homes patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
 0              0              0                /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------

=============================================================
                    Node name - nerv02
=============================================================

Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - Cluster interconnect (clusterware)
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - Network Service Switch
Collecting - OS Packages
Collecting - OS version
Collecting - Operating system release information and kernel version
Collecting - Oracle Executable Attributes
Collecting - Patches for Grid Infrastructure
Collecting - Patches for RDBMS Home
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call
Collecting - slabinfo
Preparing to run root privileged commands  nerv02.  Please enter root password when prompted.
root@nerv02's password:

Data collections completed. Checking best practices on nerv02.
--------------------------------------------------------------------------------------

 WARNING => Database Parameter memory_target is not set to the recommended value on rac014 instance
 FAIL =>    Operating system hugepages count does not satisfy total SGA requirements
 WARNING => NIC bonding is not configured for interconnect
 WARNING => NIC bonding is NOT configured for public network (VIP)
 WARNING => OSWatcher is not running as is recommended.
 INFO =>    Jumbo frames (MTU >= 8192) are not configured for interconnect
 WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for RAC01
 WARNING => fast_start_mttr_target should be greater than or equal to 300. on rac014 instance
 FAIL =>    Package unixODBC-2.2.14-11.el6-i686 is recommended but NOT installed
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-i686 is recommended but NOT installed
 WARNING => Redo log write time is more than 500 milliseconds for RAC01
 WARNING => OCR and Voting disks are not stored in ASM
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-x86_64 is recommended but NOT installed
 WARNING => vm.min_free_kbytes should be set as recommended.
 WARNING => kernel parameter rp_filter is set to 1.

Best Practice checking completed.Checking recommended patches on nerv02.
---------------------------------------------------------------------------------

Collecting patch inventory on  CRS HOME /u01/app/11.2.0/grid
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------
0 Recommended CRS patches for 112040 from /u01/app/11.2.0/grid on nerv02
---------------------------------------------------------------------------------
Patch#   CRS  ASM    RDBMS RDBMS_HOME                              Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
0 Recommended RDBMS patches for 112040 from /u01/app/oracle/product/11.2.0/db_1 on nerv02
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              Clusterware patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on CRS Applied on RDBMS Applied on ASM
---------------------------------------------------------------------------------
0              0              0                0
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              RDBMS homes patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
 0              0              0                /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------

=============================================================
                    Node name - nerv08
=============================================================

Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - Cluster interconnect (clusterware)
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - Network Service Switch
Collecting - OS Packages
Collecting - OS version
Collecting - Operating system release information and kernel version
Collecting - Oracle Executable Attributes
Collecting - Patches for Grid Infrastructure
Collecting - Patches for RDBMS Home
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call
Collecting - slabinfo
Preparing to run root privileged commands  nerv08.  Please enter root password when prompted.
root@nerv08's password:
Collecting - Broadcast Requirements for Networks
Collecting - CRS user time zone check
Collecting - Disk Information
Collecting - Grid Infastructure user shell limits configuration
Collecting - Interconnect interface config
Collecting - Network interface stats
Collecting - OLR Integrity
Collecting - Verify no database server kernel out of memory errors
Collecting - root time zone check

Data collections completed. Checking best practices on nerv08.
--------------------------------------------------------------------------------------

 WARNING => Database Parameter memory_target is not set to the recommended value on RAC018 instance
 FAIL =>    Operating system hugepages count does not satisfy total SGA requirements
 WARNING => NIC bonding is not configured for interconnect
 WARNING => NIC bonding is NOT configured for public network (VIP)
 WARNING => OSWatcher is not running as is recommended.
 INFO =>    Jumbo frames (MTU >= 8192) are not configured for interconnect
 WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for RAC01
 WARNING => fast_start_mttr_target should be greater than or equal to 300. on RAC018 instance
 FAIL =>    Package unixODBC-2.2.14-11.el6-i686 is recommended but NOT installed
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-i686 is recommended but NOT installed
 WARNING => Redo log write time is more than 500 milliseconds for RAC01
 WARNING => TFA Collector is either not installed or not running
 WARNING => OCR and Voting disks are not stored in ASM
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-x86_64 is recommended but NOT installed
 WARNING => vm.min_free_kbytes should be set as recommended.
 WARNING => kernel parameter rp_filter is set to 1.

Best Practice checking completed.Checking recommended patches on nerv08.
---------------------------------------------------------------------------------

Collecting patch inventory on  CRS HOME /u01/app/11.2.0/grid
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------
0 Recommended CRS patches for 112040 from /u01/app/11.2.0/grid on nerv08
---------------------------------------------------------------------------------
Patch#   CRS  ASM    RDBMS RDBMS_HOME                              Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
0 Recommended RDBMS patches for 112040 from /u01/app/oracle/product/11.2.0/db_1 on nerv08
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              Clusterware patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on CRS Applied on RDBMS Applied on ASM
---------------------------------------------------------------------------------
0              0              0                0
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              RDBMS homes patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
 0              0              0                /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------

=============================================================
                    Node name - nerv07
=============================================================

Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - Cluster interconnect (clusterware)
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - Network Service Switch
Collecting - OS Packages
Collecting - OS version
Collecting - Operating system release information and kernel version
Collecting - Oracle Executable Attributes
Collecting - Patches for Grid Infrastructure
Collecting - Patches for RDBMS Home
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call
Collecting - slabinfo
Preparing to run root privileged commands  nerv07.  Please enter root password when prompted.
root@nerv07's password:
Collecting - Broadcast Requirements for Networks
Collecting - CRS user time zone check
Collecting - Disk Information
Collecting - Grid Infastructure user shell limits configuration
Collecting - Interconnect interface config
Collecting - Network interface stats
Collecting - OLR Integrity
Collecting - Verify no database server kernel out of memory errors
Collecting - root time zone check

Data collections completed. Checking best practices on nerv07.
--------------------------------------------------------------------------------------

 WARNING => Database Parameter memory_target is not set to the recommended value on RAC017 instance
 FAIL =>    Operating system hugepages count does not satisfy total SGA requirements
 WARNING => NIC bonding is not configured for interconnect
 WARNING => NIC bonding is NOT configured for public network (VIP)
 WARNING => OSWatcher is not running as is recommended.
 INFO =>    Jumbo frames (MTU >= 8192) are not configured for interconnect
 WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for RAC01
 WARNING => fast_start_mttr_target should be greater than or equal to 300. on RAC017 instance
 FAIL =>    Package unixODBC-2.2.14-11.el6-i686 is recommended but NOT installed
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-i686 is recommended but NOT installed
 WARNING => Redo log write time is more than 500 milliseconds for RAC01
 WARNING => OCR and Voting disks are not stored in ASM
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-x86_64 is recommended but NOT installed
 WARNING => vm.min_free_kbytes should be set as recommended.
 WARNING => kernel parameter rp_filter is set to 1.

Best Practice checking completed.Checking recommended patches on nerv07.
---------------------------------------------------------------------------------

Collecting patch inventory on  CRS HOME /u01/app/11.2.0/grid
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------
0 Recommended CRS patches for 112040 from /u01/app/11.2.0/grid on nerv07
---------------------------------------------------------------------------------
Patch#   CRS  ASM    RDBMS RDBMS_HOME                              Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
0 Recommended RDBMS patches for 112040 from /u01/app/oracle/product/11.2.0/db_1 on nerv07
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              Clusterware patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on CRS Applied on RDBMS Applied on ASM
---------------------------------------------------------------------------------
0              0              0                0
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              RDBMS homes patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
 0              0              0                /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------

=============================================================
                    Node name - nerv06
=============================================================

Collecting - /proc/cmdline
Collecting - /proc/modules
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - Cluster interconnect (clusterware)
Collecting - DiskFree Information
Collecting - DiskMount Information
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - NUMA Configuration
Collecting - Network Interface Configuration
Collecting - Network Performance
Collecting - Network Service Switch
Collecting - OS Packages
Collecting - OS version
Collecting - Operating system release information and kernel version
Collecting - Oracle Executable Attributes
Collecting - Patches for Grid Infrastructure
Collecting - Patches for RDBMS Home
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call
Collecting - slabinfo
Preparing to run root privileged commands  nerv06.  Please enter root password when prompted.
root@nerv06's password:
Collecting - Broadcast Requirements for Networks
Collecting - CRS user time zone check
Collecting - Disk Information
Collecting - Grid Infastructure user shell limits configuration
Collecting - Interconnect interface config
Collecting - Network interface stats
Collecting - OLR Integrity
Collecting - Verify no database server kernel out of memory errors
Collecting - root time zone check

Data collections completed. Checking best practices on nerv06.
--------------------------------------------------------------------------------------

 WARNING => /tmp is NOT on a dedicated filesystem
 WARNING => Database Parameter memory_target is not set to the recommended value on RAC016 instance
 FAIL =>    Operating system hugepages count does not satisfy total SGA requirements
 WARNING => NIC bonding is not configured for interconnect
 WARNING => NIC bonding is NOT configured for public network (VIP)
 WARNING => OSWatcher is not running as is recommended.
 INFO =>    Jumbo frames (MTU >= 8192) are not configured for interconnect
 WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for RAC01
 WARNING => fast_start_mttr_target should be greater than or equal to 300. on RAC016 instance
 FAIL =>    Package unixODBC-2.2.14-11.el6-i686 is recommended but NOT installed
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-i686 is recommended but NOT installed
 WARNING => Redo log write time is more than 500 milliseconds for RAC01
 WARNING => OCR and Voting disks are not stored in ASM
 FAIL =>    Package unixODBC-devel-2.2.14-11.el6-x86_64 is recommended but NOT installed
 WARNING => vm.min_free_kbytes should be set as recommended.
 WARNING => kernel parameter rp_filter is set to 1.

Best Practice checking completed.Checking recommended patches on nerv06.
---------------------------------------------------------------------------------

Collecting patch inventory on  CRS HOME /u01/app/11.2.0/grid
Collecting patch inventory on ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------
0 Recommended CRS patches for 112040 from /u01/app/11.2.0/grid on nerv06
---------------------------------------------------------------------------------
Patch#   CRS  ASM    RDBMS RDBMS_HOME                              Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
0 Recommended RDBMS patches for 112040 from /u01/app/oracle/product/11.2.0/db_1 on nerv06
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              Clusterware patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on CRS Applied on RDBMS Applied on ASM
---------------------------------------------------------------------------------
0              0              0                0
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              RDBMS homes patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
 0              0              0                /u01/app/oracle/product/11.2.0/db_1
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
                      CLUSTERWIDE CHECKS
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

Detailed report (html) - /home/oracle/raccheck_nerv01_RAC01_092513_055913/raccheck_nerv01_RAC01_092513_055913.html
which: no perl in (/u01/app/oracle/product/11.2.0/db_1/bin:/u01/app/11.2.0/grid/bin:/usr/sbin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:.:/u01/app/oracle/product/11.2.0/db_1/bin)

UPLOAD(if required) - /home/oracle/raccheck_nerv01_RAC01_092513_055913.zip

[oracle@nerv01 ~]$

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.