oracheck(oracle最佳实践审计工具)

                             oracheck(oracle最佳实践审计工具)

      由于oracle软件本身的复杂特性，所以管理在安装oracle相关的软件后，可能会忘记很多重要的设置
比如端口，参数之类的没有按照oracle推荐的最佳设置等等，这时候可以通过orachk工具来帮我们实现这一点
orachk提供了oracle软件的各种最设置，这样管理员可以根据生成的html报告来发现当前的系统中还需要有哪
些参数进行调整

    最新的orachk被设计成用来取代以前的raccheck和exacheck工具(exadata上使用),这样避免使用多个软件
带来的复杂性,统一由oracheck取代.

   orachceck能够检查很多oracle相关的软件，而不仅仅局限于oracle单实例数据库和rac 等等，还包括exadata,
timesten,goldengate,

 List of supported profiles:

                 asm             asm Checks         
                 clusterware     Oracle clusterware checks
                 compute_node    Compute Node checks (Exalogic only)
                 control_VM      Checks only for Control VM(ec1-vm, ovmm, db, pc1, pc2). No cross node checks
                 dba             dba Checks         
                 ebs             Oracle E-Business Suite checks
                 el_extensive    Extensive EL checks
                 el_lite         Exalogic-Lite Checks(Exalogic Only)
                 el_rackcompare  Data Collection for Exalogic Rack Comparison Tool(Exalogic Only)
                 goldengate      Oracle GoldenGate checks
                 maa             Maximum Availability Architecture Checks
                 obiee           obiee Checks(Exalytics Only)
                 storage         Oracle Storage Server Checks
                 switch          Infiniband switch checks
                 sysadmin        sysadmin checks    
                 timesten        timesten Checks(Exalytics Only)
                 virtual_infra   OVS, Control VM,  NTP-related and stale VNICs check (Exalogic Only)
                 zfs             ZFS storage appliances checks (Exalogic Only)

oracheck的安装很简单，从mos下载过来以oracle用户解压，并给予执行权限就可以了.

[oracle@o12c temp]$ ./orachk -h
Usage : ./orachk [-abvhpfmsuSo:c:t:]
        -a      All (Perform best practice check and recommended patch check)
        -b      Best Practice check only. No recommended patch check
        -h      Show usage
        -v      Show version
        -p      Patch check only
        -m      exclude checks for Maximum Availability Architecture (MAA) scorecards(see user guide for more details)
        -u      Run orachk to check pre-upgrade or post-upgrade best practices for 11.2.0.3,11.2.0.4.0 and 12.1.0.1
                -o pre or -o post is mandatory with -u option like ./orachk -u -o pre
        -f      Run Offline.Checks will be performed on data already collected from the system
        -o      Argument to an option. if -o is followed by v,V,Verbose,VERBOSE or Verbose, it will print checks which passs on the screen
                if -o option is not specified,it will print only failures on screen. for eg: orachk -a -o v

        -clusternodes
                Pass comma separated node names to run orachk only on subset of nodes.
        -dbnames
                Pass comma separated database names to run orachk only on subset of databases
        -localonly
                Run orachk only on local node.
        -debug
                Run orachk in debug mode. Debug log will be generated.
.............................................

第一次执行，需要指定oracle的实例，其他的可以让oracle自动处理

[oracle@o12c temp]$ ./orachk

[oracle@o12c temp]$ ./orachk

List of running databases
1. c12
2. None of above

Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1].1

.....................

照例会在当前目录生成一个文件夹和一个压缩版的文件,里面包含 了系统的各个情况

Oracle orachk Assessment Report

System Health Score is 82 out of 100 (detail)

满分为100分，当前测试的为82分

orachk还有还很多功能，比如可以通过daemon方式运行，通过邮件发送通知等等，具体可以参考mos的相关文档.