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 on 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
详细输出结果已经打包成zip文件
7、RAC环境运行orachk开展健康检查
方法与单实例完全一样，不同的一点在于，需要在运行节点，输入远端节点的root密
8、输出结果示例（摘取部分内容）
（1）头部概述信息
Cluster Summary
|
（2）database server检查输出部分
Database Server
| Status |
Type |
Message |
Status On |
Details |
| FAIL |
Database Check |
There should be 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 is NOT set to recommended value 16384 or greater |
All Database Servers |
View |
| ...... |
...... |
...... |
...... |
...... |
（3）GRIDAND RDBMS Patch部分
GRID and RDBMS patch recommendation Detailed report
Detailed 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.