Introduction:
RACcheck is a tool developed by Oracle to audit your RAC and clusterware configurations.
It gives suggestions and advices to modify your RAC Configuration to fit the Oracle best practices.
This tool checks the settings of the following configurations;
– OS kernel parameters, OS packages and OS settings
– CRS/Grid Infrastructure
– RDBMS ; memory and database parameters
– ASM parameters and statistics.
Test:
I have tested the tool on my RAC 11.2.0.1 , 2 nodes on Oracle Enterprise Linux. It is a RAC system installed on VirtualBox so it is not optimal. It is just my test system.
This tool can also be run from RAC 10.2.0.1.
First of all download the tool from MOS ID: 1268927.1
Unzip the file and give it the following rights;
[oracle@orac1 raccheck]$ ls RACcheck.zip [oracle@orac1 raccheck]$ unzip RACcheck.zip Archive: RACcheck.zip inflating: raccheck inflating: readme.txt inflating: UserGuide.txt inflating: collections.dat inflating: rules.dat creating: .cgrep/ inflating: .cgrep/lcgrep5 inflating: .cgrep/lcgrep4 inflating: .cgrep/lcgrep6 inflating: .cgrep/lcgreps9 inflating: .cgrep/lcgreps10 inflating: .cgrep/acgrep inflating: .cgrep/scgrep inflating: .cgrep/scgrepx86 [oracle@orac1 raccheck]$ [oracle@orac1 raccheck]$ chmod 755 raccheck [oracle@orac1 raccheck]$
Run the tool;
[oracle@orac1 raccheck]$ ./raccheck -a
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]y
Node orac2 is configured for ssh user equivalency for oracle user
Searching for running databases . . . . .
. . .
raccheck found database RAC registered in OCR. Is this the database to check best practices for?[y/n][y]y
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
-------------------------------------------------------------------------------------------------------
orac1 Yes Yes Yes Yes Yes Yes RAC1
orac2 Yes Yes Yes Yes Yes Yes RAC2
-------------------------------------------------------------------------------------------------------
140 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[1-4][1]:- 1
*** Checking RAC Best Practice Recommendations (PASS/WARNING/FAIL) ***
Performing SQL collections for use with audit checks on RAC...please stand by.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Log file for collections and audit checks are at
/home/oracle/raccheck/raccheck_080311_124252/raccheck.log
=============================================================
Node name - orac1
=============================================================
Collecting - ASM DIsk I/O stats
Collecting - ASM Disk Groups
Collecting - ASM disk partnership imbalance
Collecting - ASM diskgroup attributes
Collecting - ASM initialization parameters
Collecting - Active sessions load balance for RAC database
Collecting - Archived Destination Status for RAC database
Collecting - CONNECT Role Grantees for RAC database
Collecting - Cluster Interconnect Config for RAC database
Collecting - Data Files In Backup Mode for RAC database
Collecting - Database Archive Destinations for RAC database
Collecting - Database Component Status for RAC database
Collecting - Database Files for RAC database
Collecting - Database Instance Settings for RAC database
Collecting - Database Parameters for RAC database
Collecting - Database Properties for RAC database
Collecting - Database Registry for RAC database
Collecting - Database Sequences for RAC database
Collecting - Database Undocumented Parameters for RAC database
Collecting - Database Workload Services for RAC database
Collecting - Dataguard Status for RAC database
Collecting - Files Needing Media Recovery for RAC database
Collecting - Files not opened by ASM
Collecting - INVALID SYS and SYSTEM objects for RAC database
Collecting - INVALID application objects for RAC database
Collecting - Invalid Java Objects for RAC database
Collecting - Invalid Registry Components for RAC database
Collecting - JVM Roles for RAC database
Collecting - Log Sequence Numbers for RAC database
Collecting - Objects Duplicated in SYS and SYSTEM Schema for RAC database
Collecting - Percentage of asm disk Imbalance
Collecting - Process for shipping Redo to standby for RAC database
Collecting - Redo Log information for RAC database
Collecting - Standby redo log creation status before switchover for RAC database
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - CSS Reboot time
Collecting - CSS diagwait
Collecting - CSS disktimout
Collecting - CSS miscount
Collecting - Cluster interconnect (clusterware)
Collecting - Clusterware OCR healthcheck
Collecting - Clusterware Resource Status
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Linux module config.
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 - OS Packages
Collecting - Oracle Executable Attributes
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - Voting disks (clusterware)
Collecting - number of semaphore operations per semop system call
Preparing to run root privileged commands orac1. Please enter root password when prompted.
root@orac1's password:
Collecting - CRS user limits configuration
Collecting - CRS user time zone check
Collecting - Custom rc init scripts (rc.local)
Collecting - Interconnect interface config
Collecting - Network interface stats
Collecting - OCFS2 disks
/tmp/root_raccheck.sh: line 30: /sbin/mounted.ocfs2: No such file or directory
Collecting - Root Open File Limit
Collecting - ocsf status
/tmp/root_raccheck.sh: line 39: /etc/init.d/o2cb: No such file or directory
Collecting - root time zone check
Data collections completed. Checking best practices on orac1.
--------------------------------------------------------------------------------------
INFO => $CRS_HOME/log/hostname/client directory has too many older log files.
INFO => user_dump_dest has trace files older than 30 days for RAC
INFO => ORA-00600 errors found in alert log for RAC
INFO => background_dump_dest has files older than 30 days for RAC
WARNING => fast_start_mttr_target has NOT been changed from default on RAC1 instance
INFO => audit_file_dest has audit files older than 30 days for RAC
WARNING => Controlfile is NOT multiplexed for RAC
WARNING => One or more redo log groups are NOT multiplexed for RAC
INFO => oracleasm (asmlib) module is NOT loaded
WARNING => kernel.shmmax parameter is NOT configured according to recommendation
WARNING => Open file limit for root user (ulimit -n) is NOT >= 65536 or unlimited
INFO => Number of SCAN listeners is NOT equal to the recommended number of 3.
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 9000) are not configured for interconnect
WARNING => kernel parameter rp_filter is set to 1.
Best Practice checking completed.Checking recommended patches on orac1.
---------------------------------------------------------------------------------
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/dbhome_1
---------------------------------------------------------------------------------
1 Recommended CRS patches for 112010 from /u01/app/11.2.0/grid on orac1
---------------------------------------------------------------------------------
Patch# CRS ASM RDBMS RDBMS_HOME Patch-Description
---------------------------------------------------------------------------------
9655006 no no /u01/app/oracle/product/11.2.0/dbhome_1GI PSU 11.2.0.1.2 (INCLUDES DATABASE PS
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 112010 from /u01/app/oracle/product/11.2.0/dbhome_1 on orac1
---------------------------------------------------------------------------------
Patch# RDBMS ASM type Patch-Description
---------------------------------------------------------------------------------
11724930 no merge DATABASE PSU 11.2.0.1.5 (INCLUDES CPUAPR
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
Clusterware patches summmary report
---------------------------------------------------------------------------------
Total patches Applied on CRS Applied on RDBMS Applied on ASM
---------------------------------------------------------------------------------
1 0 0 0
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
RDBMS homes patches summmary report
---------------------------------------------------------------------------------
Total patches Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
1 0 0 /u01/app/oracle/product/11.2.0/dbhome_1
---------------------------------------------------------------------------------
=============================================================
Node name - orac2
=============================================================
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - Cluster interconnect (clusterware)
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Linux module config.
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 - OS Packages
Collecting - Oracle Executable Attributes
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call
Preparing to run root privileged commands orac2. Please enter root password when prompted.
root@orac2's password:
Data collections completed. Checking best practices on orac2.
--------------------------------------------------------------------------------------
INFO => $CRS_HOME/log/hostname/client directory has too many older log files.
INFO => user_dump_dest has trace files older than 30 days for RAC
INFO => background_dump_dest has files older than 30 days for RAC
WARNING => Open files limit (ulimit -n) for current user is NOT set to recommended value >= 65536 or unlimited
From the output above, you can see the tool suggested to modify many parameters including kernel values, purge log files, network configuration, recommended patches and security options.
More details about the tool can be found on MOS ID: 1268927.1
Introduction:
RACcheck est un outil développé par Oracle pour vérifier les configurations du cluster et du RAC.
L’outil offre des conseils pour modifier votre configuration RAC afin de répondre aux paramètres optimaux conseillés par Oracle.
L’outil vérifie les configurations suivantes:
– Les paramètre du kernel, les paquets du système opératif.
– CRS/ l’ Infrastructure Grid.
– SGBD ; mémoire et paramètres de bases de données.
– Les paramètres ASM et statistiques..
Teste:
J’ai mi testé l’outil dans mon environnement de teste RAC 11.2.0.1, un RAC à 2 nodes sous Oracle Enterprise Linux. Ce système est installé sous des machines virtuelles. Ce n’est pas un système optimal mais il donnera une idée ce qui est l’outil.
Cet outil peut être utilisé aussi pour des BD à partir de 10.2.0.1
Tout d’abord, téléchargez l’outil de MOS ID: 1268927.1
Décompressez le fichier et changez les permissions;
[oracle@orac1 raccheck]$ ls RACcheck.zip [oracle@orac1 raccheck]$ unzip RACcheck.zip Archive: RACcheck.zip inflating: raccheck inflating: readme.txt inflating: UserGuide.txt inflating: collections.dat inflating: rules.dat creating: .cgrep/ inflating: .cgrep/lcgrep5 inflating: .cgrep/lcgrep4 inflating: .cgrep/lcgrep6 inflating: .cgrep/lcgreps9 inflating: .cgrep/lcgreps10 inflating: .cgrep/acgrep inflating: .cgrep/scgrep inflating: .cgrep/scgrepx86 [oracle@orac1 raccheck]$ [oracle@orac1 raccheck]$ chmod 755 raccheck [oracle@orac1 raccheck]$
Excécutez l’outil;
[oracle@orac1 raccheck]$ ./raccheck -a
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]y
Node orac2 is configured for ssh user equivalency for oracle user
Searching for running databases . . . . .
. . .
raccheck found database RAC registered in OCR. Is this the database to check best practices for?[y/n][y]y
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
-------------------------------------------------------------------------------------------------------
orac1 Yes Yes Yes Yes Yes Yes RAC1
orac2 Yes Yes Yes Yes Yes Yes RAC2
-------------------------------------------------------------------------------------------------------
140 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[1-4][1]:- 1
*** Checking RAC Best Practice Recommendations (PASS/WARNING/FAIL) ***
Performing SQL collections for use with audit checks on RAC...please stand by.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Log file for collections and audit checks are at
/home/oracle/raccheck/raccheck_080311_124252/raccheck.log
=============================================================
Node name - orac1
=============================================================
Collecting - ASM DIsk I/O stats
Collecting - ASM Disk Groups
Collecting - ASM disk partnership imbalance
Collecting - ASM diskgroup attributes
Collecting - ASM initialization parameters
Collecting - Active sessions load balance for RAC database
Collecting - Archived Destination Status for RAC database
Collecting - CONNECT Role Grantees for RAC database
Collecting - Cluster Interconnect Config for RAC database
Collecting - Data Files In Backup Mode for RAC database
Collecting - Database Archive Destinations for RAC database
Collecting - Database Component Status for RAC database
Collecting - Database Files for RAC database
Collecting - Database Instance Settings for RAC database
Collecting - Database Parameters for RAC database
Collecting - Database Properties for RAC database
Collecting - Database Registry for RAC database
Collecting - Database Sequences for RAC database
Collecting - Database Undocumented Parameters for RAC database
Collecting - Database Workload Services for RAC database
Collecting - Dataguard Status for RAC database
Collecting - Files Needing Media Recovery for RAC database
Collecting - Files not opened by ASM
Collecting - INVALID SYS and SYSTEM objects for RAC database
Collecting - INVALID application objects for RAC database
Collecting - Invalid Java Objects for RAC database
Collecting - Invalid Registry Components for RAC database
Collecting - JVM Roles for RAC database
Collecting - Log Sequence Numbers for RAC database
Collecting - Objects Duplicated in SYS and SYSTEM Schema for RAC database
Collecting - Percentage of asm disk Imbalance
Collecting - Process for shipping Redo to standby for RAC database
Collecting - Redo Log information for RAC database
Collecting - Standby redo log creation status before switchover for RAC database
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - CSS Reboot time
Collecting - CSS diagwait
Collecting - CSS disktimout
Collecting - CSS miscount
Collecting - Cluster interconnect (clusterware)
Collecting - Clusterware OCR healthcheck
Collecting - Clusterware Resource Status
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Linux module config.
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 - OS Packages
Collecting - Oracle Executable Attributes
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - Voting disks (clusterware)
Collecting - number of semaphore operations per semop system call
Preparing to run root privileged commands orac1. Please enter root password when prompted.
root@orac1's password:
Collecting - CRS user limits configuration
Collecting - CRS user time zone check
Collecting - Custom rc init scripts (rc.local)
Collecting - Interconnect interface config
Collecting - Network interface stats
Collecting - OCFS2 disks
/tmp/root_raccheck.sh: line 30: /sbin/mounted.ocfs2: No such file or directory
Collecting - Root Open File Limit
Collecting - ocsf status
/tmp/root_raccheck.sh: line 39: /etc/init.d/o2cb: No such file or directory
Collecting - root time zone check
Data collections completed. Checking best practices on orac1.
--------------------------------------------------------------------------------------
INFO => $CRS_HOME/log/hostname/client directory has too many older log files.
INFO => user_dump_dest has trace files older than 30 days for RAC
INFO => ORA-00600 errors found in alert log for RAC
INFO => background_dump_dest has files older than 30 days for RAC
WARNING => fast_start_mttr_target has NOT been changed from default on RAC1 instance
INFO => audit_file_dest has audit files older than 30 days for RAC
WARNING => Controlfile is NOT multiplexed for RAC
WARNING => One or more redo log groups are NOT multiplexed for RAC
INFO => oracleasm (asmlib) module is NOT loaded
WARNING => kernel.shmmax parameter is NOT configured according to recommendation
WARNING => Open file limit for root user (ulimit -n) is NOT >= 65536 or unlimited
INFO => Number of SCAN listeners is NOT equal to the recommended number of 3.
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 9000) are not configured for interconnect
WARNING => kernel parameter rp_filter is set to 1.
Best Practice checking completed.Checking recommended patches on orac1.
---------------------------------------------------------------------------------
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/dbhome_1
---------------------------------------------------------------------------------
1 Recommended CRS patches for 112010 from /u01/app/11.2.0/grid on orac1
---------------------------------------------------------------------------------
Patch# CRS ASM RDBMS RDBMS_HOME Patch-Description
---------------------------------------------------------------------------------
9655006 no no /u01/app/oracle/product/11.2.0/dbhome_1GI PSU 11.2.0.1.2 (INCLUDES DATABASE PS
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 112010 from /u01/app/oracle/product/11.2.0/dbhome_1 on orac1
---------------------------------------------------------------------------------
Patch# RDBMS ASM type Patch-Description
---------------------------------------------------------------------------------
11724930 no merge DATABASE PSU 11.2.0.1.5 (INCLUDES CPUAPR
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
Clusterware patches summmary report
---------------------------------------------------------------------------------
Total patches Applied on CRS Applied on RDBMS Applied on ASM
---------------------------------------------------------------------------------
1 0 0 0
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
RDBMS homes patches summmary report
---------------------------------------------------------------------------------
Total patches Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
1 0 0 /u01/app/oracle/product/11.2.0/dbhome_1
---------------------------------------------------------------------------------
=============================================================
Node name - orac2
=============================================================
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - Cluster interconnect (clusterware)
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Linux module config.
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 - OS Packages
Collecting - Oracle Executable Attributes
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call
Preparing to run root privileged commands orac2. Please enter root password when prompted.
root@orac2's password:
Data collections completed. Checking best practices on orac2.
--------------------------------------------------------------------------------------
INFO => $CRS_HOME/log/hostname/client directory has too many older log files.
INFO => user_dump_dest has trace files older than 30 days for RAC
INFO => background_dump_dest has files older than 30 days for RAC
WARNING => Open files limit (ulimit -n) for current user is NOT set to recommended value >= 65536 or unlimited
Comme vous pouvez voir ci-dessus, l’outil propose de modifier de nombreux paramètres dont les valeurs du kernel, purger les fichiers journaux, Configurer le réseau, appliquer des patchs recommandés et ajuster quelques options de sécurité.
Pour plus de détails, merci de lire le document MOS ID: 1268927.1
Introducción:
RACcheck es una herramienta desarrollada por Oracle para verificar sus configuraciones RAC y Clusterware.
La herramienta propone sugerencias y consejos para modificar su configuración RAC con el fin de seguir las recomendaciones Oracle.
La herramienta verifica las siguientes configuraciones;
– Parámetros del kernel, Los paquetes de sistemas…
– CRS/ La infraestructura Grid
– SGBD ; memorias y parámetros de bases de datos.
– parámetros ASM y sus estadísticas.
Test:
He comprobado la herramienta en mi RAC 11.2.0.1, 2 nodos en Oracle Enterprise Linux. Se trata de un sistema de RAC instalado en VirtualBox, así que no es del todo óptimo. Es sólo mi sistema de prueba.
Esta herramienta también se puede ejecutar desde las versiones de RAC 10.2.0.1.
En primer lugar descargar la herramienta desde My Oracle Support (MOS);
: 1268927.1
Descomprimir el archivo y darle los siguientes derechos;
[oracle@orac1 raccheck]$ ls RACcheck.zip [oracle@orac1 raccheck]$ unzip RACcheck.zip Archive: RACcheck.zip inflating: raccheck inflating: readme.txt inflating: UserGuide.txt inflating: collections.dat inflating: rules.dat creating: .cgrep/ inflating: .cgrep/lcgrep5 inflating: .cgrep/lcgrep4 inflating: .cgrep/lcgrep6 inflating: .cgrep/lcgreps9 inflating: .cgrep/lcgreps10 inflating: .cgrep/acgrep inflating: .cgrep/scgrep inflating: .cgrep/scgrepx86 [oracle@orac1 raccheck]$ [oracle@orac1 raccheck]$ chmod 755 raccheck [oracle@orac1 raccheck]$
Ejecutar la herramienta;
[oracle@orac1 raccheck]$ ./raccheck -a
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]y
Node orac2 is configured for ssh user equivalency for oracle user
Searching for running databases . . . . .
. . .
raccheck found database RAC registered in OCR. Is this the database to check best practices for?[y/n][y]y
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
-------------------------------------------------------------------------------------------------------
orac1 Yes Yes Yes Yes Yes Yes RAC1
orac2 Yes Yes Yes Yes Yes Yes RAC2
-------------------------------------------------------------------------------------------------------
140 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[1-4][1]:- 1
*** Checking RAC Best Practice Recommendations (PASS/WARNING/FAIL) ***
Performing SQL collections for use with audit checks on RAC...please stand by.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Log file for collections and audit checks are at
/home/oracle/raccheck/raccheck_080311_124252/raccheck.log
=============================================================
Node name - orac1
=============================================================
Collecting - ASM DIsk I/O stats
Collecting - ASM Disk Groups
Collecting - ASM disk partnership imbalance
Collecting - ASM diskgroup attributes
Collecting - ASM initialization parameters
Collecting - Active sessions load balance for RAC database
Collecting - Archived Destination Status for RAC database
Collecting - CONNECT Role Grantees for RAC database
Collecting - Cluster Interconnect Config for RAC database
Collecting - Data Files In Backup Mode for RAC database
Collecting - Database Archive Destinations for RAC database
Collecting - Database Component Status for RAC database
Collecting - Database Files for RAC database
Collecting - Database Instance Settings for RAC database
Collecting - Database Parameters for RAC database
Collecting - Database Properties for RAC database
Collecting - Database Registry for RAC database
Collecting - Database Sequences for RAC database
Collecting - Database Undocumented Parameters for RAC database
Collecting - Database Workload Services for RAC database
Collecting - Dataguard Status for RAC database
Collecting - Files Needing Media Recovery for RAC database
Collecting - Files not opened by ASM
Collecting - INVALID SYS and SYSTEM objects for RAC database
Collecting - INVALID application objects for RAC database
Collecting - Invalid Java Objects for RAC database
Collecting - Invalid Registry Components for RAC database
Collecting - JVM Roles for RAC database
Collecting - Log Sequence Numbers for RAC database
Collecting - Objects Duplicated in SYS and SYSTEM Schema for RAC database
Collecting - Percentage of asm disk Imbalance
Collecting - Process for shipping Redo to standby for RAC database
Collecting - Redo Log information for RAC database
Collecting - Standby redo log creation status before switchover for RAC database
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - CSS Reboot time
Collecting - CSS diagwait
Collecting - CSS disktimout
Collecting - CSS miscount
Collecting - Cluster interconnect (clusterware)
Collecting - Clusterware OCR healthcheck
Collecting - Clusterware Resource Status
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Linux module config.
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 - OS Packages
Collecting - Oracle Executable Attributes
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - Voting disks (clusterware)
Collecting - number of semaphore operations per semop system call
Preparing to run root privileged commands orac1. Please enter root password when prompted.
root@orac1's password:
Collecting - CRS user limits configuration
Collecting - CRS user time zone check
Collecting - Custom rc init scripts (rc.local)
Collecting - Interconnect interface config
Collecting - Network interface stats
Collecting - OCFS2 disks
/tmp/root_raccheck.sh: line 30: /sbin/mounted.ocfs2: No such file or directory
Collecting - Root Open File Limit
Collecting - ocsf status
/tmp/root_raccheck.sh: line 39: /etc/init.d/o2cb: No such file or directory
Collecting - root time zone check
Data collections completed. Checking best practices on orac1.
--------------------------------------------------------------------------------------
INFO => $CRS_HOME/log/hostname/client directory has too many older log files.
INFO => user_dump_dest has trace files older than 30 days for RAC
INFO => ORA-00600 errors found in alert log for RAC
INFO => background_dump_dest has files older than 30 days for RAC
WARNING => fast_start_mttr_target has NOT been changed from default on RAC1 instance
INFO => audit_file_dest has audit files older than 30 days for RAC
WARNING => Controlfile is NOT multiplexed for RAC
WARNING => One or more redo log groups are NOT multiplexed for RAC
INFO => oracleasm (asmlib) module is NOT loaded
WARNING => kernel.shmmax parameter is NOT configured according to recommendation
WARNING => Open file limit for root user (ulimit -n) is NOT >= 65536 or unlimited
INFO => Number of SCAN listeners is NOT equal to the recommended number of 3.
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 9000) are not configured for interconnect
WARNING => kernel parameter rp_filter is set to 1.
Best Practice checking completed.Checking recommended patches on orac1.
---------------------------------------------------------------------------------
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/dbhome_1
---------------------------------------------------------------------------------
1 Recommended CRS patches for 112010 from /u01/app/11.2.0/grid on orac1
---------------------------------------------------------------------------------
Patch# CRS ASM RDBMS RDBMS_HOME Patch-Description
---------------------------------------------------------------------------------
9655006 no no /u01/app/oracle/product/11.2.0/dbhome_1GI PSU 11.2.0.1.2 (INCLUDES DATABASE PS
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 112010 from /u01/app/oracle/product/11.2.0/dbhome_1 on orac1
---------------------------------------------------------------------------------
Patch# RDBMS ASM type Patch-Description
---------------------------------------------------------------------------------
11724930 no merge DATABASE PSU 11.2.0.1.5 (INCLUDES CPUAPR
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
Clusterware patches summmary report
---------------------------------------------------------------------------------
Total patches Applied on CRS Applied on RDBMS Applied on ASM
---------------------------------------------------------------------------------
1 0 0 0
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
RDBMS homes patches summmary report
---------------------------------------------------------------------------------
Total patches Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
1 0 0 /u01/app/oracle/product/11.2.0/dbhome_1
---------------------------------------------------------------------------------
=============================================================
Node name - orac2
=============================================================
Collecting - CPU Information
Collecting - CRS active version
Collecting - CRS oifcfg
Collecting - CRS software version
Collecting - Cluster interconnect (clusterware)
Collecting - Huge pages configuration
Collecting - Kernel parameters
Collecting - Linux module config.
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 - OS Packages
Collecting - Oracle Executable Attributes
Collecting - Shared memory segments
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call
Preparing to run root privileged commands orac2. Please enter root password when prompted.
root@orac2's password:
Data collections completed. Checking best practices on orac2.
--------------------------------------------------------------------------------------
INFO => $CRS_HOME/log/hostname/client directory has too many older log files.
INFO => user_dump_dest has trace files older than 30 days for RAC
INFO => background_dump_dest has files older than 30 days for RAC
WARNING => Open files limit (ulimit -n) for current user is NOT set to recommended value >= 65536 or unlimited
A partir del log anterior, se puede ver que la herramienta sugiere modificar algunos parámetros, como por ejemplo; los valores del kernel, suprimir los antiguos archivos , configuración del red, los parches recomendados y algunos opciones de seguridad.
Más detalles acerca de la herramienta se puede encontrar en MOS ID: 1268927.1
Blog's RSS Feed
Loading ...
Just the scripts I posted above
Nice one we try to use in our Test environments
————
To view the new comment, visit:
http://www.oraclecommunity.net/profiles/blogs/testing-rac-check-audit-tool?commentId=1988559%3AComment%3A101891&xg_source=msg_com_blogpost
thanks.
Hi,
Can we use this RACcheck tool on oracle SE version ?
Thanks