TOP

用ORACHK自动化检查数据库系统的健壮性(二)

2015-07-24 11:13:51 来源: 作者: 【大中小】浏览:4次

port

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、输出结果示例（摘取部分内容）

Note! This version of orachk is considered valid for 64 days from today or until a new version is available

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
......	......	......	......	......

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.