Checking the robustness of database system with ORACHK self-initiative

1, Orachk tool main use

(1) Proactively check your entire software in the operating system, CRS, database, high availability and other aspects of serious problems, so that IT department rectification, improve the stability of the system

(2) Provide simplified and rationalized diagnostic and analysis recommendations for risks that exist in your system.

(3) Provide aggregated information about health risks in the system, and can drill down to specific problems and corresponding solutions

(4) Quantitative evaluation of the results (100 points), the content is very comprehensive, through the score to visually infer the health level

2, the implementation of the points of attention

(1) Orachk does not support execution under root user and requires execution under Oracle or grid user

(2) Assuming that the health of the RAC environment is checked, it is necessary to enter the Rootpassword of the other nodes, assuming that each node rootpassword the same, it can only be entered once

3, check the output information classification

Serial number	Grade	Significance
1	FAIL	A serious problem of non-conformity
2	WARNING	Warning questions
3	ERROR	Error issues
4	INFO	Reference information

4, Orachk download

Metalink article 1268927.2 in the download, the current version number is Ora CHK2.2.5, no platform, on the Linux, Aix and other platforms common

5. ORACHK Installation 5.1 Create a ORACHK private folder

Create a large number of files extracted by Orachk, and perform the analysis report material produced by Orachk

[Email protected] oracle]# mkdir-p/home/oracle/orachk

5.2, installation Orachk

Installing Orachk is very easy, just need to extract the orachk-2.2.5.zip to

[email protected] oracle]# CP orachk-2.2.5.zip/home/oracle/orachk/ [Email protected] oracle]# Cd/home/oracle/orachk [Email protected] orachk]# Unzip Orachk-2.2.5.zip

5.3. Configure Orachk folder permissions

[Email protected] orachk]# chown-r Oracle:oinstall/home/oracle/orachk [Email protected] orachk]# chmod-r 777/home/oracle/orachk

6, the single instance environment executes ORACHK carries on the health examination instance

(1) Start orachk check: [Email protected] orachk]$./orachk List of running databases 1. infadb 2. None of above Select databases from list to checking best practices. For multiple databases, select 1 for all or comma separated number like and etc [1-2][1].

(2) Output process record (partial content): 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 ------------------------------------------------------------------------------------------------------- INFA No no Yes no no yes infadb ------------------------------------------------------------------------------------------------------- Copying Plug-ins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Checking Best Practice Recommendations (PASS/WARNING/FAIL) * * * Collections and audit checks log file is /home/oracle/orachk/orachk_infa_infadb_080214_023723/log/orachk.log Checking for prompts In/home/oracle/.bash_profile on INFA for Oracle user ... ============================================================= Node NAME-INFA ============================================================= Collecting-active Sessions load balance for INFADB database Collecting-archived Destination Status for INFADB database ...... Collecting-memory Information Collecting-os Packages Collecting-operating system release information and kernel version Collecting-patches for RDBMS Home Collecting-number of semaphore operations per SEMOP system call Data collections completed. Checking best practices on INFA. -------------------------------------------------------------------------------------- INFO = User_dump_dest has trace files older than-infadb INFO = At some times checkpoints is not being completed for INFADB WARNING = one or more redo log groups is not multiplexed for INFADB WARNING = Shell Limit soft Nproc for DB are not configured according to recommendation ...... INFO = Consider investigating changes to the schema objects such as DDLs or new object creation for INFADB INFO = information about 11.2.0.3 support Best practice checking completed. Checking recommended patches on INFA. --------------------------------------------------------------------------------- Collecting patch inventory on oracle_home/dba/oracle/product/11.2.0/db_1 --------------------------------------------------------------------------------- 1 Recommended RDBMS patches for 112030 from/dba/oracle/product/11.2.0/db_1 on Infa --------------------------------------------------------------------------------- patch# RDBMS ASM Type patch-description --------------------------------------------------------------------------------- 18031683 no merge DATABASE PATCH SET UPDATE 11.2.0.3.10 (includes CPUAPR2014) --------------------------------------------------------------------------------- RDBMS Homes Patches Summary Report --------------------------------------------------------------------------------- Total patches applied in RDBMS applied on ASM oracle_home --------------------------------------------------------------------------------- 1 0 0/dba/oracle/product/11.2.0/db_1 --------------------------------------------------------------------------------- Detailed report (HTML)- /home/oracle/orachk/orachk_infa_infadb_080214_023723/orachk_infa_infadb_080214_ 023723.html UPLOAD (if required)- /home/oracle/orachk/orachk_infa_infadb_080214_023723.zip

Specific output has been packaged as a zip file

7, RAC Environment to carry out ORACHK health inspection

Method is exactly the same as a single instance, except that you need to enter the root of the remote node in the execution node

8, Output demonstration sample (extract part of content) (1) Head Overview information

Oracle RAC Assessment Report System Health score is -out of (detail) Cluster Summary Cluster Name Xxdb-cluster Os/kernel Version AIX6 (64-bit) 61 1 CRS home-version /u01/app/11.2.0.3/grid-11.2.0.3.0 DB Home-version-names /u01/app/oracle/11.2.0.3/db-11.2.0.3.0- 2 Number of nodes 2 Database Servers 2 Orachk Version 2.2.5_20140530 Collection Orachk_xxdb1_ebizsj_072514_164205.zip Duration mins, Seconds Collection Date 25-jul-2014 16:49:00 note! This version of Orachk was considered valid for the days from today or until a new version is available

(2) Database server Check Output sectionDatabase Server

Status	Type	Message	Status on	Details
FAIL	Database Check	There should is no duplicate parameter entries in the database Init.ora (spfile) file	Xxdb1:ebiz	View
FAIL	SQL Check	Table aud$[fga_log$] should use Automatic Segment Space Management for EBIZSJ	All Databases	View
FAIL	SQL Check	Some Bigfile tablespaces do not have non-default MaxBytes values set	ebiz	View
......	......	.......	......	......
WARNING	SQL Check	Consider increasing the value of the Session_cached_cursors database parameter	ebiz	View
WARNING	OS Check	Maximum number of processes user limit (ulimit-u) for current user was not set to recommended value 16384 or greater	All Database Servers	View
......	......	......	......	......

(3) Gridand RDBMS patch SectionGRID and RDBMS patch recommendation detailed reportdetailed report for "XXDB1"

1 Recommended CRS Patches for112030 From/u01/app/11.2.0.3/grid

patch#	Crs	Asm	Rdbms	Rdbms_home	Patch-description
18139678	Not-applied	N/A	Not-applied	Merge	GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.3.10 (includes DB PSU 11.2.0.3.10)

Top

1 Recommended RDBMS patchesfor 112030 from/u01/app/oracle/11.2.0.3/db

patch#	Rdbms	Asm	Type	Patch-description
18139678	Not-applied	N/A	Merge	GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.3.10 (includes DB PSU 11.2.0.3.10)

......

This article Li Junjie (Network Name: casing), engaged in "system architecture, operating systems, storage devices, databases, middleware, applications" six levels of systematic performance optimization work

Welcome to increase the system performance Optimization Professional group, together Explore performance optimization technology. Group number: 258187244

Checking the robustness of database system with ORACHK self-initiative