Shulou(Shulou.com)06/01 Report--

Daily database inspection is one of the tasks that operators often need to complete. In response to the complex software and hardware and system environment, as well as more and more systems, the cost pressure of routine inspection is increasing. In the aspect of comprehensive inspection, automatic implementation and information collection is a development direction of patrol inspection in the future.

Oracle Support internal research and development institutions, will launch a lot of useful gadgets to assist our daily inspection and diagnosis tools, such as OSWatcher, RDA, oratop. To some extent, these tools address the management and tuning requirements we encounter when using the Oracle database. This article mainly introduces oracheck, with the help of orachk, we can quickly carry out system inspection and troubleshooting.

1. From raccheck to oracheck

Oracheck comes from raccheck, a tool prepared by Oracle for the RAC environment. The earliest raccheck was developed to automate the inspection of the Oracle RAC environment, and new versions and features have been introduced ever since. The most significant of these new features is the introduction of Oracle MAA (Oracle maximum availability Architecture). Oracle will integrate the best practices of MAA into the raccheck inspection project to provide users with a more comprehensive inspection project.

At present, raccheck has been officially renamed to oracheck, which provides patrol inspection functions from single instance database instance to RAC, OGG and other product series.

2. Installation and configuration

Oracheck is a toolkit that needs to be downloaded separately from MOS. Unlike other Oracle products, oracheck updates are very fast, and the official recommendation is to download the latest oracheck version within 90 days. The purpose of this is to allow users to get the latest checks and suggestions and download and install the latest security patches in a timely manner.

The package downloaded from MOS is simple: it's a zip package. Upload it to the server and decompress it and use it. Note: currently, oracheck only supports 64bit systems and cannot be used under 32bit.

Create a special directory and upload zip files.

[root@CRSimpleLinux /] # mkdir / orachk

[root@CRSimpleLinux /] # cd / orachk/

[root@CRSimpleLinux orachk] # ls-l

Total 5120

-rw-r--r-- 1 root root 5241976 May 20 08:44 orachk_224_beta2.zip

Extract the installation package.

[root@CRSimpleLinux orachk] # unzip orachk_224_beta2.zip

Archive: orachk_224_beta2.zip

Inflating: orachk

Creating: .cgrep /

Inflating: .cgrep / lcgreps9

Inflating: .cgrep / CollectionManager_App.sql

Inflating: .cgrep / asrexacheck

Inflating: .cgrep / utlusts.sql

(for reasons of space, there are omissions. )

Check the script, which is a series of configuration files and oracheck execution files.

[root@CRSimpleLinux orachk] # ls-l

Total 28072

-rw-rw-r-- 1 root root 21200391 Feb 11 03:50 collections.dat

-rwxr-xr-x 1 root root 1407669 Feb 14 03:23 orachk

-rwxr-xr-x 1 root root 1423197 Feb 11 03:50 raccheck

-rw-r--r-- 1 root root 2541 Feb 11 03:50 readme.txt

-rw-rw-r-- 1 root root 4700572 Feb 11 03:50 rules.dat

-rw-r--r-- 1 root root 296 Feb 11 03:50 UserGuide.txt

Additional authorization to oracle users and additional modification permissions of 755.

[root@CRSimpleLinux /] # chown-R oracle:oinstall orachk/

[root@CRSimpleLinux /] # chmod-R 755 / orachk/

[root@CRSimpleLinux /] # cd / orachk/

[root@CRSimpleLinux orachk] # ls-l

Total 28072

-rwxr-xr-x 1 oracle oinstall 21200391 Feb 11 03:50 collections.dat

-rwxr-xr-x 1 oracle oinstall 1407669 Feb 14 03:23 orachk

-rwxr-xr-x 1 oracle oinstall 1423197 Feb 11 03:50 raccheck

-rwxr-xr-x 1 oracle oinstall 2541 Feb 11 03:50 readme.txt

-rwxr-xr-x 1 oracle oinstall 4700572 Feb 11 03:50 rules.dat

-rwxr-xr-x 1 oracle oinstall 296 Feb 11 03:50 UserGuide.txt

Note: on executing oracheck users, root or oracle owner objects can be selected depending on the situation. In some inspection projects, root permission is required to operate. A more recommended way is to use the owner user to execute, and follow the prompts to enter the root password when root permission is needed.

3. Use of oracheck

Oracheck scripts have a default behavior, and the execution behavior can be controlled by parameters. For example,-v can display version information.

[oracle@CRSimpleLinux orachk] $. / orachk-v

ORACHK VERSION: 2.2.4 (BETA) _ 20140210

In general, most of the inspection items can be done using the default profile configuration.

[oracle@CRSimpleLinux orachk] $. / orachk-v

ORACHK VERSION: 2.2.4 (BETA) _ 20140210

[oracle@CRSimpleLinux orachk] $. / orachk

This computer is for [S] ingle instance database or part of a [C] luster to run RAC database [S | C] [C]: s

Orachk did not find the RDBMS binaries on crsimplelinux from environment.

Please set RAT_ORACLE_HOME to ORACLE_HOME in current shell to override and re-run it.

Eg export RAT_ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

In the default configuration environment variable, RAT_ORACLE_HOME is required to be configured as ORACLE_HOME.

[oracle@CRSimpleLinux orachk] $export RAT_ORACLE_HOME=$ORACLE_HOME

[oracle@CRSimpleLinux orachk] $env | grep RAT_ORACLE_HOME

RAT_ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

[oracle@CRSimpleLinux orachk] $. / orachk

This computer is for [S] ingle instance database or part of a [C] luster to run RAC database [S | C] [C]: s

(for reasons of space, there are omissions. )

Data collections completed. Checking best practices on crsimplelinux.

-

(list of problems found. )

WARNING = > net.core.wmem_max Is NOT Configured According to Recommendation

WARNING = > net.core.rmem_max Is NOT Configured According to Recommendation

WARNING = > The number of async IO descriptors is too low (/ proc/sys/fs/aio-max-nr)

WARNING = > kernel.shmmax parameter is NOT configured according to recommendation

WARNING = > OSWatcher is not running as is recommended.

INFO = > Consider increasing the COREDUMPSIZE size

Best Practice checking completed.Checking recommended patches on crsimplelinux.

RDBMS homes patches summary report

Total patches Applied on RDBMS Applied on ASM ORACLE_HOME

Detailed report (html)-/ orachk/orachk_crsimplelinux_052014_172942/orachk_crsimplelinux_052014_172942.html-result report file

UPLOAD (if required)-/ orachk/orachk_crsimplelinux_052014_172942.zip

A zip file and folder are included in the directory, including the inspection results report.

[oracle@CRSimpleLinux orachk] $ls-l

Total 28228

-rwxr-xr-x 1 oracle oinstall 21200391 Feb 11 03:50 collections.dat

-rwxr-xr-x 1 oracle oinstall 1407669 Feb 14 03:23 orachk

Drwxr-xr-x 6 oracle oinstall 12288 May 20 17:30 orachk_crsimplelinux_052014_172942

-rw-r--r-- 1 oracle oinstall 145482 May 20 17:30 orachk_crsimplelinux_052014_172942.zip

-rwxr-xr-x 1 oracle oinstall 1423197 Feb 11 03:50 raccheck

-rwxr-xr-x 1 oracle oinstall 2541 Feb 11 03:50 readme.txt

-rwxr-xr-x 1 oracle oinstall 4700572 Feb 11 03:50 rules.dat

-rwxr-xr-x 1 oracle oinstall 296 Feb 11 03:50 UserGuide.txt

4. Analysis of the report

Open the html file and you can see the report. The report header is a rating of the system by oracheck, which is shown below with a score of 87. The summary link includes the basic information of the database.

First of all, for the database needs to pay attention to, oracheck gives a special display. At the level, there are also corresponding different types. Oracheck currently supports several types: fail, warning, error and info.

The inspection items of Passed are included later. For the content of the reminder, we click Details and we can jump to the details section for explanation and check.

The content of the above prompt is relatively clear. This error is determined for the kernel kernal.shmmax parameter. In Oracle DBMS, the principle for configuring this parameter is to configure it according to the general size of physical memory. The actual size found in the inspection is 2147483648, and the recommended size is 4088072192. And prompted the detailed analysis of the MOS article number.

The content of the oracheck report is determined in conjunction with the content of Oracle best practices, which we can modify according to the actual situation below.

5. Rerun the report

After the problem has been modified according to the prompt (see the following article for details on the modification process), it is best to rerun oracheck to determine whether the problem has been solved.

[oracle@CRSimpleLinux ~] $cd / orachk/

[oracle@CRSimpleLinux orachk] $export RAT_ORACLE_HOME=$ORACLE_HOME

[oracle@CRSimpleLinux orachk] $. / orachk

This computer is for [S] ingle instance database or part of a [C] luster to run RAC database [S | C] [C]:

Collecting-Patches for RDBMS Home

Collecting-number of semaphore operations per semop system call

Data collections completed. Checking best practices on crsimplelinux.

-

WARNING = > OSWatcher is not running as is recommended.

INFO = > Consider increasing the COREDUMPSIZE size

(for reasons of space, there are omissions. )

Detailed report (html)-/ orachk/orachk_crsimplelinux_052014_180024/orachk_crsimplelinux_052014_180024.html

UPLOAD (if required)-/ orachk/orachk_crsimplelinux_052014_180024.zip

Generate a new report file.

[oracle@CRSimpleLinux orachk] $ls-l

Total 28380

-rwxr-xr-x 1 oracle oinstall 21200391 Feb 11 03:50 collections.dat

-rwxr-xr-x 1 oracle oinstall 1407669 Feb 14 03:23 orachk

Drwxr-xr-x 6 oracle oinstall 12288 May 20 17:30 orachk_crsimplelinux_052014_172942

-rw-r--r-- 1 oracle oinstall 145482 May 20 17:30 orachk_crsimplelinux_052014_172942.zip

Drwxr-xr-x 6 oracle oinstall 12288 May 20 18:01 orachk_crsimplelinux_052014_180024

-rw-r--r-- 1 oracle oinstall 143227 May 20 18:01 orachk_crsimplelinux_052014_180024.zip

-rwxr-xr-x 1 oracle oinstall 1423197 Feb 11 03:50 raccheck

-rwxr-xr-x 1 oracle oinstall 2541 Feb 11 03:50 readme.txt

Open the report and you can see that the inspection score has been improved.

6. Report comparison function

Another important function of oracheck is report comparison. A report can provide a comparison with previous reports and identify the changing factors of the problem in a timely manner.

[oracle@CRSimpleLinux orachk] $. / orachk-diff orachk_crsimplelinux_052014_172942 orachk_crsimplelinux_052014_180024

Summary

Total: 23

Missing: 0

New: 0

Changed: 4

Same: 19

File comparison is complete. The comparison report can be viewed in: / orachk/orachk_052014172942_052014180024_diff.html

In the report document, you can see the comparison and change tips.

7. Conclusion

Oracheck comes from raccheck and does not change much in terms of usage and function. Oracheck supports a wide range of Oracle products and operating systems. If combined with the automatic execution function, it can fully support the daily automatic inspection work of multi-database servers.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.