{"id":690,"date":"2013-01-27T10:26:32","date_gmt":"2013-01-27T02:26:32","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=690"},"modified":"2013-01-29T01:14:34","modified_gmt":"2013-01-28T17:14:34","slug":"raccheck-rac-configuration-audit-tool%e4%bd%bf%e7%94%a8%e4%bb%8b%e7%bb%8d","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=690","title":{"rendered":"RACcheck (RAC Configuration Audit Tool)\u4f7f\u7528\u4ecb\u7ecd"},"content":{"rendered":"<p>RACcheck (RAC Configuration Audit Tool)\u4f7f\u7528\u4ecb\u7ecd<br \/>\n\u8fd9\u4e2a\u5de5\u5177\u4e0d\u4f46\u65b9\u4fbfdba\u5bf9rac\u73af\u5883\u8fdb\u884c\u65e5\u5e38\u68c0\u67e5\uff0c\u800c\u4e14\u4e5f\u4fbf\u4e8e\u4e00\u7ebfdba\u5728rac\u51fa\u73b0\u95ee\u9898\u65f6\uff0c\u5c06\u6574\u4e2arac\u60c5\u51b5\u63d0\u4ea4\u7ed9oracle\u7684sr\u5feb\u901f\u5904\u7406\u95ee\u9898\u3002\u8be5\u5de5\u5177\u53ea\u8981\u5c06\u538b\u7f29\u5305\u4e0a\u4f20\u5e76\u89e3\u538b\u5373\u53ef\u8fd0\u884c\uff0c\u5f00\u59cb\u6536\u96c6OS\uff0cCRS\/GI\uff0cASM,RDBMS\u7b49\u6570\u636e\u4fe1\u606f\uff0c\u5b8c\u4e86\u518d\u8fdb\u884c\u5206\u6790\u5f97\u51fa\u4e00\u4e2a\u6c47\u603b\u6587\u4ef6\uff0c\u4fbf\u4e8edba\u5bf9\u95ee\u9898\u7684\u4ee5\u53ca\u5f53\u524drac\u7684\u72b6\u6001\u505a\u51fa\u8bc4\u4f30\u3002\u4f46\u662f\uff0c\u8be5\u5de5\u5177\u5728\u6211\u7684\u5b9e\u6d4b\u4e2d\u53d1\u73b0\u4ee5\u4e0b\u95ee\u9898\uff1a\u7b2c\u4e00\uff0c\u6267\u884c\u65f6\u95f4\u5f88\u957f\uff08\u4e0d\u77e5\u9053\u662f\u4e0d\u662f\u6211\u865a\u62df\u673a\u7684\u539f\u56e0\uff09\uff0c\u7b2c\u4e8c\uff0c\u592a\u8017\u7528\u4e3b\u673aCPU\u8d44\u6e90\u3002\u5f53\u7136\u8be5\u5de5\u5177\u7684\u5b98\u65b9\u5efa\u8bae\u662f\u6bcf\u4e09\u4e2a\u6708\u8fdb\u884c\u68c0\u67e5\u4e00\u6b21\uff0c\u6216\u8005\u5728rac\u5347\u7ea7\u524d\u5347\u7ea7\u540e\uff0c\u5b89\u88c5\u524d\u7b49\u7279\u6b8a\u65f6\u95f4\u6267\u884c\u4e5f\u662f\u6709\u539f\u56e0\u7684\u3002\u800c\u8be5\u5de5\u5177\u6267\u884c\u5b8c\u540e\uff0c\u4f1a\u5728\u751f\u6210\u4e00\u4e2a.zip\u6587\u4ef6\u548c\u4e00\u4e2a\u7c7b\u4f3cawr\u62a5\u544a\u7684.html\u6587\u4ef6\uff0c.zip\u6587\u4ef6\u4fbf\u4e8e\u4e00\u7ebfdba\u63d0\u4ea4\u7ed9oracle sr\uff0c.html\u6587\u4ef6\u4fbf\u4e8edba\u5206\u6790\u5f53\u524drac\u7684\u6574\u4f53\u60c5\u51b5\u3002<\/p>\n<p>\u5f53\u524d\u96c6\u7fa4\u72b6\u6001<\/p>\n<pre class=\"wp-code-highlight prettyprint\">[grid@11grac1 ~]$ crs_stat -t\r\nName           Type           Target    State     Host        \r\n------------------------------------------------------------\r\nora....SM1.asm application    ONLINE    ONLINE    11grac1     \r\nora....C1.lsnr application    ONLINE    ONLINE    11grac1     \r\nora....ac1.gsd application    ONLINE    ONLINE    11grac1     \r\nora....ac1.ons application    ONLINE    ONLINE    11grac1     \r\nora....ac1.vip ora....t1.type ONLINE    ONLINE    11grac1     \r\nora....SM2.asm application    ONLINE    ONLINE    11grac2     \r\nora....C2.lsnr application    ONLINE    ONLINE    11grac2     \r\nora....ac2.gsd application    ONLINE    ONLINE    11grac2     \r\nora....ac2.ons application    ONLINE    ONLINE    11grac2     \r\nora....ac2.vip ora....t1.type ONLINE    ONLINE    11grac2     \r\nora.DATA.dg    ora....up.type ONLINE    ONLINE    11grac1     \r\nora....ER.lsnr ora....er.type ONLINE    ONLINE    11grac1     \r\nora....N1.lsnr ora....er.type ONLINE    ONLINE    11grac2     \r\nora.asm        ora.asm.type   ONLINE    ONLINE    11grac1     \r\nora.eons       ora.eons.type  ONLINE    ONLINE    11grac1     \r\nora.gsd        ora.gsd.type   ONLINE    ONLINE    11grac1     \r\nora....network ora....rk.type ONLINE    ONLINE    11grac1     \r\nora.oc4j       ora.oc4j.type  ONLINE    ONLINE    11grac2     \r\nora.ons        ora.ons.type   ONLINE    ONLINE    11grac1     \r\nora.racdb.db   ora....se.type ONLINE    ONLINE    11grac1     \r\nora.scan1.vip  ora....ip.type ONLINE    ONLINE    11grac2<\/pre>\n<p>\u5c06\u538b\u7f29\u5305\u4e0a\u4f20\u5e76\u89e3\u538b<\/p>\n<pre class=\"wp-code-highlight prettyprint\">[oracle@11grac1 ~]$ ls -l\r\ntotal 2652\r\ndrwxr-x--- 3 oracle oinstall    4096 Aug 28 16:45 oradiag_oracle\r\n-rw-r--r-- 1 oracle oinstall 2705532 Jan 26 23:53 raccheck.zip\r\n[oracle@11grac1 ~]$ unzip raccheck.zip \r\nArchive:  raccheck.zip\r\n  inflating: raccheck                \r\n  inflating: readme.txt              \r\n   creating: .cgrep\/\r\n  inflating: .cgrep\/lcgreps11        \r\n  inflating: .cgrep\/lcgrep4          \r\n  inflating: .cgrep\/acgrep           \r\n  inflating: .cgrep\/exalogic_zfs_checks.aksh  \r\n  inflating: .cgrep\/lcgrep5          \r\n  inflating: .cgrep\/lcgreps10        \r\n  inflating: .cgrep\/hiacgrep         \r\n  inflating: .cgrep\/lcgrep6          \r\n  inflating: .cgrep\/utlusts.sql      \r\n  inflating: .cgrep\/asrexacheck      \r\n  inflating: .cgrep\/lcgreps9         \r\n  inflating: .cgrep\/scnhealthcheck.sql  \r\n  inflating: .cgrep\/utlu112i.sql     \r\n  inflating: .cgrep\/scgrep           \r\n  inflating: .cgrep\/scgrepx86        \r\n  inflating: rules.dat               \r\n  inflating: UserGuide.txt           \r\n  inflating: collections.dat         \r\n[oracle@11grac1 ~]$ ls -l\r\ntotal 19804\r\n-rw-rw-r-- 1 oracle oinstall 13219887 Nov 10 03:50 collections.dat\r\ndrwxr-x--- 3 oracle oinstall     4096 Aug 28 16:45 oradiag_oracle\r\n-rwxr-xr-x 1 oracle oinstall   873168 Nov 10 03:50 raccheck\r\n-rw-r--r-- 1 oracle oinstall  2705532 Jan 26 23:53 raccheck.zip\r\n-rw-r--r-- 1 oracle oinstall     2220 Nov 10 03:50 readme.txt\r\n-rw-rw-r-- 1 oracle oinstall  3425695 Nov 10 03:50 rules.dat\r\n-rw-r--r-- 1 oracle oinstall      304 Nov 10 03:50 UserGuide.txt<\/pre>\n<p>\u67e5\u770b\u7248\u672c<\/p>\n<pre class=\"wp-code-highlight prettyprint\">[oracle@11grac1 ~]$ .\/raccheck -v\r\n\r\nRACCHECK  VERSION: 2.2.0_20121109<\/pre>\n<p>\uff08\u4e00\uff09\u4ee5\u4ea4\u4e92\u5f0f\u6267\u884c<\/p>\n<pre class=\"wp-code-highlight prettyprint\">[oracle@11grac1 ~]$ .\/raccheck \r\n\r\nCRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to \/u01\/11.2.0\/grid?[y\/n][y]\t\t--\u6b64\u5904\u56de\u8f66\uff0c\u9ed8\u8ba4\u5176crs_home\r\n\r\nChecking ssh user equivalency settings on all nodes in cluster\r\n\r\nNode 11grac2 is configured for ssh user equivalency for oracle user\r\n\r\nSearching for running databases . . . . .\r\n\r\n. \r\nList of running databases registered in OCR\r\n1. racdb\r\n2. None of above\r\n\r\nSelect 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].\t\t--\u6b64\u5904\u56de\u8f66\uff0c\u9ed8\u8ba4\u5176\u6570\u636e\u5e93\r\n. . \r\n\r\nChecking Status of Oracle Software Stack - Clusterware, ASM, RDBMS\r\n\r\n. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . \r\n-------------------------------------------------------------------------------------------------------\r\n                                                 Oracle Stack Status                            \r\n-------------------------------------------------------------------------------------------------------\r\nHost Name  CRS Installed  ASM HOME       RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name\r\n-------------------------------------------------------------------------------------------------------\r\n11grac1     Yes             Yes             Yes             Yes        Yes      Yes      racdb1    \r\n11grac2     Yes             Yes             Yes             Yes        Yes      Yes      racdb2    \r\n-------------------------------------------------------------------------------------------------------\r\n\r\n79 of the included audit checks require root privileged data collection . If sudo is not configured or the root password is not available, audit checks which  require root privileged data collection can be skipped.\r\n\r\n1. Enter 1 if you will enter root password for each  host when prompted\r\n\r\n2. Enter 2 if you have sudo configured for oracle user to execute root_raccheck.sh script \r\n\r\n3. Enter 3 to skip the root privileged collections \r\n\r\n4. Enter 4 to exit and work with the SA to configure sudo  or to arrange for root access and run the tool later.\r\n\r\nPlease indicate your selection from one of the above options[1-4][1]:- 2\t--\u6b64\u5904\u9009\u62e92\uff0c\u4f7f\u7528sudo\u8ba9oracle\u6267\u884croot_raccheck.sh \r\n\r\n*** Checking Best Practice Recommendations (PASS\/WARNING\/FAIL) ***\r\n\r\nLog file for collections and audit checks are at\r\n\/home\/oracle\/raccheck_012613_235400\/raccheck.log\r\n\r\n=============================================================\r\n                    Node name - 11grac1                                \r\n=============================================================\r\nCollecting - ASM DIsk I\/O stats \r\nCollecting - ASM Disk Groups \r\nCollecting - ASM Diskgroup Attributes \r\nCollecting - ASM disk partnership imbalance \r\nCollecting - ASM diskgroup attributes \r\nCollecting - ASM initialization parameters \r\nCollecting - Active sessions load balance for racdb database \r\nCollecting - Archived Destination Status for racdb database \r\nCollecting - Cluster Interconnect Config for racdb database \r\nCollecting - Database Archive Destinations for racdb database \r\nCollecting - Database Files for racdb database \r\nCollecting - Database Instance Settings for racdb database \r\nCollecting - Database Parameters for racdb database \r\nCollecting - Database Properties for racdb database \r\nCollecting - Database Registry for racdb database \r\nCollecting - Database Sequences for racdb database \r\nCollecting - Database Undocumented Parameters for racdb database \r\nCollecting - Database Workload Services for racdb database \r\nCollecting - Dataguard Status for racdb database \r\nCollecting - Files not opened by ASM \r\nCollecting - Log Sequence Numbers for racdb database \r\nCollecting - Percentage of asm disk  Imbalance \r\nCollecting - Process for shipping Redo to standby for racdb database \r\nCollecting - Redo Log information for racdb database \r\nCollecting - Standby redo log creation status before switchover for racdb database \r\nCollecting - CPU Information\r\nCollecting - CRS active version\r\nCollecting - CRS oifcfg\r\nCollecting - CRS software version\r\nCollecting - CSS Reboot time\r\nCollecting - CSS disktimout\r\nCollecting - Cluster interconnect (clusterware)\r\nCollecting - Clusterware OCR healthcheck \r\nCollecting - Clusterware Resource Status\r\nCollecting - Huge pages configuration\r\nCollecting - Kernel parameters\r\nCollecting - Linux module config.\r\nCollecting - Maximum number of semaphore sets on system\r\nCollecting - Maximum number of semaphores on system\r\nCollecting - Maximum number of semaphores per semaphore set\r\nCollecting - Memory Information\r\nCollecting - OS Packages\r\nCollecting - Operating system release information and kernel version\r\nCollecting - Oracle Executable Attributes\r\nCollecting - Patches for Grid Infrastructure \r\nCollecting - Patches for RDBMS Home \r\nCollecting - Shared memory segments\r\nCollecting - Table of file system defaults\r\nCollecting - Voting disks (clusterware)\r\nCollecting - number of semaphore operations per semop system call\r\n\r\nPreparing to run root privileged commands  11grac1.\r\n\r\n[sudo] password for oracle: \t--\u6b64\u5904\u9700\u8981\u8f93\u5165oracle\u7528\u6237OS\u7684\u5bc6\u7801\r\n\r\nData collections completed. Checking best practices on 11grac1.\r\n--------------------------------------------------------------------------------------\r\n\r\n WARNING =&amp;gt; OCR is NOT being backed up daily\r\n INFO =&amp;gt;    $CRS_HOME\/log\/hostname\/client directory has too many older log files.\r\n INFO =&amp;gt;    user_dump_dest has trace files older than 30 days for racdb\r\n INFO =&amp;gt;    background_dump_dest has files older than 30 days for racdb\r\n INFO =&amp;gt;    At some times checkpoints are not being completed for racdb\r\n WARNING =&amp;gt; Open files limit (ulimit -n) for current user is NOT set to recommended value &amp;gt;= 65536 or unlimited\r\n INFO =&amp;gt;    audit_file_dest has audit files older than 30 days for racdb\r\n WARNING =&amp;gt; One or more redo log groups are NOT multiplexed for racdb\r\n INFO =&amp;gt;    oracleasm (asmlib) module is NOT loaded\r\n WARNING =&amp;gt; \/tmp is NOT on a dedicated filesystem\r\n WARNING =&amp;gt; kernel.shmmax parameter is NOT configured according to recommendation\r\n INFO =&amp;gt;    Number of SCAN listeners is NOT equal to the recommended number of 3.\r\n WARNING =&amp;gt; NIC bonding is not configured for interconnect\r\n WARNING =&amp;gt; NIC bonding is NOT configured for public network (VIP)\r\n WARNING =&amp;gt; OSWatcher is not running as is recommended.\r\n INFO =&amp;gt;    Jumbo frames (MTU ~9000) are not configured for interconnect\r\n FAIL =&amp;gt;    Database parameter DB_BLOCK_CHECKSUM is NOT set to recommended value on racdb1 instance\r\n FAIL =&amp;gt;    Database parameter DB_LOST_WRITE_PROTECT is NOT set to recommended value on racdb1 instance\r\n WARNING =&amp;gt; Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for racdb\r\n FAIL =&amp;gt;    Flashback on PRIMARY is not configured for racdb\r\n FAIL =&amp;gt;    No one high redundancy diskgroup configured for racdb\r\n INFO =&amp;gt;    Operational Best Practices\r\n INFO =&amp;gt;    Consolidation Database Practices\r\n INFO =&amp;gt;    Network failure prevention best practices\r\n INFO =&amp;gt;    Computer failure prevention best practices\r\n INFO =&amp;gt;    Data corruption prevention best practices\r\n INFO =&amp;gt;    Logical corruption prevention best practices\r\n INFO =&amp;gt;    Storage failures prevention best practices\r\n INFO =&amp;gt;    Database\/Cluster\/Site failure prevention best practices\r\n INFO =&amp;gt;    Client failover operational best practices\r\n WARNING =&amp;gt; fast_start_mttr_target has NOT been changed from default on racdb1 instance\r\n\r\n INFO =&amp;gt;    IMPORTANT: Oracle Database SCN Headroom. See Details for More Info \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\n INFO =&amp;gt;    Information about hanganalyze and systemstate dump\r\n FAIL =&amp;gt;    Your Configuration is NOT in Compliance with Oracle Security Alert for CVE-2012-1675 \/u01\/11.2.0\/grid\r\n FAIL =&amp;gt;    Your Configuration is NOT in Compliance with Oracle Security Alert for CVE-2012-1675 \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\n INFO =&amp;gt;    Software maintenance best practices\r\n INFO =&amp;gt;    Database failure prevention best practices\r\n WARNING =&amp;gt; Database Archivelog Mode should be set to ARCHIVELOG for racdb\r\n FAIL =&amp;gt;    Primary database is NOT protected with Data Guard (standby database) for real-time data protection and availability for racdb\r\n WARNING =&amp;gt; avahi-daemon process is running\r\n\r\nBest Practice checking completed.Checking recommended patches on 11grac1.\r\n---------------------------------------------------------------------------------\r\n\r\nCollecting patch inventory on  CRS HOME \/u01\/11.2.0\/grid\r\nCollecting patch inventory on ORACLE_HOME \/u01\/app\/oracle\/product\/11.2.0\/db_1 \r\n---------------------------------------------------------------------------------\r\n1 Recommended CRS patches for 112010 from \/u01\/11.2.0\/grid on 11grac1\r\n---------------------------------------------------------------------------------\r\nPatch#   CRS  ASM    RDBMS RDBMS_HOME                              Patch-Description                            \r\n---------------------------------------------------------------------------------\r\n9655006   no          no  \/u01\/app\/oracle\/product\/11.2.0\/db_1GI PSU 11.2.0.1.2 (INCLUDES DATABASE PS      \r\n---------------------------------------------------------------------------------\r\n\r\n---------------------------------------------------------------------------------\r\n26 Recommended RDBMS patches for 112010 from \/u01\/app\/oracle\/product\/11.2.0\/db_1 on 11grac1\r\n---------------------------------------------------------------------------------\r\nPatch#   RDBMS    ASM     type                Patch-Description                       \r\n---------------------------------------------------------------------------------\r\n9218789   no             N-APPLY             N-APPLY BUNDLE PATCH FOR RDBMS 11.2.0.1 \r\n---------------------------------------------------------------------------------\r\n---------------------------------------------------------------------------------\r\n\r\n---------------------------------------------------------------------------------\r\n              Clusterware patches summary report\r\n---------------------------------------------------------------------------------\r\nTotal patches  Applied on CRS Applied on RDBMS Applied on ASM \r\n---------------------------------------------------------------------------------\r\n1              0              0                0              \r\n---------------------------------------------------------------------------------\r\n\r\n---------------------------------------------------------------------------------\r\n              RDBMS homes patches summary report\r\n---------------------------------------------------------------------------------\r\nTotal patches  Applied on RDBMS Applied on ASM ORACLE_HOME    \r\n---------------------------------------------------------------------------------\r\n 26             0              0                \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\n---------------------------------------------------------------------------------\r\n\r\n=============================================================\r\n                    Node name - 11grac2                                \r\n=============================================================\r\nCollecting - CPU Information\r\nCollecting - CRS active version\r\nCollecting - CRS oifcfg\r\nCollecting - CRS software version\r\nCollecting - Cluster interconnect (clusterware)\r\nCollecting - Huge pages configuration\r\nCollecting - Kernel parameters\r\nCollecting - Linux module config.\r\nCollecting - Maximum number of semaphore sets on system\r\nCollecting - Maximum number of semaphores on system\r\nCollecting - Maximum number of semaphores per semaphore set\r\nCollecting - Memory Information\r\nCollecting - OS Packages\r\nCollecting - Operating system release information and kernel version\r\nCollecting - Oracle Executable Attributes\r\nCollecting - Patches for Grid Infrastructure \r\nCollecting - Patches for RDBMS Home \r\nCollecting - Shared memory segments\r\nCollecting - Table of file system defaults\r\nCollecting - number of semaphore operations per semop system call\r\n\r\nPreparing to run root privileged commands  11grac2.\r\n\r\nWe trust you have received the usual lecture from the local System\r\nAdministrator. It usually boils down to these three things:\r\n\r\n    #1) Respect the privacy of others.\r\n    #2) Think before you type.\r\n    #3) With great power comes great responsibility.\r\n\r\n[sudo] password for oracle: \r\n\r\nData collections completed. Checking best practices on 11grac2.\r\n--------------------------------------------------------------------------------------\r\n\r\n INFO =&amp;gt;    $CRS_HOME\/log\/hostname\/client directory has too many older log files.\r\n INFO =&amp;gt;    user_dump_dest has trace files older than 30 days for racdb\r\n INFO =&amp;gt;    background_dump_dest has files older than 30 days for racdb\r\n INFO =&amp;gt;    At some times checkpoints are not being completed for racdb\r\n INFO =&amp;gt;    audit_file_dest has audit files older than 30 days for racdb\r\n INFO =&amp;gt;    oracleasm (asmlib) module is NOT loaded\r\n WARNING =&amp;gt; \/tmp is NOT on a dedicated filesystem\r\n WARNING =&amp;gt; kernel.shmmax parameter is NOT configured according to recommendation\r\n INFO =&amp;gt;    Number of SCAN listeners is NOT equal to the recommended number of 3.\r\n WARNING =&amp;gt; NIC bonding is not configured for interconnect\r\n WARNING =&amp;gt; NIC bonding is NOT configured for public network (VIP)\r\n WARNING =&amp;gt; OSWatcher is not running as is recommended.\r\n INFO =&amp;gt;    Jumbo frames (MTU ~9000) are not configured for interconnect\r\n FAIL =&amp;gt;    Database parameter DB_BLOCK_CHECKSUM is NOT set to recommended value on racdb2 instance\r\n FAIL =&amp;gt;    Database parameter DB_LOST_WRITE_PROTECT is NOT set to recommended value on racdb2 instance\r\n WARNING =&amp;gt; Database parameter DB_BLOCK_CHECKING on PRIMARY is NOT set to the recommended value. for racdb\r\n WARNING =&amp;gt; fast_start_mttr_target has NOT been changed from default on racdb2 instance\r\n\r\n INFO =&amp;gt;    IMPORTANT: Oracle Database SCN Headroom. See Details for More Info \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\n FAIL =&amp;gt;    Your Configuration is NOT in Compliance with Oracle Security Alert for CVE-2012-1675 \/u01\/11.2.0\/grid\r\n FAIL =&amp;gt;    Your Configuration is NOT in Compliance with Oracle Security Alert for CVE-2012-1675 \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\n WARNING =&amp;gt; avahi-daemon process is running\r\n\r\nBest Practice checking completed.Checking recommended patches on 11grac2.\r\n---------------------------------------------------------------------------------\r\n\r\nCollecting patch inventory on  CRS HOME \/u01\/11.2.0\/grid \r\nCollecting patch inventory on ORACLE_HOME \/u01\/app\/oracle\/product\/11.2.0\/db_1 \r\n---------------------------------------------------------------------------------\r\n1 Recommended CRS patches for 112010 from \/u01\/11.2.0\/grid on 11grac2\r\n---------------------------------------------------------------------------------\r\nPatch#   CRS  ASM    RDBMS RDBMS_HOME                              Patch-Description                            \r\n---------------------------------------------------------------------------------\r\n9655006   no          no  \/u01\/app\/oracle\/product\/11.2.0\/db_1GI PSU 11.2.0.1.2 (INCLUDES DATABASE PS      \r\n---------------------------------------------------------------------------------\r\n\r\n---------------------------------------------------------------------------------\r\n26 Recommended RDBMS patches for 112010 from \/u01\/app\/oracle\/product\/11.2.0\/db_1 on 11grac2\r\n---------------------------------------------------------------------------------\r\nPatch#   RDBMS    ASM     type                Patch-Description                       \r\n---------------------------------------------------------------------------------\r\n9218789   no             N-APPLY             N-APPLY BUNDLE PATCH FOR RDBMS 11.2.0.1 \r\n---------------------------------------------------------------------------------\r\n---------------------------------------------------------------------------------\r\n\r\n---------------------------------------------------------------------------------\r\n              Clusterware patches summary report\r\n---------------------------------------------------------------------------------\r\nTotal patches  Applied on CRS Applied on RDBMS Applied on ASM \r\n---------------------------------------------------------------------------------\r\n1              0              0                0              \r\n---------------------------------------------------------------------------------\r\n\r\n---------------------------------------------------------------------------------\r\n              RDBMS homes patches summary report\r\n---------------------------------------------------------------------------------\r\nTotal patches  Applied on RDBMS Applied on ASM ORACLE_HOME    \r\n---------------------------------------------------------------------------------\r\n 26             0              0                \/u01\/app\/oracle\/product\/11.2.0\/db_1\r\n---------------------------------------------------------------------------------\r\n\r\n---------------------------------------------------------------------------------\r\n                      CLUSTERWIDE CHECKS\r\n---------------------------------------------------------------------------------\r\n---------------------------------------------------------------------------------\r\n\r\nDetailed report (html) - \/home\/oracle\/raccheck_racdb_012613_235400\/raccheck_racdb_012613_235400.html\r\n\r\nUPLOAD(if required) - \/home\/oracle\/raccheck_racdb_012613_235400.zip<\/pre>\n<p>\uff08\u4e8c\uff09\u9759\u9ed8\u6267\u884c\uff0c\u4e5f\u5c31\u662f\u975e\u4ea4\u4e92\u5f0f\u6267\u884c\u3002<br \/>\n\u914d\u7f6e\u6240\u6709\u8282\u70b9rdbms\u7684\u7528\u6237oracle\u7684sudo<\/p>\n<pre class=\"wp-code-highlight prettyprint\">[root@11grac1 ~]# cat \/etc\/sudoers | grep oracle\r\noracle ALL=(root) NOPASSWD:\/tmp\/root_raccheck.sh\r\n[root@11grac2 ~]# cat \/etc\/sudoers | grep oracle\r\noracle ALL=(root) NOPASSWD:\/tmp\/root_raccheck.sh\r\n[oracle@11grac1 ~]$ .\/raccheck -s\r\n\r\nChecking ssh user equivalency settings on all nodes in cluster\r\n\r\nNode 11grac2 is configured for ssh user equivalency for oracle user\r\n\r\nSearching for running databases . . . . .\r\n\r\n. \r\nList of running databases registered in OCR\r\n1. racdb\r\n2. None of above\r\n\r\n. . \r\n\r\nChecking Status of Oracle Software Stack - Clusterware, ASM, RDBMS\r\n\r\n. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . \r\n-------------------------------------------------------------------------------------------------------\r\n                                                 Oracle Stack Status                            \r\n-------------------------------------------------------------------------------------------------------\r\nHost Name  CRS Installed  ASM HOME       RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name\r\n-------------------------------------------------------------------------------------------------------\r\n11grac1     Yes             Yes             Yes             Yes        Yes      Yes      racdb1    \r\n11grac2     Yes             Yes             Yes             Yes        Yes      Yes      racdb2    \r\n-------------------------------------------------------------------------------------------------------\r\n\r\n*** Checking Best Practice Recommendations (PASS\/WARNING\/FAIL) ***\r\n\r\nLog file for collections and audit checks are at\r\n\/home\/oracle\/raccheck_012713_093333\/raccheck.log\r\n\r\n=============================================================\r\n                    Node name - 11grac1                                \r\n=============================================================\r\nCollecting - ASM DIsk I\/O stats \r\nCollecting - ASM Disk Groups \r\nCollecting - ASM Diskgroup Attributes \r\nCollecting - ASM disk partnership imbalance \r\nCollecting - ASM diskgroup attributes \r\nCollecting - ASM initialization parameters \r\nCollecting - Active sessions load balance for racdb database \r\nCollecting - Archived Destination Status for racdb database \r\nCollecting - Cluster Interconnect Config for racdb database \r\nCollecting - Database Archive Destinations for racdb database \r\nCollecting - Database Files for racdb database \r\nCollecting - Database Instance Settings for racdb database \r\nCollecting - Database Parameters for racdb database \r\nCollecting - Database Properties for racdb database \r\nCollecting - Database Registry for racdb database \r\nCollecting - Database Sequences for racdb database \r\nCollecting - Database Undocumented Parameters for racdb database \r\nCollecting - Database Workload Services for racdb database \r\nCollecting - Dataguard Status for racdb database \r\nCollecting - Files not opened by ASM \r\nCollecting - Log Sequence Numbers for racdb database \r\nCollecting - Percentage of asm disk  Imbalance \r\nCollecting - Process for shipping Redo to standby for racdb database \r\nCollecting - Redo Log information for racdb database \r\nCollecting - Standby redo log creation status before switchover for racdb database \r\nCollecting - CPU Information\r\nCollecting - CRS active version\r\nCollecting - CRS oifcfg\r\nCollecting - CRS software version\r\nCollecting - CSS Reboot time\r\nCollecting - CSS disktimout\r\nCollecting - Cluster interconnect (clusterware)\r\nCollecting - Clusterware OCR healthcheck \r\nCollecting - Clusterware Resource Status\r\nCollecting - Huge pages configuration\r\nCollecting - Kernel parameters\r\nCollecting - Linux module config.\r\nCollecting - Maximum number of semaphore sets on system\r\nCollecting - Maximum number of semaphores on system\r\nCollecting - Maximum number of semaphores per semaphore set\r\nCollecting - Memory Information\r\nCollecting - OS Packages\r\nCollecting - Operating system release information and kernel version\r\nCollecting - Oracle Executable Attributes\r\nCollecting - Patches for Grid Infrastructure \r\nCollecting - Patches for RDBMS Home \r\nCollecting - Shared memory segments\r\nCollecting - Table of file system defaults\r\nCollecting - Voting disks (clusterware)\r\nCollecting - number of semaphore operations per semop system call\r\n\r\nPreparing to run root privileged commands  11grac1.\r\n\r\nCollecting - CRS user limits configuration \r\nCollecting - CRS user time zone check \r\nCollecting - Custom rc init scripts (rc.local) \r\nCollecting - Interconnect interface config \r\nCollecting - Network interface stats \r\nCollecting - Number of RDBMS LMS running in real time \r\nCollecting - OCFS2 disks \r\nCollecting - Root Open File Limit \r\nCollecting - ocsf status \r\nCollecting - root time zone check \r\n\r\nData collections completed. Checking best practices on 11grac1.\r\n--------------------------------------------------------------------------------------\r\n\r\n INFO =&amp;gt;    $CRS_HOME\/log\/hostname\/client directory has too many older log files.\r\n INFO =&amp;gt;    user_dump_dest has trace files older than 30 days for racdb\r\n INFO =&amp;gt;    background_dump_dest has files older than 30 days for racdb\r\n\u81f3\u540e\u8f93\u51fa\u7701\u7565... ...<\/pre>\n<p>\u5f53\u7136\u8fd9\u4e2a\u8f93\u51fa\u4e5f\u662f\u4e00\u4e2a.zip\u548c\u4e00\u4e2a.html\u6587\u4ef6\u3002<br \/>\n\u5176\u4ed6raccheck\u76f8\u5173\u547d\u4ee4\u53c2\u6570\u53ef\u89c1oracle RACcheck User Guide.<\/p>\n<p>\u4e0b\u8fb9\u5c31\u8d342\u5f20.html\u4e2d\u7684\u622a\u56fe\u5427\u3002<br \/>\n<a href=\"http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/01\/raccheck_01.jpg\" class=\"cboxElement\" rel=\"example_group\"690><img loading=\"lazy\" class=\"alignleft size-medium wp-image-691\" alt=\"raccheck_01\" src=\"http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/01\/raccheck_01-300x144.jpg\" width=\"300\" height=\"144\" srcset=\"http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/01\/raccheck_01-300x144.jpg 300w, http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/01\/raccheck_01-1024x491.jpg 1024w, http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/01\/raccheck_01.jpg 1422w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/01\/raccheck_02.jpg\" class=\"cboxElement\" rel=\"example_group\"690><img loading=\"lazy\" class=\"alignleft size-medium wp-image-692\" alt=\"raccheck_02\" src=\"http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/01\/raccheck_02-300x157.jpg\" width=\"300\" height=\"157\" srcset=\"http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/01\/raccheck_02-300x157.jpg 300w, http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/01\/raccheck_02-1024x537.jpg 1024w, http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/01\/raccheck_02.jpg 1316w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u57fa\u672c\u4ece\u4e0a\u8fb9\u7684\u6982\u89c8\u56fe\u9996\u5148\u5c31\u53ef\u4ee5\u770b\u51fa\u6211\u5f53\u7136rac\u7684\u5f97\u5206\u8fd8\u7b97\u53ef\u4ee5\uff0c\u7136\u540e\u53ef\u4ee5\u53d1\u73b0\u6211\u7684rac\u5b89\u5168\u65b9\u9762\u4e0d\u8fbe\u6807\uff0c\u9700\u8981\u5b89\u88c5\u8865\u4e01\u5305\uff0c\u8fd8\u6709\u5c31\u662f\u4e00\u4e9b\u53c2\u6570\u8bbe\u7f6e\uff0c\u65e7\u6587\u4ef6\u6ca1\u6709\u53ca\u65f6\u6e05\u9664\u7b49\u4e00\u4e9b\u7684warning\u3002\u6574\u4f53\u6765\u8bf4\uff0c\u6211\u7684\u8fd9\u4e2arac\u73af\u5883\u57fa\u672c\u8fd8\u662f\u53ef\u4ee5\u7684\u3002<\/p>\n<p>\u4ee5\u4e0b\u662f\u6211\u572810grac\u4e2d\u4f7f\u7528raccheck\u65b0\u529f\u80fd\u68c0\u67e5HA\u7684\u8fc7\u7a0b\uff08\u6b64\u5904\u4e3a\u9759\u9ed8\u6536\u96c6\uff09<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@rac1 ~]$  .\/raccheck -c hacheck -s\r\n\r\nChecking ssh user equivalency settings on all nodes in cluster\r\n\r\nNode rac2 is configured for ssh user equivalency for oracle user\r\n \r\n\r\nSearching for running databases . . . . .\r\n\r\n. \r\nList of running databases registered in OCR\r\n1. racdb\r\n2. None of above\r\n\r\n. . \r\n\r\n\r\nChecking Status of Oracle Software Stack - Clusterware, ASM, RDBMS\r\n\r\n. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . \r\n-------------------------------------------------------------------------------------------------------\r\n                                                 Oracle Stack Status                            \r\n-------------------------------------------------------------------------------------------------------\r\nHost Name  CRS Installed  ASM HOME       RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name\r\n-------------------------------------------------------------------------------------------------------\r\nrac1        Yes             Yes             Yes             Yes        Yes      Yes      racdb1    \r\nrac2        Yes             Yes             Yes             Yes        Yes      Yes      racdb2    \r\n-------------------------------------------------------------------------------------------------------\r\n\r\n*** Checking Best Practice Recommendations (PASS\/WARNING\/FAIL) ***\r\n\r\n\r\n\r\nLog file for collections and audit checks are at\r\n\/home\/oracle\/raccheck_012813_161936\/raccheck.log\r\n\r\n=============================================================\r\n                    Node name - rac1                                \r\n=============================================================\r\nCollecting - Database Parameters for racdb database \r\nCollecting - Database Undocumented Parameters for racdb database \r\n\r\nPreparing to run root privileged commands  rac1.\r\n\r\n\r\n\r\nData collections completed. Checking best practices on rac1.\r\n--------------------------------------------------------------------------------------\r\n\r\n\r\n FAIL =&gt;    Database parameter DB_BLOCK_CHECKSUM is NOT set to recommended value on racdb1 instance\r\n FAIL =&gt;    Flashback on PRIMARY is not configured for racdb\r\n WARNING =&gt; RMAN configuration for controlfile autobackup is NOT configured for racdb\r\n FAIL =&gt;    Consider configuring an archivelog deletion policy. Erroneous deletion of archivelog files will affect database recovery. for racdb\r\n=============================================================\r\n                    Node name - rac2                                \r\n=============================================================\r\n\r\nPreparing to run root privileged commands  rac2.\r\n\r\n\r\n\r\nData collections completed. Checking best practices on rac2.\r\n--------------------------------------------------------------------------------------\r\n\r\n\r\n FAIL =&gt;    Database parameter DB_BLOCK_CHECKSUM is NOT set to recommended value on racdb2 instance\r\n---------------------------------------------------------------------------------\r\n \r\nDetailed report (html) - \/home\/oracle\/raccheck_racdb_012813_161936\/raccheck_racdb_012813_161936.html\r\n\r\n\r\nUPLOAD(if required) - \/home\/oracle\/raccheck_racdb_012813_161936.zip\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>RACcheck (RAC Configuration Audit Tool)\u4f7f\u7528\u4ecb\u7ecd \u8fd9\u4e2a\u5de5\u5177\u4e0d\u4f46\u65b9\u4fbfdba [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35,9],"tags":[110,106,105,107,108,109],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/690"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=690"}],"version-history":[{"count":7,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/690\/revisions"}],"predecessor-version":[{"id":694,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/690\/revisions\/694"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=690"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}