orachk: verifique a saúde de seu Banco de Dados Oracle

O orachk (MOS Doc ID 1268927.2) substitui o RACcheck, e agora é aplicável também a ambiente Single Instance.

Ele é excelente para uma avaliação rápida (e simples) da adesão de um ambiente às melhores práticas recomendadas pelo fabricante. Inclusive, é emitida uma nota de 0 a 100 do ambiente, o que um bom indicador para o trabalho de um consultor focado em melhorias no ambiente analisado.

E para utiliza-lo, é muito simples, é só baixar do MOS, descompactar, e executar.

[ricardo@Melquior Downloads]$ unzip -q orachk.zip
[ricardo@Melquior Downloads]$ ./orachk

List of running databases
1. ORCL
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
-------------------------------------------------------------------------------------------------------
melquior    No              No              Yes             No         No       Yes      ORCL
-------------------------------------------------------------------------------------------------------


Copying plug-ins

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

. . . . . .


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



Collections and audit checks log file is
/home/ricardo/Downloads/orachk_melquior_ORCL_031615_091339/log/orachk.log



Checking for prompts in /home/ricardo/.bash_profile on melquior for ricardo user...


=============================================================
                    Node name - melquior
=============================================================

Collecting - Database Parameters for ORCL database
Collecting - Database Undocumented Parameters for ORCL database
Collecting - RDBMS Feature Usage for ORCL database
Collecting - CPU Information
Collecting - DiskMount Information
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 - OS Packages
Collecting - Operating system release information and kernel version
Collecting - Patches for RDBMS Home
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call




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


 INFO =>    Oracle Data Pump Best practices.
 WARNING => Linux Swap Configuration does NOT meet Recommendation
 WARNING => physical memory is not sufficient
 INFO =>    Important Storage Minimum Requirements for Grid & Database Homes
 WARNING => Non-AWR Space consumption is greater than or equal to 10% of total SYSAUX space. for ORCL
 WARNING => AWR Space consumption is greater than or equal to 10% of total SYSAUX space. for ORCL
 FAIL =>    DB_UNIQUE_NAME on primary has not been modified from the default, confirm that database name is unique across your Oracle enterprise. for ORCL
 WARNING => Kernel Parameter kernel.shmall Is lower than the recommended value
 INFO =>    At some times checkpoints are not being completed for ORCL
 WARNING => One or more redo log groups are NOT multiplexed for ORCL
 WARNING => Shell limit soft nproc for DB is NOT configured according to recommendation
 WARNING => ip_local_port_range is NOT configured according to recommendation
 WARNING => OSWatcher is not running as is recommended.
 INFO =>    umask for RDBMS owner is not set to 0022
 WARNING => Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for ORCL
 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 => One or More Registry Components were found to be Invalid for ORCL
 WARNING => Duplicate objects were found in the SYS and SYSTEM schemas for ORCL
 WARNING => Redo log file size should be sized to switch every 20 minutes during peak redo generation for ORCL
 WARNING => Oracle clusterware is not being used
 WARNING => RAC Application Cluster is not being used for database high availability on ORCL instance
 WARNING => "DISK_ASYNCH_IO is NOT set to recommended value for ORCL
 FAIL =>    Flashback on PRIMARY is not configured for ORCL
 INFO =>    Database failure prevention best practices
 WARNING => fast_start_mttr_target has NOT been changed from default on ORCL instance
 FAIL =>    Primary database is NOT protected with Data Guard (standby database) for real-time data protection and availability for ORCL
 FAIL =>    Active Data Guard is not configured for ORCL
 FAIL =>    The data files should be recoverable for ORCL
 INFO =>    Oracle recovery manager(rman) best practices
 INFO =>    Consider increasing the COREDUMPSIZE size
 WARNING => Consider setting database parameter NLS_SORT to BINARY for ORCL
 INFO =>    Consider investigating changes to the schema objects such as DDLs or new object creation for ORCL
 INFO =>    Consider adding more redo log groups or increase the size of redo logs for ORCL
 INFO =>    Consider investigating the frequency of SGA resize operations and take corrective action for ORCL
 WARNING => Shell limit soft stack for DB is not configured according to recommendation


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


Collecting patch inventory on ORACLE_HOME /home/ricardo/oracle/product/12.1.0.2/db_1
---------------------------------------------------------------------------------


---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 121020 from /home/ricardo/oracle/product/12.1.0.2/db_1 on melquior
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
19769480  yes            merge               DATABASE PATCH SET UPDATE 12.1.0.2.2 (JAN2015)
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------


---------------------------------------------------------------------------------
              RDBMS homes patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
 1              1              0                /home/ricardo/oracle/product/12.1.0.2/db_1
---------------------------------------------------------------------------------



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










Detailed report (html) - /home/ricardo/Downloads/orachk_melquior_ORCL_031615_091339/orachk_melquior_ORCL_031615_091339.html


UPLOAD(if required) - /home/ricardo/Downloads/orachk_melquior_ORCL_031615_091339.zip




[ricardo@Melquior Downloads]$

O arquivo html gerado contém além da not do ambiente, e os detalhes de cada um dos itens verificados.