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

Description of Wheat Seedling Health examination script Chapter 1 characteristics of Wheat Seedling Health examination script

The wheat seedling health check script has the following characteristics:

1. Green version, installation-free, pure SQL text

2. Cross-platform, as long as there is a SQL*Plus environment to run

3. Compatible with Oracle 10g, 11g and 12c versions

4. One purchase, free upgrade for life

5. The content of the inspection is very comprehensive

6. script visualization, you can see the content of the script, so it can be used for learning

7. There is only one SQL script, and there are no other problems such as nested calls.

8. Generate the health check results of the html file

9. Filter the results and list the contents with problems in the database.

Good news: buy the wheat seedling health check script and give away the SQL monitoring script.

Chapter II part of the results of wheat seedling health examination

List some of the results. For others, please refer to: http://blog.itpub.net/26736162/viewspace-2129512/

2.1 Health check head

2.2 there is a corresponding explanation for the indicators.

There is a corresponding explanation when the mouse passes over, as shown in the following figure:

2.3 results of health examination

The script checked a lot of content, so I filtered the results as follows:

Click the link to view the results:

2.4 basic database information

The basic information of the database is clear at a glance:

Chapter III garbled problem 3.1 the output screen of the execution script has garbled 3.1.1 AIX system

① first check whether the system supports the Chinese environment, execute locale-a | grep zh_CN. If there is zh_CN, you need to install the Chinese language pack. If not, you'd better find the system administrator. If it is the customer's environment, you are generally not allowed to install the software at will, then we have to use the windows client to perform the health check. The effect is the same.

② sets LANG=zh_CN

③ sets NLS_LANG= "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

④ sets the character set of the client SSH software terminal interface to the Chinese character set. Take SecureCRT as an example, as shown below:

Location of XSHELL:

The execution process is as follows:

[ZFZHLHRDB2:root]: / > locale-a | grep zh_CN

Zh_CN.IBM-eucCN

Zh_CN

[ZFZHLHRDB2:root]: / > su-oracle

[ZFZHLHRDB2:oracle]: / oracle > echo $LANG

En_US

[ZFZHLHRDB2:oracle]: / oracle > LANG=zh_CN

[ZFZHLHRDB2:oracle]: / oracle > NLS_LANG= "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

[ZFZHLHRDB2:oracle]: / oracle > sqlplus / as sysdba @ DB_healthcheck_lhr_11g_v4.9.sql

SQL*Plus: Release 11.2.0.4.0 Production on Wednesday January 20 14:14:39 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP

Data Mining and Real Application Testing options

+-+

| | Oracle Database health Check script |

|-+

| Copyright (c) 2015-2100 lhr. All rights reserved. (My Blog Address: http://blog.itpub.net/26736162) |

+-+

| | About Me: lihuarong lhrbest xiaomaimiao QQ: 642808185 | |

+-+

Note: Do not modify any inspection results

Please send the file of DB_healthcheck_by_lhr_dbname_YYYYMMDD.html to lhrbest@qq.com or QQ (642808185)

Database inspection script writer: wheat seedling screen name: wheat seedling [copyright infringement must be investigated] QQ: 642808185

Description:

Used to check various indicators of Oracle 10g and 11g databases, including main database parameters, main objects, storage space configuration, database performance (AWR, ASH, ADDM), RMAN backup, etc.

Note:

If ① uses a non-sys user to execute the script, you need to use the sys user to grant the checking user the right to query x$bh, otherwise the hotblock cannot query create or replace view bh as select * from sys.x$bh; create or replace public synonym x$bh for bh.

If ② has garbled codes, you can set the following environment variable: NLS_LANG= "SIMPLIFIED CHINESE_CHINA.ZHS16GBK" NLS_LANG= "SIMPLIFIED CHINESE_CHINA.AL32UTF8".

③ users who execute scripts should at least be given the role of DBA and the permission grant select any dictionary to XXX to query any data dictionary.

+-- +

The execution of the inspection script will take several minutes, depending on the size of the library.

Begin to carry out.

+-- +

-Oracle Database Check STRAT,Starting Collect Data Dictionary Information

Please wait.

Start. Set environment variables, configure html headers.

. Omit.

You can see that Chinese has been correctly supported.

3.1.2 Linux system

① first check whether the system supports the Chinese environment, execute locale-a | grep zh_CN. If there is zh_CN, you need to install the Chinese language pack. If not, you'd better find the system administrator. If it is the customer's environment, you are generally not allowed to install the software at will, then we have to use the windows client to perform the health check. The effect is the same.

② sets LANG=zh_CN.gbk

③ sets NLS_LANG= "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

④ sets the character set of the client SSH software terminal interface to the Chinese character set. Take SecureCRT as an example, as shown below:

Location of XSHELL:

If the virtual machine is executed internally, you need to set:

The execution process is as follows:

[oracle@redhat4 ~] $locale-a | grep zh_CN

Zh_CN

Zh_CN.gb18030

Zh_CN.gb2312

Zh_CN.gbk

Zh_CN.utf8

[oracle@redhat4 ~] $export LANG=zh_CN.gbk

[oracle@redhat4 ~] $echo $LANG

Zh_CN.gbk

[oracle@redhat4 ~] $NLS_LANG= "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

[oracle@redhat4 ~] $sqlplus / as sysdba @ DB_healthcheck_lhr_11g_v4.9.sql

SQL*Plus: Release 10.2.0.1.0-Production on Wednesday January 20 18:52:59 2016

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connect to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production

With the Partitioning, OLAP and Data Mining options

+-+

| | Oracle Database health Check script |

|-+

| Copyright (c) 2015-2100 lhr. All rights reserved. (My Blog Address: http://blog.itpub.net/26736162) |

+-+

| | About Me: lihuarong lhrbest xiaomaimiao QQ: 642808185 | |

+-+

Note: Do not modify any inspection results

Please send the file of DB_healthcheck_by_lhr_dbname_YYYYMMDD.html to lhrbest@qq.com or QQ (642808185)

Database inspection script writer: wheat seedling screen name: wheat seedling [copyright infringement must be investigated] QQ: 642808185

Description:

Used to check various indicators of Oracle 10g and 11g databases, including main database parameters, main objects, storage space configuration, database performance (AWR, ASH, ADDM), RMAN backup, etc.

Note:

If ① uses a non-sys user to execute the script, you need to use the sys user to grant the checking user the right to query x$bh, otherwise the hotblock cannot query create or replace view bh as select * from sys.x$bh; create or replace public synonym x$bh for bh.

If ② has garbled codes, you can set the following environment variable: NLS_LANG= "SIMPLIFIED CHINESE_CHINA.ZHS16GBK" NLS_LANG= "SIMPLIFIED CHINESE_CHINA.AL32UTF8".

③ users who execute scripts should at least be given the role of DBA and the permission grant select any dictionary to XXX to query any data dictionary.

+-- +

The execution of the inspection script will take several minutes, depending on the size of the library.

Begin to carry out.

+-- +

-Oracle Database Check STRAT,Starting Collect Data Dictionary Information

Please wait.

Start. Set environment variables, configure html headers.

. Omit.

You can see that Chinese has been correctly supported.

3.2 the generated html document opens with garbled codes.

If the html file generated by the garbled setting on the output screen of the execution script is garbled, we can use the text opening tool (editplus,UE) to open the html file, and then change the value of charset in the third line to GBK, as follows:

The database content is garbled.

About Me

. .

● author: wheat seedlings, only focus on the database technology, pay more attention to the application of technology

● article is updated synchronously on itpub (http://blog.itpub.net/26736162/abstract/1/), blog Park (http://www.cnblogs.com/lhrbest) and personal Wechat official account (xiaomaimiaolhr).

● article itpub address: http://blog.itpub.net/26736162/abstract/1/

● article blog park address: http://www.cnblogs.com/lhrbest

● pdf version of this article, personal introduction and wheat seedling cloud disk address: http://blog.itpub.net/26736162/viewspace-1624453/

● database written examination interview questions database and answers: http://blog.itpub.net/26736162/viewspace-2134706/

● DBA Baodian Jinri Toutiao address: http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826

. .

● QQ group number: 230161599 (full), 618766405

● WeChat group: you can add me Wechat, I will pull everyone into the group, if you are the one

● contact me, please add QQ friend (646634621), indicate the reason for adding

● completed at 09:00 in 2017-08-01 to 22:00 in Mordo, 2017-08-31.

The content of the ● article comes from the study notes of wheat seedlings, and some of it is sorted out from the Internet. Please forgive me if there is any infringement or improper place.

Copyright ● all rights reserved, welcome to share this article, please reserve the source for reprint

. .

The micro store of ● wheat seedlings: https://weidian.com/s/793741433?wfr=c&ifr=shopdetail

A series of database books published by ● wheat seedlings: http://blog.itpub.net/26736162/viewspace-2142121/

. .

Use Wechat client to scan the following QR code to follow the Wechat official account (xiaomaimiaolhr) and QQ group (DBA treasure book) of wheat seedlings and learn the most practical database technology.

Wheat seedling Wechat official account wheat seedling DBA treasure QQ group 1 wheat seedling DBA treasure QQ group 2 wheat seedling Weidian

. .

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.